SQL Server data type not supporte

samsuf2002 · Post by **samsuf2002** » Tue Jul 11, 2006 12:55 pm

Hai I am using sequential file as a source and SQL server plugin as a Target
When I am running the Job its giving a fatal error

main_program: Fatal Error: SQL Server data type not supported

and a phantom error

Contents of phantom output file =>
DataStage Job 50 Phantom 4540

i need some help to sort this out

kcbland · Post by **kcbland** » Tue Jul 11, 2006 12:59 pm

Welcome aboard. What data types are in your target table that aren't CHAR, VARCHAR, INTEGER, DATE, TIMESTAMP?

vsi · Post by **vsi** » Tue Jul 11, 2006 1:07 pm

I had Longnvarchar datatype also along with the datatypes u mentioned

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Jul 11, 2006 1:36 pm

Use "nvarchar"

SQL server does not support longnvarchar

vsi · Post by **vsi** » Tue Jul 11, 2006 1:56 pm

I used varchar and ran the job but noresult its comping up with the same problem

DSguru2B · Post by **DSguru2B** » Tue Jul 11, 2006 2:02 pm

Is your environment NLS enabled? If its not then why you using longnvarchar or even nvarchar, just use varchar.

DSXchange

SQL Server data type not supporte

SQL Server data type not supporte

datatype not supported