In the continuing journey to track down impacted objects and to determine when the code in a database was last changed or added, here is another quick SQL, which can be used in Aginity Workbench for Netezza to retrieve a list of when Store Procedures were last updated or were created. SQL List of When A Stored Procedure was … Continue reading Netezza / PureData – How To Get A List Of When A Store Procedure Was Last Changed Or Created
Tag: #databaseadministration
Netezza / PureData – How To Get a SQL List of When View Was Last Changed or Created
Sometimes it is handy to be able to get a quick list of when a view was changed last. It could be for any number of reason, but sometimes folks just lose track of when a view was last updated or even need to verify that it hadn't been changed recently. So here is a quick … Continue reading Netezza / PureData – How To Get a SQL List of When View Was Last Changed or Created
Netezza / PureData – How To Quote a Single Quote in Netezza SQL
How To Quote a Single Quote in Netezza SQL? The short answer is to use four single quotes (''''), which will result in a single quote within the select statement results. How to Assemble the SQL to Quote a Single Quote in a SQL Select Statement Knowing how to construct a list to embed in … Continue reading Netezza / PureData – How To Quote a Single Quote in Netezza SQL
Netezza / PureData – How to build a multi table drop command from a select
How to Quick Drop Multiple Tables occasionally, there is a need to quickly drop a list of tables and you don't always want to write or generate each command individually in Aginity. So, here is a quick example of how you can use a 'Select' SQL statement to generate a list of drop commands for you. Now, … Continue reading Netezza / PureData – How to build a multi table drop command from a select
How to know if your Oracle Client install is 32 Bit or 64 Bit
How to know if your Oracle Client install is 32 Bit or 64 Bit Sometimes you just need to know if your Oracle Client install is 32 bit or 64 bit. But how do you figure that out? Here are two methods you can try. The first method Go to the %ORACLE_HOME%\inventory\ContentsXML folder and … Continue reading How to know if your Oracle Client install is 32 Bit or 64 Bit
OLTP vs Data Warehousing
OLTP Versus Data Warehousing I’ve tried to explain the difference between OLTP systems and a Data Warehouse to my managers many times, as I’ve worked at a hospital as a Data Warehouse Manager/data analyst for many years. Why was the list that came from the operational applications different than the one that came from the … Continue reading OLTP vs Data Warehousing
Netezza / PureData – Table Describe SQL
If you want to describe a PureData / Netezza table in SQL, it can be done, but Netezza doesn’t have a describe command. Here is a quick SQL, which will give the basic structure of a table or a view. Honestly, if you have Aginity Generating the DDL is fast and more informative, at least … Continue reading Netezza / PureData – Table Describe SQL
