Getting -84 SQLCODE during pre-compilation of CICS DB2 pgm



Support for CICS/ESA, CICS/TS & Transaction Gateway, CICS Configuration Manager and CICS Performance Analyzer

Getting -84 SQLCODE during pre-compilation of CICS DB2 pgm

Postby chaitrasmurthy » Mon Feb 22, 2010 1:16 pm

Hi,

I am using 2 tables in my CICS DB2 program (2 DCLGENs) using INCLUDE statement. I got -84 SQLCODE during precompilation for the second INCLUDE statement. I had maintained same name for 2 columns in both tables. Made it unique thinking that would be the problem. This time, I dint get -84 error for INCLUDE statement, instead I could see that for the SELECT query of second table. Syntax for SQL statements are perfect. But not sure about this error. It would be of great help if anyone can help me out.
Here's -84 SQLCODE description:

UNACCEPTABLE SQL STATEMENT
Explanation: The referenced SQL statement is not allowed in this situation, but it will not cause an error.
Depending on the option specified at precompile time, one of the following occurred.
v The BEGIN DECLARE SECTION(*), END DECLARE SECTION(*), and UPDATE STATISTICS statements are flagged as not compatible.
* For C applications, BEGIN and END DECLARE SECTION are not flagged.
* For other languages, the statement is only allowed with precompiler option STDSQL(YES).
v Using the STDSQL(YES) precompiler option, the INCLUDE SQLCA statement is flagged as a warning.
Severity: 4 (warning)
System Action: The BEGIN DECLARE SECTION, END DECLARE SECTION, and INCLUDE SQLCA statements are ignored. The other statements are replaced by host language statements that will, if executed, set a warning code or SQLCODE -84 in the
SQLCA.
User Response: Unless this application program is used in a portable manner, remove the statement.
chaitrasmurthy
 
Posts: 4
Joined: Mon Feb 22, 2010 1:09 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Getting -84 SQLCODE during pre-compilation of CICS DB2 pgm

Postby dick scherrer » Mon Feb 22, 2010 1:38 pm

Hello and welcome to the forum,

For someone to be able to help, you need to post the expanded problem code.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Getting -84 SQLCODE during pre-compilation of CICS DB2 pgm

Postby chaitrasmurthy » Mon Feb 22, 2010 2:13 pm

Hi,

I can only see the following error in compilation listing after the SELECT statement.

MOVE -84 TO SQLCODE.
MOVE "42612" TO SQLSTATE.

However I see the return code of pre-compilation as '0' and bind for the program is also successful. But, when I actually check the flow of the program using CEMT, the SELECT statement doesnt get executed at all.
chaitrasmurthy
 
Posts: 4
Joined: Mon Feb 22, 2010 1:09 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Getting -84 SQLCODE during pre-compilation of CICS DB2 pgm

Postby chaitrasmurthy » Mon Feb 22, 2010 2:54 pm

Or as one solution to the above problem mentioned in the error description, I can set STDSQL pre-compiler option to 'YES'. Can anyone suggest me how do I set this precompiler option?
chaitrasmurthy
 
Posts: 4
Joined: Mon Feb 22, 2010 1:09 pm
Has thanked: 0 time
Been thanked: 0 time


Return to CICS

 


  • Related topics
    Replies
    Views
    Last post