Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to solve the Sqlcode -443

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Arunkumar R S R

New User


Joined: 06 Aug 2008
Posts: 14
Location: US

PostPosted: Mon Sep 08, 2008 7:26 pm    Post subject: How to solve the Sqlcode -443
Reply with quote

Hi,

Can u please let me know how to solve the SQLCode -443.

It looks like the problem with the routine ExtractVarchar.

I am using the "extractVarchar" routione in declare cursor.

Thanks in Advance,
Arunkumar
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Sep 08, 2008 7:27 pm    Post subject:
Reply with quote

Hello Arun,

could you please provide sqlstate for that?
Back to top
View user's profile Send private message
Arunkumar R S R

New User


Joined: 06 Aug 2008
Posts: 14
Location: US

PostPosted: Mon Sep 08, 2008 7:40 pm    Post subject: Reply to: How to solve the Sqlcode -443
Reply with quote

SQL State is

38X13 SQLSTATE RETURN COD

Thanks,
Arun.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Mon Sep 08, 2008 8:15 pm    Post subject:
Reply with quote

What was the Msg-Text ? Please test your routine extractVarchar properly ...
Back to top
View user's profile Send private message
Arunkumar R S R

New User


Joined: 06 Aug 2008
Posts: 14
Location: US

PostPosted: Mon Sep 08, 2008 8:22 pm    Post subject: Reply to: How to solve the Sqlcode -443
Reply with quote

This is the qurey i am using for cursor declaration.

DECLARE CURNAME CURSOR FOR SELECT
DB2XML.extractVarchar(CAST(CAST(load_data AS CLOB)
AS DB2XML.XMLCLOB),
'/message:Message/key/keyNumber') AS KEY_NO;
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Mon Sep 08, 2008 8:35 pm    Post subject:
Reply with quote

can you post the content from of path "message:Message/key/keyNumber " from your XML ?
Back to top
View user's profile Send private message
Arunkumar R S R

New User


Joined: 06 Aug 2008
Posts: 14
Location: US

PostPosted: Mon Sep 08, 2008 8:42 pm    Post subject: Reply to: How to solve the Sqlcode -443
Reply with quote

I didn't get your question. what you mean by "the content from of path "message:Message/key/keyNumber " from your XML ". I didn't know about the extractvarchar functionallity and this is the existing code and it is working for other programs also.

Thanks,
Arun.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us