This is the one of the feature that most of people are waiting since long time. Finally, IBM has added Netezza DROP TABLE IF EXISTS feature in its latest release i.e. Netezza 7.2.X. We will discuss this feature with an example in this article. Netezza DROP TABLE IF EXISTS The Netezza DROP TABLE IF EXISTS option is typically used for scripted applications that are running lot of SQL commands, and you want to suppress the ‘table already exists error message so that it does not halt the scripted application. The…

This is the one of the feature that most of people are waiting since long time. Finally, IBM has added Netezza CREATE TABLE IF NOT EXISTS feature in its latest release i.e. Netezza 7.2.X. We will discuss this feature with an example in this article. Netezza CREATE TABLE IF NOT EXISTS The IF NOT EXISTS option is typically used for scripted applications that are running lot of SQL commands, and you want to suppress the ‘table not found’ error message so that it does not halt the scripted application. The…

You can unload the tables for number of reasons such as take backup of table, send data to external customer or copy data to other appliance. In this article, we will check on Netezza Unload table using external tables and some examples. Netezza Unload Table using External Tables You can unload data from a user table into an external table and load data from an external table into a user table by using the text-delimited format. If you want to create the fixed-width file using external tables then you will…

When you are working on Netezza data warehouse (IBM Puredata Systems) appliance, you will be executing multiple SQL statement in single SQL file. In this article, we will discuss about the Netezza SET ON_ERROR_STOP variable to stop the execution in case one of the sql statement encountered error inside script. Without this variable, Netezza will continue with other statements ignoring the failed query. Netezza SET ON_ERROR_STOP Netezza nzsql command with option -f executes all sql statements in the files. If you want the nzsql command to stop and exit when…

You might know how the Netezza generate statistics works and how to generate the stats on the tables. Read my other post Netezza generate statistics: Best Practices. In this post, we will discuss about the Netezza Just in Time (JIT) statistics. Netezza Just in Time (JIT) statistics The Netezza system automatically generates Just in Time (JIT) statistics on user tables to help the optimizer refine planning when you fire the query to Netezza system. Netezza JIT statistics comes handy when there is a skew in the table, it improves the…

If you are a business analyst or data architect then you have to work on the different database to identify the relevant data to come up with business decisions on a particular design. You can connect to multiple databases from the current Netezza sessions using Netezza SET CATALOG command Use the SET CATALOG command to connect to a different Netezza database in the same session. This command is the session specific i.e. as soon as the execution ends in current session; Netezza reverts back to the original database. Read: Commonly…