My SQL query returned no rows, but SELCOPY gave a return code of 0. I was expecting a return code of 100 in the SQLCA, but that's also 0. What happened?

---

If you do not have an explicit OPEN and CLOSE for the query, SELCOPY's READ command performs an OPEN (and a CLOSE if no selections).

The SQL return code (SQLCA+12) indicates the return code from the most recent command (the CLOSE) and that is zero.