I'm no expert, but you can take a look at the attached document.

Essentially  you need Netezza ODBC driver, odbc.ini (configured) and DBD::ODBC perl mod.

Suman,

I copied from the perl scripts on the Netezza server....

#!/usr/bin/perl
use Getopt::Long;
require "/nz/kit/share/perl/nz/SQL.pm";

my $verbose;
my $PROCID=$$;
my $PROCNAME=$0;
my $DBNAME=$ENV{NZ_DATABASE};

    $result = GetOptions ("verbose"  => \$verbose);  # flag

    if ( $verbose) {
        print " Usage: test.pl ";
        exit(0);
    }

    %myopt = ( KITDIR=> '/nz/kit' );
    nz::SQL::config(%myopt);
    my $sql;
    $sql = (" select 'somecol' as col1, 'col2' as col2 ");
    my $qresp = nz::SQL::query($DBNAME, $sql);
    my $errstr = nz::SQL::error();
    if ($errstr) {
        print "Sql Error $errstr sql =$sql\n";
        exit(99);
        }

    foreach my $row (@{$qresp->{data}}) {
        ($col1) = (@$row);
        print "New row Data: $col1\n";
        if ( $col1 =~ m/somecol/ ) {
                print "do something here\n";
        }
    }
    exit(0);

DBD::ODBC is an option but requires other components to install so go with the KISS method.

Frank