Netezza / PureData – How To Get A List Of When A Store Procedure Was Last Changed Or Created

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

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

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

Aginity For Netezza – How to Generate DDL

How to Generate Netezza Object DDL In ‘Aginity for Netezza’ this process is easy, if you have a user with sufficient permissions. The basic process is: In the object browser, navigate to the Database select the Object (e.g. table, view, stored procedure) Right Click, Select ‘Script’ > ‘DDL to query window’ The Object DDL will … Continue reading Aginity For Netezza – How to Generate DDL

Netezza / PureData – Substring Function Example

The function Substring (SUBSTR) in Netezza PureData provides the capability parse character type fields based on position within a character string. Substring Functions Basic Syntax SUBSTRING Function Syntax SUBSTRING(<<CharacterField>>,<< StartingPosition integer>>, <<for Number of characters Integer--optional>>)   SUBSTR Function Syntax SUBSTR((<>,<< StartingPosition integer>>, <>)   Example Substring SQL Substring SQL Used In Example SELECT  LOCATIONTEXT … Continue reading Netezza / PureData – Substring Function Example

Netezza / PureData – Substring Function On Specific Delimiter

The function Substring (SUBSTR) in Netezza PureData provides the capability parse character type fields based on position within a character string.  However, it is possible, with a little creativity, to substring based on the position of a character in the string. This approach give more flexibility to the substring function and makes the substring more … Continue reading Netezza / PureData – Substring Function On Specific Delimiter