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
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
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
Displaying your Netezza query results in a grid can be useful. Especially, when desiring to navigation left and right to see an entire rows data and to avoid the distraction of other rows being displayed on the screen. I use this capability in Aginity when I’m proofing code results and/or validating data in a table. … Continue reading Aginity for Netezza – How to Display Query Results in a Single Row Grid
Here is a synopsis of the temporal ranges ( date, time, and timestamp), which Netezza / PureData supports. Temporal Type Supported Ranges Size In Bytes Date A month, day, and year. Values range from January 1, 0001, to December 31, 9999. 4 bytes Time An hour, minute, and second to six decimal places (microseconds). Values … Continue reading PureData / Netezza – What date/time ranges are supported by Netezza?
DDL (Data Definition Language) Adding a forging key to tables in Netezza / PureData is a best practice; especially, when working with dimensionally modeled data warehouse structures and with modern governance, integration (including virtualization), presentation semantics (including reporting, business intelligence and analytics). Foreign Key (FK) Guidelines A primary key must be defined on the table … Continue reading Netezza / PureData – How to add a Foreign Key
Rebuilding Netezza view sometimes becomes necessary when the view’s source table have changed underneath the view. Rebuilding a view can be done on Netezza or in Aginity. In Aginity, it is a simple process, assume your user has permissions to create or replace a view. The process breaks down into just a few steps: … Continue reading Netezza / PureData – How to rebuild a Netezza view in Aginity