|
|
| Author |
Message |
itdsen
New User
Joined: 20 Sep 2006
Posts: 17
Location: Chennai
|
|
|
|
Is it possible declare table in Procedure division?.
if its possible then Explain difference in it. |
|
| Back to top |
|
 |
References
|
 Posted: Thu Jun 12, 2008 5:26 pm Post subject: Re: Is it possible declare table in Procedure division?. |
|
|
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 298
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: 17
Location: Chennai
|
|
|
|
| About declare cursor |
|
| Back to top |
|
|
Manuneedhi K
Active User
Joined: 07 May 2008
Posts: 121
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 |
|
|
|
|
