View previous topic :: View next topic
|
Author |
Message |
JC Coyne
New User
Joined: 25 Jan 2011 Posts: 3 Location: St. Louis MO USA
|
|
|
|
I received a report from a user that he could not see data in a table that contains an XML column. When attempting a select * on the table in DB2 Data Studio, the following error is returned:
An error occurred while processing the results. - AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON 16. SQLCODE=-804, SQLSTATE=07002, DRIVER=3.61.65
I received a similar error using WinSQL. I'm able to select individual non-XML columns, but the SQL fails when the XML column is included in the select.
Has anyone else seen a similar error, or know what input parameters to which the error is referring?
Thanks for any help you can provide.
JC |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
how big are the xml columns/how are they defined? |
|
Back to top |
|
|
JC Coyne
New User
Joined: 25 Jan 2011 Posts: 3 Location: St. Louis MO USA
|
|
|
|
Checking the create table DDL, I see:
"PO_FORM_FIELDS" XML NOT NULL,
No column size was specified when the table was created. When I checked the field defs in WinSQL, I found PO_FORM_FIELDS has a size = 0. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Are we talking mainframe or PC here? |
|
Back to top |
|
|
JC Coyne
New User
Joined: 25 Jan 2011 Posts: 3 Location: St. Louis MO USA
|
|
|
|
DB2 for z/OS 9.1. |
|
Back to top |
|
|
|