DSXchange

The solution will depend upon the level of change you are preared to do and the authorisation level you are granted. If it is a full table reload, you can download the full table and repopulate it later. You can partition using something like batch id or load id You can load into a temp table an the...

Deadlock requires stremlining your data access. You can control your job but cannot control other areas in the Org that will lock the db.

Isolation levels are ansi standard mechanism to handle data access.

Did you try running job2 and then job1?

Perform an ftp.

It will work with XP SP2. That is the main reason of lots of patches discussed in this forum.

Did you regenerate DS?

Does the dstage group has privilege to the new UVTEMP area?

In either of the job, do you insert/update null for other job's column(s)?

There are different types of hash files. Search the forum.

Search for Hash file calculator or look into options of hash file stage.

You can use the date as part of your parameter for file name.

Try to log into Unix via telnet and see what happens.

Did you bounce DS recently?

What does it mean by saying "field3, field3 (null)"?

Do you have any errors from job2? Do they run in parallel?

Did you try writing the cat in a shell script and calling the script from your job?

The Fmt has the required capability.

You can do a full project compile followed by 'reset before run' option in sequencer.

You can include external tools such as compile All. But compiling before executing in a sequencer is not the best way forward.