[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

ISAM error message



Does anybody know where I can get a list of Informix &/or ISAM
error messages?

I keep getting this:

(SQR 5528) INFORMIX SQL FETCH error -243 (ISAM: -107)

after executing an sqr for a while.  I know this happens after
the query has been executed more than once. With the -s
flag on, I get the following about the query.



 Cursor #10:
   SQL = select sum(s.dc_inv_qty), sum(s.dc_inv_cst_amt), b.pgm_desc  from
         tsiw_stycl_inv_sec s, tprd_dim b where s.tm_key=? and s.prd_key =
         b.prd_key and b.pgm_desc in [$selstring] group  by b.pgm_desc order
         by b.pgm_desc desc
 Compiles = 35
 Executes = 34
 Rows     = 772