A fix is available
APAR status
Closed as program error.
Error description
Message IGYPS0212-S, indicating an SQL host variable reference had invalid syntax or the referenced host variable was an invalid SQL variable type, is issued when using DB2 coprocessor. The message is not issued when using preprocessor.
Local fix
Use preprocessor
Problem summary
**************************************************************** * USERS AFFECTED: Users of Enterprise COBOL V5.2 compiling * * with the SQL compiler option programs that * * contain a DB2 SQL VARCHAR host variable * * where the VARCHAR structure has data items * * defined with level number 88 * * (condition-names) and the VARCHAR host * * variable is used in an EXEC SQL statement. * * The structure is accepted by the separate * * DB2 precompiler. * **************************************************************** * PROBLEM DESCRIPTION: The compiler does not accept * * condition-names in VARCHAR host * * variables and issues message * * IGYPS0212-S. * * If a VARCHAR host variable has in its * * structure level 88 condition names, * * then the structure is not recognized * * as a VARCHAR host variable. For * * example: * * 01 CHRVAR. * * 49 CHRVAR-LENGTH PIC S9(4). * * 88 CN1 VALUE 5. * * 88 CN2 VALUE 10. * * 49 CHRVAR-STRING PIC X(10). * * 88 CN3 VALUE SPACE. * * * * In this example, if CHRVAR is * * referenced as a host variable in an * * EXEC SQL statement then it will not be * * recognized as a VARCHAR SQL data type. * * * * Example: If the following SQL * * statement was used with the above * * data * * EXEC SQL * * INSERT INTO SAMP.TABLE * * (CHARDATA) * * VALUES( :CHRVAR) * * END-EXEC * * * * then the compiler would issue the * * following diagnostic message from DB2: * * * * IGYPS0212-S SQL host variable * * reference "CHRVAR-LENGTH" had * * invalid syntax or the referenced * * host variable was an invalid SQL * * variable type. The statement was * * discarded. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** If a VARCHAR host variable has in its structure level number 88 condition names, the compiler does not recognize the structure as a VARCHAR host variable.
Problem conclusion
The compiler is modified to recognize the VARCHAR host variable even if it has in its structure level number 88 condition names. This makes it compatible with this undocumented extension to the separate DB2precompiler.
Temporary fix
Comments
APAR Information
APAR number
PI99035
Reported component name
ENT COBOL FOR Z
Reported component ID
5655W3200
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-06-11
Closed date
2018-06-13
Last modified date
2018-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
IGY8RWTU IGYCBE IGYCCBE IGYCCICS IGYCCSRV IGYCDGEN IGYCDIAG IGYCDMAP IGYCEN$0 IGYCEN$1 IGYCEN$2 IGYCEN$3 IGYCEN$4 IGYCEN$5 IGYCEN$8 IGYCEN$D IGYCEN$R IGYCFGEN IGYCFREE IGYCINIT IGYCJA$0 IGYCJA$1 IGYCJA$2 IGYCJA$3 IGYCJA$4 IGYCJA$5 IGYCJA$8 IGYCJA$D IGYCJA$R IGYCLIBH IGYCLIBO IGYCLIBR IGYCLSTR IGYCLVL0 IGYCLVL1 IGYCLVL2 IGYCLVL3 IGYCLVL8 IGYCMALL IGYCOSCN IGYCPGEN IGYCRCTL IGYCRDPR IGYCRDSC IGYCREAL IGYCRWT IGYCSCAN IGYCSIMD IGYCUE$0 IGYCUE$1 IGYCUE$2 IGYCUE$3 IGYCUE$4 IGYCUE$5 IGYCUE$8 IGYCUE$D IGYCUE$R IGYCXREF IGYECWI IGYMSGE IGYMSGK IGYMSGT
Fix information
Fixed component name
ENT COBOL FOR Z
Fixed component ID
5655W3200
Applicable component levels
R520 PSY UI56404
UP18/06/21 P F806
R521 PSY UI56405
UP18/06/22 P F806
R522 PSY UI56406
UP18/06/22 P F806
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS6SG3","label":"Enterprise COBOL for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"520","Edition":"","Line of Business":{"code":"LOB17","label":"Mainframe TPS"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"520","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 July 2018