DSXchange

DataStage puts in a Sort stage before the join. And probably the DataSet and Sort are combined onto one operator. Look at the score of the job to determine if this is the case. I suggest you put in a sort stage and add the property Sort Key Mode to "Don't sort Previously Sorted". This migh...

Problem with you job "P_S07_MA_SL_HG_DATA". Don't know what code = -2 represents. Start with checking the job log.

See if this post helps. viewtopic.php?t=113640

Writing the last generated number into a sequential file and passing this a job parameter in the next run could help. Or a Surrogate key generate stage might be useful.

Do an exact search on "liborchoraclent". See if one of the posts help. And i dont know if "toracle" is a supported by DataStage

I have a limited experience in ABAP stages. I assume you are using ABAP extract stage. As per my understanding, an ABAP code can be written in SAP R3 and copy paste in the ABAP stage using the option "Generation Method" set to "Enter program as text". Did you try this option?

A sequence in infinite loop. Check if file exists, then trigger the job. Else Check again. You would also need to handle the abort condition for the job.

Does the meta data for the key column match on both links to the join stage?
Note:- AFAIK there is nothing like a "joiner" in DataStage.

You can use a field function. Field(InputCol,"_",1).

The record delimiter for the last record is missing. I don't think there is any way you can handle this in the code. You can demote the warning to informational from the director log. Just curious. Why are you using a Sequential file/External source stage to read XML file instead of XML input stage?

Using sequential file stage alone, its not possible. You can, at the most reject all the records with extra delimiter from the Sequential file stage and continue processing the other records.

Might work. Data would get repartitioned but the sort order in each partition should remain.

Sorting and partition of the data can be maintained in a DataSet. Use Same partition on the DataSet input link. As long as you are not repartitioning the sorted data this would work.

Environment variable are not stored in .profile of the user. You can change the environment variable values from the administrator.