DSXchange

Or use dsjob to get list of parameters and fetch their values from db table (holding the values). The job run string call be prepared in shell and initiated.

All outside DS Basic.

Or use dsjob to get list of parameters and fetch their values from db table (holding the values). The job run string call be prepared in shell and initiated.

All outside DS Basic.

Options 1.) You can use CFF stage 2.) job1: Write output in a file with one extra field - the output tablename job2: Use another job to 'grep' records of specific table and load job3: Create sequencer to run job2 48 times - once for each table 3.) job1: Flatten the structure to an ALL column format ...

You can sort the data in reverse order and use stage variables to get previous rows value.

You can do that in a exec cmd stage of seqencer

You can work with it as a string input. What have you attempted so far?

Why not? Just add a dummy null column to the first query.

That appears to be a UNION.

Why do you want to do in DataStage?

Are you using Stored Procedure to load the target? 3 things you can do.... 1.) Create a constraint just before the target (Oracle) stage so that no rows are written into it. Try running the job. 2.) Check the table(s) dependant on the target table. If you do not have the permission, your DBA must be...

1403 (No Data Found) is from some select. So it has nothing to do with Insert/Update - unless it impacts by triggering a select.

Try logging messages to see where it goes into abyss

Tools -> Options

Set higher value for refresh interval.

PS : Post in appropriate section

Pass the duplicate row through a dummy link and set it to fail on 1 row.

Run os dsjob with nowait option

Or use stage var if no new info from db is required