DSXchange

Do you have any other stages like IPC or Link Partioner in your job design. Once had a similar problem and removed the IPC and it performed OK.

Another option I found in the forum is to check inter process under Enable row buffer option and increase the time out-say 60sec.

HTH

Trim function with option D

Removes leading and trailing spaces and tabs, and reduces multiple spaces and tabs to single ones.

Do you have enough space on the disk where you are writing your target file.

somewhere you are carrying addional columns either in Datastage or the target SQL code..

Check your metadata for Balanced_Qty, did you mention the same scale and precision for the field as it appears in the data.

Are you trying to insert Decimal value into an Integer, it looks an issue with datatype.

Sri,

What do you want to do here. Do you want to insert duplicate data into the target table. If not why dont you update and insert.

Is anyone of the jobs renamed or missing, i think its not abel to attach the job. Can you please post the complete error message.

thumsup9 wrote:Something like this with a Unix Shell Script

for file in *
do
mv "${file}" "${file}".txt.`date`
done

oops realized you are working on Windows..

Something like this with a Unix Shell Script

for file in *
do
mv "${file}" "${file}".txt.`date`
done

Trim(Ereplace(Oconv(Input,"MCP"),'.',''))

May be this will work.

Third Warning : Sequential_File_31: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. [quote] I think you are trying to Preserve partition while writing to a Seq File and hence this error. Try Clear instead of Preserve before wr...

Kris,

What happens when you reload your data using Trim(Convert(Char(000),'',Input)) instead of Trim() in your transformer stage.

Thums!!

Nielsek,

I will probably do using some unix commands like "tr - d" or :%s/.^H//g if the source file is a sequential file. Search for Control Characters and you will find some interesting threads in this forum.

CALL_FUNCTION_SIGNON_REJECTED Google says.. Cause: The user tried to log onto the target system without a valid user ID. Runtime Error: CALL_FUNCTION_SIGNON_REJECTED The error code signifies the following: 1) Incorrect password or invalid user ID 2) User locked 3) Too many logon attempts 5) Error in...