DSXchange

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

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

I had Longnvarchar datatype also along with the datatypes u mentioned

Use "nvarchar"

SQL server does not support longnvarchar

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

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