Let us assume you are migration data from one Netezza server to other or new higher version Netezza server. Once the migration is completed, you have to perform some mandatory checks such as availability of objects, compare count of all table between two servers. In this article, we will discuss on Netezza Count Records from all Tables in Database and some Example. Check: IBM Netezza Count All Database Objects – System Table Query Netezza Pivot  Rows to Column with Example IBM Netezza Split Delimited Fields into Table Records and Examples…

You can insert new records and update existing by using nzload command itself. In this article, we will discuss about the new feature introduced in nzload. Netezza version 7.2.x supports the Netezza nzload merge operations. Netezza nzload merge operations The Netezza nzload command now supports merge operations to enable this new feature you must use three new options in nzload: -merge option—Specifies whether to merge the contents of the data file into the target table by inserting rows, updating rows, or both INSERT - Inserts new rows into the table. UPDATE…

Like any other database such as Oracle, Netezza also allows you to load data using control files. In this article, we will discuss about the Netezza nzload control files and its syntax with examples. Using a nzload control file, you can define load operations in a text file instead of having to specify options on the command line. You can specify the information such as data file name, log file details etc in control file. You can also use control files to run multiple concurrent table loads, with different options…

In this article, we will look into new features that are introduced in the Netezza latest version 7.2.X. IBM Netezza Latest Version New Features includes some useful developer features. Below are the some of the important new features which developer can use. Read: Netezza Striper Features Big Data Appliance Netezza Key Features Netezza Mako Features Netezza Concurrent Truncate Support In Netezza version 7.2.x and later, disk storage for a truncated table is freed only when there are no active concurrent transactions that are started before system committed the TRUNCATE table.…

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…