I have a situation where I am reading in a sequential file and for each record read I need to insert multiple rows in UDB database based on a match from the key in the sequential file.
i.e....
Read Seq file
Select from DB where DB.col1 = Seq File.col1
For each row returned insert new row in same table
What I am attempting to do is the COBOL equivalent of declaring a cursor and fetching the rows returned if that helps.
Thanks in advance.
Multiple Inserts on UDB For a Single Record
Moderators: chulett, rschirm, roy
Re: Multiple Inserts on UDB For a Single Record
Hey,
One simple way of achieving this is by using a lookup stage and putting the condition u have specified as the lookup condition and then dropping the lookup failures.
Sudarshan
One simple way of achieving this is by using a lookup stage and putting the condition u have specified as the lookup condition and then dropping the lookup failures.
Sudarshan