Trouble-Shooting Tips
If you have successfully generated classes for a Data Access part, but are experiencing
run-time errors with the part, one or more of the following situations may apply to your
code:
- If you are using DB2 Universal Database version 5, an SQL statement or query used in the
mapping (for example, a user-defined method) may have been validated even though the SQL
was not valid. To prevent this incorrect validation from occurring, add the following
lines to the DB2CLI.INI file in the SQLLIB directory:
[common]
DEFERREDPREPARE=0
Then you must correct the SQL statement or query, re-generate the code, and rebuild the
part.
On AIX, the file is called
db2cli.ini and is located in the sqllib/cfg directory.
- The user running the Data Access application may not have the database authority to run
some of the methods that the application calls. Ensure that the application is run by a
user with proper authority.

Data Access Builder Workflow

Add User-Defined Methods

Data Access Class Library and Generated Code