Search code examples
db2peoplesoft

SQL0100W Error on DB2

I get the following error when running an sqr report on DB2:

SQL0100W - No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.  SQLSTATE=02000

The sql in question runs correctly when I paste it into RapidSQL, replacing the parameters. The sql in question is an insert-select. No rows are returned by the select, and this is fine... I expect the report to be blank for my parameters.

Any idea how I can get around this?

Solution

  • Turns out to be an environment setup issue. Got resolved with no change from me after a couple of builds....

    Strange :-/