Is this something DAW has added to the ODBC driver to for some a test or something ?
This causes an error in my DB2 Connect ODBC driver when connecting to our mainframe.
Code:
An unexpected token "WHERE" was found following "1". Expected tokens may include: "".
And this pretty much describes the error
HTML Code:
The object identified by name is not defined in the DB2 subsystem. This
SQLCODE can be generated for any type of DB2 object. You might have issued
COMMENT ON PACKAGE without specifying a version. This caused DB2 to implicitly
resolve to the NULL version, but the NULL version was not found. System action:
The statement cannot be executed. Programmer response: Verify that the object
name was correctly specified in the SQL statement, including any required
qualifiers. If it is correct, ensure that the object exists in the system before
resubmitting the statement. If the null version does not exist, drop the
specific version by using the VERSION clause in the statement.
I'm asking because I can use other packages to access the DB2 server on our mainframe and I don't get this statement. I only getting it when using the DAW CK driver in a VDF Studio workspace with my DB2 table.
VDF 17.0
CK 5.1.96
BTW, DB2Connect is a ODBC/CLI driver. I cannot use the DAW DB2 driver to connect to our mainframe DB2.