DSXchange

Why do you want batch SID for jobs. Job are uniquly named, so no need to serialize it. If you are using any multiple instance job, and if you are expecting the invocation id to be serialized, you have several option. Or if you are expeting the jobs to have release no, it is done by version control. ...

Not "DS-TOOL " but "DS.TOOLS". Issue this command in the "Command" option available in DS Administrator.
Or you can try TCL, its easy to use GUI.

may be you can share, Under what curcumstance you are using the long expression, so that you may get a better approach.

Ask your organisation to provide you corporate training. You will be provided with necessary materials. Else look for Server to Px Transition lab in this forum.

It would have given an SQLCode while getting aborted. You can identify the reason why is got it.
Most likely, temporary files used by that run might not have permission or accessed by other application like database frontend.

As spotted by baliji, if it a variable length file, it should be delimited. Where as fixed width doesnt require any.
In PX, warning will appear if you specify the delimiter with short length. So check whether you have specifed the right delimiter and length for each column.

Hey, I dont understand why we are using aggregator in between. what I see from example is data is at emp & dept level. then why we are agregating group by emp & dept. (as it is already aggragated) Just sort it descending by salary & get the first row Let me know if I am wrong. - Mandar ...

Should be issue with licence of your C++ or with the version. Do a search you can find many similar isses here.

Is it you are converting the decimal to varchar, else space and trim wont help you.

Any join on the same table without any filter will give the same result. Because you will find all the records getting matched.

Can you post the exact deadlock error message. Most likely, if it is a database deadlock errors, its cause would be from an external system. May be some other job or the same job might to access the same table at same time. Or input from the table and update the same table.

then i have to load one row data a,b into target db instead 2 rows a,b. The solution was give to you earliar. You need to tweak the given code. If you have understood the given query and the job design, you might have done it by yourself. Select col1, col2, (select Decode(sign(count(...

Another similar thought, if you read as single varchar string with delimeter in it, you can use the string functions to replace, such as convert(',,','',Input.field), if it is a comma delimited.

Not sure if rejects can capture the row that cause the abort.

Reset the job, from the log, you will find an entry as "From Previous log...". That will at times come up with most usfull information.