DSXchange

It is 'Drop Storage'.
You can check it with the following query. Run this before and after the job execution.

Try just passing CommandOutput to the Job Activity and add the value 1 inside job.

Why it doesn't work? Are you getting any error or it doesnt give the expected value? Explain how are you passing the value.
You can use the ReturnValue of the ExecuteCommand Acitivity to pass the value of the output. And you can manipulate the same in the Job.

Or the same can be found in the previous post.

If you are using database stage, you can use TO_DATE() to convert it into the required date format.

Search will help you "If doing a load and the table space is not in load pending state, correct the problem and invoke the load utility again. If the table space is in load pending state, then invoke the load utility in RESTART or REPLACE mode, or restore a backup of the table space(s)....

You check for this possible cases, "The parameter contains a path, directory, or file name that is not valid. For IMPORT and EXPORT, verify the datafile parameter. For LOAD, verify that each entry in the parameters of type sqlu_media_list : datafile should contain valid filenames; lobpaths copytarge...

Or include this in your .profile so that it can be maintained for all the sessions for that user id. You can prescribe the same for other users as well.

This is the reason why the Hash partition is preferred over Auto. If one stream is already partition in previous stages, it may be maintained as Same and the other might be Hash partitioned. Sort might be inserted, but it again doesnt help you much, if the partition are different.

Either include another stage after the target stage, or make use of Afterjob Subroutine with the command line options for the database.
But you can mention the edition of the Datastage, to get more appropriate answers.

Fantastic Sixer from Arnd.
That was a Great work!!!
Keep going. :D

Unable to allocate communication resources

You may even need work on the final error message. Check if you are exceeding the maximum number of processes allowed per user.

You already got the most important points. To add up, the other point wehre we lookup for is complex transformation logic.

Stable sort will try to maintain the position of the input data as it is within the same group. Performance point of view, this can be avioded unless requried otherwise. Unique will try to aviod the repeated keys. Perform sort option will to inline sort before the sort stage. No need to check if you...

Hi Welcome aboard!!! :D
You can simply use sort stage and sort based on Proposal_id and include a column to detect the change in Key column option to have the serial number to be generated. Optionally you can use transformer to detect the change in previous row to the current row.