Hi

I am using below sql to load the data from flat file to Netezza

INSERT INTO A
SELECT * FROM EXTERNAL 'c:\data\a.txt'
USING ( BOOLSTYLE '1_0' COMPRESS FALSE CRINSTRING FALSE CTRLCHARS FALSE DATEDELIM '-' DATESTYLE 'YMD' DELIMITER 'TAB' ENCODING 'latin9'
FILLRECORD FALSE IGNOREZERO FALSE LOGDIR 'c:\data'
MAXERRORS 1 MAXROWS 0 NULLVALUE 'NULL' QUOTEDVALUE 'NO' REMOTESOURCE 'jdbc' REQUIREQUOTES FALSE SKIPROWS 0
SOCKETBUFSIZE 8388608 TIMEDELIM ':' TIMEEXTRAZEROS FALSE TIMESTYLE '24HOUR' TRUNCSTRING FALSE Y2BASE 0)

I want in reverse order I mean I want select the data from table and place in flat file.

Please some one could help me.

thanks

Babu