Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: ASP and DB2" Calling IBM DB2 dxxGenXML stored procedure


Message #1 by "S. Sridhar" <oesridhar@e...> on Thu, 20 Dec 2001 12:44:22 -0500
This is a multi-part message in MIME format.



------=_NextPart_000_02AB_01C18954.0C641BB0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hullo:



I've been trying to work thru the sample on page 912-912 from Chapter 27 

of the Professional ASP Data Access book.



There is a stored procedure DB2ADMIN.uspXML which calls 

db2xml.dxxGenXML. I am not able to call the dxxGenXML sp from the uspXML 

stored procedure. I've tried this a million ways. Each time when I try 

to run the stored procedure I get:



[IBM][CLI Driver][DB2/NT] SQL0804N  The application program input 

parameters for the current request are not valid.  Reason code "".  If a 

host variable or SQLVAR in the SQLDA is invalid then:  host 

variable/SQLVAR number =3D "", SQLTYPE =3D "", SQLLEN =3D "", host 

variable/SQLVAR type =3D "".  SQLSTATE=3D07002







DB2ADMIN.uspXML- Changes rolled back.



DB2ADMIN.uspXML- Done calling stored procedure.





What I am doing wrong.



Also, when I downloaded the code for this book and unzipped, Chapter 27 

code has no resemblance to this chapter in the book at all?



--sridhar







  Return to Index