rohin
New User
Joined: 29 Apr 2005 Posts: 21 Location: Gurgaon, India
|
|
|
|
Hi,
Please suggest which of the following is a better option for Cobol DB2 batch program.
1. Open cursor-A, fetch data from cursor-A. Now, use data from cursor-A to execute another SQL like:
EXEC SQL
SELECT SUM(COL_A * COL_B)
FROM TABLE-B
WHERE COL_C = ....
END-EXEC
2. Open cursor-A, fetch data from cursor-A. Now, use data from cursor-A to open another cursor-B like:
EXEC SQL
DECLARE CURSOR_B AS
SELECT COL_A, COL_B
FROM TABLE-B
WHERE COL_C = ....
END-EXEC
and then do sum of multiplication in Cobol.
Data volume could be around 50,000 to 80,000
Please suggest.
Thanks,
Rohin |
|