DSXchange

Simply use update action -- update existing records and insert new records option i.e upsert load mode in target table.
Specify what stage you are using to load target table?

it should generate the drop statement itself for all the tables your specifying for Mload........ for the before command we usually check the two options specified in datastage in the before tab. Apart from checking two options ( one to Drop error tables and second to treat SQL errors as non fatals...

Many Thanks Ray ,
we will forward this to support provider as a bug ,

And our source fields having all fields as keys in Chars , but the negative link count on out put of Tfm link looks a starnge .

Row count for input to tfm is 2368 and out from tfm into link partn is -12676 and job finishes with duplicates, only 1328 records are loaded to target db2 tables. Again if I remove the Link Partioner and directly load then it loads all 2368 records .. that is no issue with the source data.. using Ln...

From a input fixed width Sequential file we are loading to DB2 table where all mapping columns to DB2 table are Key columns with Char format. Job designed as Seqfile → Tfm→ Link Partioner(3 links)→Tfm→ Db2 table and in Tfm it is direct mapping no transformation. Round robin algorithm in Link partion...

Apart from HFC is there any other alternateway to calculate the Hash file Properties for Type(30)Dynamic in create file options i.e Minimum modulus, selecting Hash algorithm using column length and display length