Jive SBS Syndication Feed

Select data from table insert into flat file...

communityadmin@netezza.com — Tue, 25 Aug 2009 22:21:31 GMT

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

ERROR [08S02] Unexpected protocol character/message

communityadmin@netezza.com — Tue, 25 Aug 2009 21:48:47 GMT

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

Sync problem from SQL Server to Netezza

communityadmin@netezza.com — Mon, 17 Aug 2009 20:00:43 GMT

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