|
View previous topic :: View next topic
|
| Author |
Message |
itdsen
New User
Joined: 20 Sep 2006
Posts: 23
Location: Chennai
|
|
|
|
Is it possible declare table in Procedure division?.
if its possible then Explain difference in it. |
|
| Back to top |
|
 |
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
| Whether, question is CREATE TABLE or DECLARE CURSOR, reformat the question. |
|
| Back to top |
|
|
itdsen
New User
Joined: 20 Sep 2006
Posts: 23
Location: Chennai
|
|
|
|
| About declare cursor |
|
| Back to top |
|
|
Manuneedhi K
Active User
Joined: 07 May 2008
Posts: 115
Location: Chennai
|
|
|
|
| There is no real difference between declaring a cursor in working storage or in procedure division. I remember reading somewhere that when a cursor is declared in procedure division programmers try to validate the sqlcode after that although the value in the sqlcode will the one of the last executed sql statement (prior to the cursor declaration), this may lead to unwanted confusion and hence it is recommended to code the cursor in the working storage. |
|
| Back to top |
|
|
|
|
