DB2 Cursor, Reading two tables record by record

vijendra.23 · New User Joined: 06 Apr 2007 Posts: 3 Location: bangalore

Hi all ,
can anyone suggest me regarding below condition:

There are two Table - A and Table -B. Now i want to take first row of table A and comes to table B ,Read all records from Table B then at the end of B, i want to go back to table A and read second record of Table A then all record of B like wise till end of table A.

dick scherrer · Posted: Sat Aug 25, 2007 1:31 pm Post subject:

Hello,

Why would you want to generate a cartesian product?

What you want to do is prevented whenever possible.

Why do you need to read table 2 over and over?

stodolas · Posted: Sat Aug 25, 2007 8:24 pm Post subject:

A proper join statement is probably more correct. Don't treat the database tables like files.