Embedded SQL Programming Guide

Accessing DRDA Servers

If you want to develop applications that can access (or update) different database systems, you should:

1. Use SQL statements and precompile/bind options that are supported on all of the database systems that your applications will access. For example, stored procedures are not supported on all platforms.

   For IBM products, consult Volume 2 of the IBM SQL Reference, Version 2 (SC26-8416), before you start coding.

2. Where possible, have your applications check the SQLSTATE rather than the SQLCODE.

   If your applications will use DDCS and you want to use SQLCODEs, consider using the mapping facility provided by DDCS to map SQLCODE conversions between unlike databases.

3. Test your application with the DRDA databases (such as DB2 for MVS, OS/400, or SQL/DS) that you intend to support. See the DB2 Connect User's Guide.

For more information accessing DRDA database systems, see Appendix C. "Programming in a DRDA Environment".

[ DB2 List of Books | Search the DB2 Books ]