Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with GET DIAGNOSTICS statement in DB2 Stored procedure

Status
Not open for further replies.
a2210

a2210

Technical User
Mar 14, 2007
1
US

Hi
I am handling EXCEPTION n DB2 for getting SQLSTATE i am using
GET DIAGNOSTICS CONDITION 1 v_state = RETURNED_SQLSTATE;

But when running this statement i m getting error message that RETURNED_SQLSTATE unexpected token.
So tell me how it can be used .
Please help me

Regards

Amit
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
399
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
307
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
254
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
310
walter.weinmann
walter.weinmann
gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
357
gdg1976
gdg1976

Part and Inventory Search

Sponsor

Back
Top