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:

  1. 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.

    ngaix.gif (1051 bytes)On AIX, the file is called db2cli.ini and is located in the sqllib/cfg directory.

  2. 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