Netezza Utilities

Posted: September 30, 2014 in Netezza Migration
The 2 frequently used Netezza Utilities are as follows

NZSQL and NZLOAD

The nzload command returns three status codes. They are

  • 0: Nzload command is success and the data is loaded into the target table.
  • 1: Nzload command is success. However errors are occurred in loading. But the number of errors does not exceeded the -maxErrors option
  • 2: Nzload command failed

Let’s see how to create a generic script and pass the sql script from file to the generic script.

How to call this script in Informatica command task and pass the SQL script file name as parameter.

Lets first create a generic script for the following operations. 
1)Select 
2)Insert 
3)Delete
4)Update

To make the script generic we need to have a profile file which hold the parameter file values need for the script.


Lets see how the above values will be used in the script

Lets see how to call this script from informatica command task

Lets see the PROD_DIM_SQL Script, that we are passing as parameter in the above example.

In netezza :WH_DBNAME act as parameter
: is the syntax for defining a parameter (similar to “$” is the syntax for shell script or Teadata bteq Script)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s