DSXchange

What do you mean by better ?

Are you using any feature specific to Oracle 11g ?

DS 8.0 itself is a big jump which requires xmeta to be stored in a repository database. So better go with the one you have good expertise in.

Use DSJobName

Set APT_DISABLE_COMBINATION to true and re-run the job.

New installation ?

Were you able to compile with transformer before ?

Talk to your network admin.

Some default installation and configuration scripts are based on DB2 environment. You can modify them to suit other databases.

Apart from that, it must not matter which database you run.

Generally you receive the table information from SAP experts. You can give the prefix in search option to get list of similar names.

Some tables like MARA, T001 etc will be frequently used.

librfc32 is installed part of sap logon pad.

Try hash or modulus partition and check the result.

and I prefer the earlier.

Adding anything on Server job's job control hides it from the user with a blank canvas thus giving mis-leading picture unless well documented.

So better go for Batch jobs - that is what they are intended to do.

Batches are not job specific.

What do you intend to achieve ?

Can the datastage user run the batch file using the path specified from DataStage server machine ?

Is that a huge file? Maybe cache to memory is not able to load fully and hence not able to clear for new output.

Try copying the hash file and using the copied hashed file in the output.

You have options

Use 2 new parameters - say par3 and par4 and pass the corresponding values upfront from the calling sequencer depending on the case.

Use par3 and par4 in place of par1 and par2. So the new parameters will vary dynamically depending on your case.

In that case, change the execute command where you read as