DSXchange

Hi all, i need to store the the last run date/timesatmp of the DS job (default has to be sysdate) . what best ways can i do it? Can i set a date parameter in the job defaulted to sysdate? i checked if i could set a job parameter to any of the system variables but i don see any system variable for da...

Hi all, i need to store the the last run date/timesatmp of the DS job (default has to be sysdate) . what best ways can i do it? Can i set a date parameter in the job defaulted to sysdate? i checked if i could set a job parameter to any of the system variables but i don see any system variable for da...

Hi all, i need to store the the last run date/timesatmp of the DS job (default has to be sysdate) . what best ways can i do it? Can i set a date parameter in the job defaulted to sysdate? i checked if i could set a job parameter to any of the system variables but i don see any system variable for da...

Hi all,

Can anyone please tell me how can i restart my job in case of failure/abend and rollback any changes it has made to the target database ??

i need to do the failure handling for the job and i cant figure out where to start...

Thanks!

Thanks Guys....

Will try out both

Hi all,

is there any way to import a DB 2 table definition? i checked all options but none specify about importint DB2 table defnitions.

Thanks in advance!

ok.. that sounds good..

will do it in a single job then :D

thanks for all ur inputs guys....

There are no issues with the availablity of the database. What i am wondering is - selecting max from the same table and inserting into the same table, would it create a dead lock due to locking issues on the table? i am not sure if SELECT MAX is going to have a EXCLUSIVE lock on the table. in that ...

Thanks a lot guys... :) finally i am able to generate the key values. just one more question... i have used the stages as suggested lookuo--> column generator --> transformer can i directly write the output of the transformer to the database or should i first have it in a file and write another job ...

my column generator is genating just 2 same values...
m i missing something...

Thanks all, i jus saw the " Surrogate Key Generator" in parallel job designer guide... :) can i somehow make use of this.... when i read thru it quite looked like i can if i have no partitions... only thing i cant figure out is: the start value of the key has to be supplied and in my case ...

ok... i am a lilttle confused here..i think i dint quite get the picture... :( if i cannot have it to the transformer then how can i insert into the destination... all my columns except the primary key are mapped in the transformer. i need to insert all the rows from transformer + primary key into t...

Thanks ray!

So is this going to look like

Look up----> Column generator----> transformer

source ----> transformer...

can i have 2 inputs to the transformer... if not how else do i map the column??

Hello all, please help me this problem.... i have a source table with 17 fileds anda destination table with 18 fields. i have to insert all the rows into the destination reading from the source. i am using a transformaer to map all the fields between the source and destination. my problem is, the 18...

no... nothing of that sort.. and no partitioning... can the following declaration be causing the prob?? in my source i have declared t_proj_am decimal 19 scale 4 mapped using tranaformer to AMT decimal 11 t_po_am decimal 19 scale 4 mapped using tranaformer to A_AMT decimal 13 scale 2 t_cmt_ytd decim...