just a random pick

SQL Code : +218

THE SQL STATEMENT REFERENCING A REMOTE OBJECT CANNOT BE EXPLAINED

Explanation :

The user has used EXPLAIN(YES) on thebind subcommand to bind an application which hasSQL statement referencing a remote object or the userhas a static EXPLAIN SQL statement which references aremote object in the application program. EXPLAIN ona remote object is not supported by DB2.

It is issued at BIND time, and only withVALIDATE(RUN).

SQL STATE : 01537

When DB2 executes an SQL statement, it returns information about the statement execution which includes the SQL return code (SQLCODE) and the SQLSTATE, which indicate whether statement execution was successful.

Regardless of whether the application program provides an SQLCA or a stand-alone variable, SQLCODE is set by DB2 after each SQL statement is executed. DB2 conforms to the ISO/ANSI SQL standard as follows:

  • If SQLCODE = 0, execution was successful.
  • If SQLCODE > 0, execution was successful with a warning.
  • If SQLCODE < execution was not successful.

Suggestion / Complaint / Feedback