DSXchange

May I know the purpose of using trim for all the column.
Yes, you try the option suggested by prabu. By using trim, you are removing the left out space, where the target expects at least 5 space in the char. If trim is part of your logic, you can use handle_null.

I got the similar kind of message in my case the joining key was decimal when I converted that to varchar , its is working fine. Not really sure if Join Stage can handle numeric keys Join stage will work irrespective of data types, but this error message is different from what you expect. Is you so...

Are you running with the same user id and permissions? was there any other change occured in your environment?

For the data type of varchar it is ok to give single space, in case of char datatype it is must to have 5 spaces. If it is decimal , it would be considired as null. There may be some other reasons, like unique constrains voilation for record reject.

Hi,
May I know what you mean " i cannot telnet to the server as it is picked up by the DataStage telneting utility."
Is it blocked at your end?

Can you tell us,what is your exact requirement. If you need to pass on some value from one job to another as parameter, you can use JobStatus option available in JobSequence. Search for the same, it has been discussed. Optionally, you can write to a external file, say hashed or sequential file, and ...

As Ray mentioned, you can use stage variable for row to row comparision. But what do you mean accumulating codes. If it is simple sum up, you can use aggregator stage with respective partition instead.

Isn't the v7.5.2 a window based server? Are migrating from unix to windows?

The funny thing is it runs from command line from server.

Do you mean to say only from server machine and not even in any of your client machine. How do you call from Tivoli workflow Manager, is it same as the command used to call from server?

It is again highly depends on the datatype of that column. And more over, what is the output log given by datastage for the row reject.

You call even using native oracle stage in user defined query. {call storedprocedure(?,?,...)}. but what is the error message given when it got aborted.

If your timestamp is with ' ', which is in string format, try using StringToTimestamp to convert to timestamp and later you can tyr using the mentioned function.

It shows that the internal file created able to view.
As suggested check whether inactivity timeout option available in datastage adminstrator client for the project is not give with any min second. If so check the 'Do Not Timeout'.

I guess the temp file produces by one Basic transformer is geting cleared by another which is running in parallel.
But why Basic Transformer in PX. Why cant the same routering function be made in PX transformer.
The main reason for ds_ipcopen() would be due to this.

I think my packed fields has characters also... I am getting thid error when I used the routine "Error, unable to convert ' Z ' into number". Could you please tell me how to convert this. Your input shouldnt be declared as integer. It was asked to make as character and output after the conversion s...