DSXchange

From the way you have posed the problem, it would seem that both the input and the output are comma-separated files. I would read the input as 12 columns and in a transform stage create a new string that is built up like AccName1:',':AccAddress1:',':AccName2:',':AccAddress2: etc. Then you could do a...

The error sounds like it is generated from something in the shared container. Shared containers are loaded into the job executable at compile-time.
Does the shared container call any UNIX programs or the like?

Does the record get written if you drop this column?

What is your target stage type? What have you set as the default value for the column? Is the output column nullable? Have you though about putting in a reject link?

Hello Babbu, you don't seem to understand the concept - numbers (integer,real,decimals) are stored as binary values and there is no concept of leading zeroes or any other formatting. That comes about when the value is displayed or converted to a string. In your example you created a nicely formatted...

you cannot append leading zeroes to an integer. Change your output datatype to VarChar() to get your Str() function to work.

Babbu, you didn't ask a question. Is this function not working, and if so, what output do you get? What is the data type of the resulting column? It it is still integer then remember, numeric columns have no leading zeroes , so you string function would create a valid string with leading zeroes, whi...

in the source file stage, right mouse click on the "id" column and select "edit row" to get to the window which allows you to set attributes per column.

If you have alread shut down datastage, then you can use "ipcrm -m" to get rid of those two entries. FIN_WAIT and CLOSE_WAIT status on Solaris are set to timeout after a given period of time, use "ndd -get /dev/tcp tcp_time_wait_interval" to get the timed wait interval and "ndd -get /dev/tcp tcp_fin...

you have a source file with empty columns, not NULLs (there is a big difference). What data type have you defined the "id" column? You will need to set the "default" value of that column to some value or make the column nullable in order to read that row.

Handling of rejects is possible at any point in time in DataStage. You need to know what type of rejects you are looking for - the first response was assuming you had output to a database or output link which failed, other type of rejects such as bad column values are usually handled within the job ...

By far the simplest and easiest method is to start the DataStage lock daemon (change the "dsdlockd.config" value "start=1" or search DSXChange in order find posts describing this in more detail). This will automagically take care of your locks so that you don't need to go around tracing locks and pr...

That part of the core analysis doesn't help to much. I would recommend removing one stage, i.e. the source Oracle stage, and replacing it with a sequential file source. Re-run the job to see if the error goes away. If not, revert to the original and this time change the looup to a hashed-file lookup...

Even though you posted in "General" you marked it as a PX question. Reject links in PX come off the output stage and reflect the input data as well as SQL or other errors where applicable.

Yes, you can install several instances of the DataStage engine on the same machine.
I don't know if the the 7.5.3 and 7.5.1 clients are compatible, if they are then you can use the 7.5.3 to speak to either instance of DS. If not, you would need to work with the multiple client manager.