| View previous topic :: View next topic |
| Author |
Message |
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
 Posted: Tue Feb 22, 2005 12:41 pm Post subject: sqlcode 100 |
 |
|
Hi all,
we are executing a query through SPUFI and it returns a sqlcode=100 even if there are records returning.
I always thought that a sqlcode=100 was only for 'records not found'.
Why do i get this sqlcode? What does sqlcode=100 mean in this case?
Thanks. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Feb 22, 2005 1:21 pm Post subject: |
|
|
Monaco,
Spufi returns this statement after a succesful execuetion of the query. In spufi the DSNE610I denotes the rows retrieved.
for ex:
| Code: |
DSNE610I NUMBER OF ROWS DISPLAYED IS 5
|
This will be followed by DSNE616I
| Code: |
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS number
Explanation: This message is written to the output data set following the successful execution of an SQL statement from the input data set. 'number' specifies the SQL return code for the statement.
System Action: Input data set processing is completed, and this message is included in the SPUFI output.
|
In this SQLCODE = 100, "no data" was found, as the FETCH(spufi select) statement returned no data because the cursor was positioned after the last row of the result table
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
| Posted: Wed Feb 23, 2005 11:21 am Post subject: |
|
|
Thanks a lot.
It was very useful.
Thanks Kolusu. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
