[ www.netezza.com ]
Up to Discussions in Competitive Product Chat
2 Replies Last post: Oct 2, 2009 12:54 AM by hamzaqk  
hamzaqk  
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  
David Shuttleworth
224 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.

Report Abuse
hamzaqk  
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

Report Abuse

More Like This

  • Retrieving data ...