Hi,

I am quiet new to COBOL DB2 stored procedures and had a couple of questions on how it works...

1. In a COBOL DB2 stored proc do we have to minimize the number of sql's within the program ? I'm asking this 'coz i've seen a couple of stored procs with huge sql's ( with more than 700 lines etc..).. will it affect the performance if we have a number of sql queries like in any other DB2 cobol pgm...

2. When we compile the cobol db2 sp.. where does the load module reside ?

3. what is the purpose of a global temp table ?? is this advisable ? what are the other methods of returning the result set.

Would be great if anyone could answer these queries...

Thanks & Have a Nice day,
Sameer