How to solve the Sqlcode -443

Arunkumar R S R · New User Joined: 06 Aug 2008 Posts: 14 Location: US

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

guptae · Posted: Mon Sep 08, 2008 7:27 pm

Hello Arun,

could you please provide sqlstate for that?

Arunkumar R S R · New User Joined: 06 Aug 2008 Posts: 14 Location: US

SQL State is

38X13 SQLSTATE RETURN COD

Thanks,
Arun.

ashimer · Posted: Mon Sep 08, 2008 8:15 pm

What was the Msg-Text ? Please test your routine extractVarchar properly ...

Arunkumar R S R · New User Joined: 06 Aug 2008 Posts: 14 Location: US

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;

ashimer · Posted: Mon Sep 08, 2008 8:35 pm

can you post the content from of path "message:Message/key/keyNumber " from your XML ?

Arunkumar R S R · New User Joined: 06 Aug 2008 Posts: 14 Location: US

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.