Helpful Information
 
 
Category: DB2 Development
SQL0902C Resolution Assistance

A client of ours is attempting to compile an IO module SQL in it and is receiving the following error message (see below). He is compiling on an NT system using IBM DB2v7 and a Microfocus COBOL compiler. I am able to compile the same module on our local systems and have not been able to find any resolution. Any help would be greatly appreciated!!


* Micro Focus Net Express V4.0 revision 255 07-Jun-04 01:09 Page 1
* ANAPIOR.CBL
* Options: NOLIST NOASMLIST OMF(OBJ) GNT(.\) OBJ(.\)
* DIRECTIVES"c:\DPRDEV\RDB\COBOL.DIR"
2014 END-EXEC.
* 801-S**************
** External Compiler Module
* DB0100 SQL0902C A system error (reason code = "1") occurred.
** Subsequent SQL statements cannot be processed. SQLSTATE=58005

2037 END-EXEC.
* 801-S************** ( 1)**
** External Compiler Module message
** DB0100 SQL4901N Precompiler Services requires reinitialization
** because of a previous error.

2246 END-EXEC.
* 801-S************** ( 1)**

It would appear that the precompiler is not able to connect to the database in order to validate the sql statements.

Make sure that your client can connect to the database on that machine using the dns that the precompiler uses using the same username and password.

Onslaught, Thanks for the info. A question for you. I was under the assumption that the precompiler failed due to some prior error:

** External Compiler Module
* DB0100 SQL0902C A system error (reason code = "1") occurred.
** Subsequent SQL statements cannot be processed. SQLSTATE=58005

However, since I do not have experience with this, am I incorrect? I am currently taking your advice and am looking into the compile job...

The problem is that the documentation doesn't list what these reason codes are for this particular sql code. https://aurora.vcu.edu/db2help/db2m0/frame3.htm#sql0900
The only reference to reason code 1 stated connection problems and I have run into similar things in the past but I can't recal the exact error that was return.
You might also want to make sure that you and your client are running on the same fixpak and on the same compiler. I would go as far as to bring up a blank nt machine put thier compiler on it and go through the compilation on it and work through any bugs you might encounter there. Once you can get it to compile in that environment, then you should be able to talk them through compiling thier copy.
You may also want to make sure that they have service pack 6 on thier nt machine just to be safe.










privacy (GDPR)