Anyone know what would cause this error? Been reading the boards searching for it, but haven't found anything that really explained it yet.

(FOC1400) SQLCODE IS -901 (HEX: FFFFFC7B)
: [58004] [IBM][CLI Driver][DB2/AIX64] SQL0901N The SQL statement failed
: because of a non-severe system error. Subsequent SQL statements can be p
: rocessed. (Reason "Too many columns or record length exceeded.".) SQLS
: TATE=58004
L (FOC1405) SQL PREPARE ERROR.
(FOC1400) SQLCODE IS 1400 (HEX: 00000578)
: SQLCODE IS -901 (HEX: FFFFFC7B)
L (FOC1406) SQL OPEN CURSOR ERROR. : WCCLM

This message has been edited. Last edited by: Corky,

quote:

Too many columns or record length exceeded

Doesn't this comment make sense?

FOC1400 errors are errors that WebFOCUS gets back from the SQL data adapter - in this case DB2.

To find the root of the issue you need to read the next few lines and search on the SQL error codes returned from the database.

A quick google on the SQLSTATE=58004 and "Too many columns or record length exceeded" returned this from IBM

http://www-01.ibm.com/support/....wss?uid=swg1IC98761

Are you using DB2 10.1 by any chance? You might need to apply a fix.

Otherwise your record set being returned is too big for DB2 to process.

Cheers

Stu

quote:

Originally posted by Francis Mariani:

quote:

Too many columns or record length exceeded

Doesn't this comment make sense?

Not really, because it wasn't very much data.

What I ended up doing was moving one of my WHERE statements in the first hold to another part of the program.

So essentially when I tried pulling even more data in the first hold (by eliminating one of the WHERE statements) the program worked.

It wasn't much different from any other programs I've written, so I have no idea.