SQLCA.SQLCODE = NOTFOUND, STATUS = 0 ?
Posted in 1995
Topics: Error Codes & Troubleshooting
One of our programs is doing a fetch (the select below),
sqlca.sqlcode = NOTFOUND but STATUS = 0, so rather
than checking on STATUS we have to check on sqlca.sqlcode.
This is very strange? Anybody ever seen this before?
It seems that this problem(?) applies to a few more selects in
our product, looks like its safer to use sqlca.sqlcode?
SELECT cl_new_value, cl_est_value, cl_max_percent, cl_subscription
FROM cl_credit_limit
WHERE cl_score_start <= 250
AND cl_score_end >= 250
AND cl_account_type = "C"
AND ( (cl_network IS NULL AND cl_technology IS NULL
AND cl_subscription IS NULL)
OR (cl_network = "C" AND cl_technology = "A"
AND cl_subscription = "C" ))
ORDER BY cl_subscription DESC
Informix say this is a known bug on early versions, how early
is 4.12 on an IBM in the UK?