IBM MAINFRAME HELP & SUPPORT FORUMS

rohin · Joined: 29 Apr 2005 Posts: 16 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

ashimer · Joined: 13 Feb 2004 Posts: 354 Location: Bangalore

Why dont you join TABLE-B with the first cursor and do the multiplication in the cursor itself .... Multiplication in DB2 query is not going to eat up CPU time ...