Skip navigation
Up to Discussions in Competitive Product Chat
21920 Views 4 Replies Latest reply: Oct 21, 2010 12:16 PM by kmohan RSS
hamzaqk New Enzee
hamzaqk
2 posts since
Oct 1, 2009
Currently Being Moderated

Oct 1, 2009 7:54 AM

Netezza load and export utilties?

Hi,

 

I have been working on teradata for quite some time and i wanted to know if there are any load and export utlities in netezza also. I.e. in teradata we have utilities like fast load( to bulk load) and fast export ( to bulk export data) from the tables. Apart from this there are also transformation scripts that can be written in TD knows as ( BTEQS).

 

Would appreciate if someone could let me know if there are equivalents of these in netezza and if not how can this be acheived through netezza.

 

Sample scripts welcomed.

 

Many thanks

  • David Shuttleworth Active Enzee
    David Shuttleworth
    270 posts since
    May 14, 2008
    Currently Being Moderated
    1. Oct 1, 2009 8:33 AM (in response to hamzaqk)
    Re: Netezza load and export utilties?

    The netezza equivalent of fastload is nzload - see the documentation in the System Administrator's Guide. There is no specific utility to do 'Fast Export' as such - you can use nzsql (which is similar in funtion to Teradata BTEQ) and direct output to a file, or use External Tables to get data out of the Netezza database. All of these features are covered in the standard documentation.

     

    D.

  • hamzaqk New Enzee
    hamzaqk
    2 posts since
    Oct 1, 2009
    Currently Being Moderated
    2. Oct 2, 2009 12:54 AM (in response to David Shuttleworth)
    Re: Netezza load and export utilties?

    great thanks. i will explore these two

  • suyog New Enzee
    suyog
    1 posts since
    Oct 21, 2010
    Currently Being Moderated
    3. Oct 21, 2010 7:00 AM (in response to David Shuttleworth)
    Re: Netezza load and export utilties?

    Hi ,

     

    I am trying to create 'EXTERNAL TABLE' on a select query .

     

    I am using a shell as a wrapper script , can u tell me the connection string to connect to netezza through shell ?

  • kmohan New Enzee
    kmohan
    69 posts since
    Oct 23, 2006
    Currently Being Moderated
    4. Oct 21, 2010 12:16 PM (in response to suyog)
    Re: Netezza load and export utilties?

    Set the following Environment variables and your are set

     

    NZ_HOST

    NZ_USER

    NZ_PASSWORD (could do by OS authentication)

    NZ_DATABASE

     

    then you can just call nzsql

     

    Else call

    nzsql -host Hostname -d Database -u user -W password

     

    Here is an example

    nzsql -host myhost -d mydb -u myuser -W secret << EOF

    -- Any SQL Statements ex:

    SELECT current_date;

    EOF

     

    retval=$?
    if [ $retval -ne 0 ]
    then

    retval=$?

    if [ $retval -ne 0 ]

    then

    # Write Error messages
    fi

     

    Regards

    Krish Mohan

     

    "Give me a lever big enough and I will move the World" - Archimedes

More Like This

  • Retrieving data ...

Bookmarked By (0)