View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
In spufi, i have executed the following query and got the corresponding output along with the SQLCODE saying 100. And for commit SQLCODE is 0. What am i missing here ?
Iam using DB2 V8.1.
Code: |
SELECT * FROM SHANDB.EMPLOYEE WHERE EMPNO LIKE '%60';
---------+---------+---------+---------+---------+---------+---------+---------+
EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE J
---------+---------+---------+---------+---------+---------+---------+---------+
000060 IRVING F STERN D11 6423 1973-09-14 M
000160 ELIZABETH R PIANKA D11 3782 1977-10-11 D
000260 SYBIL V JOHNSON D21 8953 1975-09-11 C
DSNE610I NUMBER OF ROWS DISPLAYED IS 3
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+---------+
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE617I COMMIT PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+ |
What did DB2 search & what it didn't find ?
I hope SQLCODE=100 for no data found. Still ?
Thank You,
Sushanth |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
When a SELECT statement is executed using SPUFI, this SQLCODE indicates normal completion.
Get first row, 000060, rc=0,
get next row, 000120, rc=0,
get next row, 000360, rc=0,
get next row, none found, rc=100. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Thank You, CICS guy. |
|
Back to top |
|
|
|