The World of DB2
IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE
Hi there,
I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.
Informational tokens are "DB2 v11.1.4050.859", "s1911120100",
"DYN1911120100WIN64", and Fix Pack "5".
For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in the example below its checking for '02000'.
Is this correct or am I missing something ?
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sqlpl.doc/doc/r0053697.html
Thanks.
Regards,
Gagan
Replies to This Discussion
-
Permalink Reply by Douglas J. Partch, Jr. on -
Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
Forum
z/OS DB2 V11 to V12 and CICS?
Started by Tom Burkholder in What's hot ? yesterday. 0 Replies 0 Likes
Hello DB2 users...I apologize in advance if this is not the place to post this question; however, I thought I would sign up and give it a try. My background is with systems support and middleware (z/OS, MQ, WebSphere, distributed DB2 jdbc configs)…Continue
Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE
Started by Gagan Kakkar in Application Development and DB2. Last reply by Douglas J. Partch, Jr. Jan 6. 1 Reply 1 Like
Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue
Groups
Db2 NIghtShow
IBM Big Data & Analytics Hub
PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]
© 2020 Created by Surekha Parekh.
Powered by
