Netezza / PureData – How to Substring on a Character

  I had a reason this week to perform a substring on a character in Netezza this week, something I have not had a need to do before.  The process was not as straightforward as I would have thought, since the command is explained as a static position command, and the IBM documentation, honestly, wasn’t … Continue reading Netezza / PureData – How to Substring on a Character

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

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

Netezza / PureData – Aginity for Netezza shortcut key list

Recently, while working with a couple of my teammates on different projects I picked up a couple shortcut keys for Aginity for netezza, which I did not know existed. So, I thought about be nice to put a list of shortcut keys for future reference. I don't use most of them very often, but I … Continue reading Netezza / PureData – Aginity for Netezza shortcut key list

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