Is it possible to load a bulk text file into a table instead of an external table in Netezz?

Question

I load data into Netezza from a text file using EXTERNAL TABLE, and after loading the data into an external table, I update these some columns in the same external table, since you cannot update the external table. I need to execute all the data from an external table to one Temp table, and how can I do the updates, while is there another way when I can directly load the text file data into a table instead of an external table in Netezza?

Answer 1

If you use direct ODBC. I would consider a "temporary external table"

INSERT INTO target_table SELECT * FROM EXTERNAL 'C:\FileName.txt' using( delim '|' datestyle 'MDY' datedelim '/' REMOTESOURCE 'ODBC' MAXERRORS 50 LOGDIR 'C:\');

Answer 2

Take a look at nzload http://www.enzeecommunity.com/message/12759

Example: To load the dev database as a user administrator with password generation, specify the name of the isacode table using tab delimiters and specify the input file as the telephone prefix. dat, enter:

nzload -u admin -pw production -db dev -t isacode -delim '\ t' -df phone-prefix.dat

Answer 3

Try nzload as @cairnz said. In addition, if you connect via ODBC, you can use the REMOTESOURCE ODBC option to load from a text file into a table, bypassing the creation of a separate external table. Take a look at the Netezza Data Download Guide provided by IBM.