Joined: 01 Mar 2006 Posts: 287 Location: Basel, Switzerland
you can make a db2 query in batch thru DSNTIAUL, for example.
make a query which inserts tableB upon specific data from tableA,
you will need a proper where clause on tableA.
now you can do the same with tableC.
i think this is easier than making this dependable on any
condition code given thru jcl, because in the query
you define the needed conditions already (where clause).