[ www.netezza.com ]
Previous Next

Enzee Universe

Currently Being Moderated
SRIDHAR BABU

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



Aug 25, 2009 6:35 PM James Karioki James Karioki    says:

To create a text-format external table, enter:

CREATE EXTERNAL TABLE extemp SAMEAS A USING (DATAOBJECT ('/tmp/a.txt'));

 

To unload data in user table A to the external table EXTEMP, enter:

INSERT INTO extemp SELECT * FROM A;
Oct 20, 2009 11:29 AM David Birmingham David Birmingham    says in response to James Karioki:

more spontaneously, try:

 

nzsql -d mydatabase -A -q -t -c "select * from tablename;" > flatfilename.dat
Nov 6, 2009 5:21 PM sansanjuan sansanjuan    says in response to James Karioki:

Or to land on a PC

 

CREATE EXTERNAL TABLE 'c:\temp\pc_example.csv'

USING( format 'text'

compress false

delimiter '|'

remotesource 'odbc'

)

AS

select 1 anchor,decm_code,replace(condition_status_description,';',',') etg_desc from foo_etg_icd9 where lower(etg_desc) like '%diabetes%'
Bookmark and Share

Actions

Popular Blog Posts