Multiple Inserts on UDB For a Single Record
Posted: Thu Nov 03, 2005 1:17 pm
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.
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.