[ www.netezza.com ]
Previous Next

Enzee Universe

August 2009
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

3 Comments Permalink
SRIDHAR BABU

Hi .

I am .Net [C#] developer and using Netezza as database in my Latest application.

I wrote a small application to get the data from Netezza and using odbc driver.

Its returning the rows and in middle I am getting below msg.

 

ERROR [08S02] Unexpected protocol character/message

System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcDataReader.Read()

 

Source is nsqlodbc.dll.

 

Please some could help me.

 

thanks

Babu

0 Comments Permalink
SRIDHAR BABU

Hi Good Monring all,

 

We are syncing the Data from SQL Server to Netezza and some special charactes are not converting

 

For Example  -

 

MC21-‘90s [SQL Server]               MC21-?90s [Netezza]

Please can some one help me

thanks

4 Comments Permalink
Bookmark and Share

Actions

Popular Blog Posts