Problem
When running DB2 programs in Enterprise Server, how can an SQL -818 error be resolved ?
Resolution
When compiling the program, make sure the DB2 compiler directives BINDDIR and BIND are defined.
BINDDIR must be set to the full path of the <pgmname.BND> file that will be generated.
BIND will generate a file <pgmname.BND> in directory pointed to by BINDDIR.
After the compilation is completed and the <pgmname.BND> file has been generated, a manual BIND against DB2
must be done before the program can be used, and the SQL -808 or -818 avoided.
Please see IBM documentation on how to use BIND from DB2 command prompt.
Incident#3112993
#DB2
#EnterpriseServer
#Server
#SQL-818
#Enterprise
