DSXchange

You have NLS enabled in DataStage. But is it enabled in the database. Disable NLS and then run the job.

What is sqltype and length of field 37? With the first column starting from 0. Do you have NLS enabled?

Search is your friend. Reference this similar post.

Well i guess then you will have to do a spot check and see what column is larger than expected by the target. Either one or more column size is greater than your target column and hence the error.

Are you trying to read the entire record as a single column ?
What other warning messages do you get? Maybe the length in the target database is less than what you are trying to insert.

Do it via a script. Really small and easy. Something like this #!/usr/bin/ksh export file=/..../..../...../ProjectNames.txt export jobNames=/..../..../.../AllJobs.txt #Source the dsenv file cd $DSHOME . ./dsenv #Remove AllJobs.txt from previous run rm -f $jobNames cat $file | while read projname do ...

The ICONV/OCONV conversion code that gets this done is "MCT".

Welcome Aboard As a friendly advice, please dont use words like 'urgent', 'ASAP' here as it will get nothing but negative feedback. This is an all volunteer site and response times vary. Also, we have different forums depending upon the nature of the quest. You have posted in the wrong forum. We hav...

Seems like someone changed the column name and did not tell you about it. Heres some more detail.

No, i didnt mean how it looks like, i meant how are you getting it? Are you using the notification activity to include job report, do you have a custom routine to get the job status?

Search. This has been covered before. Like here.

I suspect that the job is starting porperly, but the status is not updated promptly. Tell me this, if you run the job manually from director, do you observe the same delay?

How many keys do you have defined in your target table? SCD2 means you will have to update too, are you doing that, how exactly are you doing that?

How would we know, it could be a number of reasons. There should be more warning messages in the log. Paste all the warning messages that you are getting, including the fatal error.

You have posted in a px forum and marked the job type as server, which one is it?