APAR status
Closed as program error.
Error description
An EGL program migrated from VisualAge Generator may experience a -305 SQL return code when an SQL clause references a host vari able that is contained in an EGL basicRecord structured record. Since there is no way to set a variable as nullable in an EGL st ructured basicRecord, the -305 will occur if the SQL statement r eturns a null value to the host variable.
Local fix
Problem summary
This fix takes care of the problem where nullable items could be used in a where clause. This fix also allows the user to specify a symbolic parameter VAGSQLNULLABLES with a value of YES to inform the cobol generator that all sql host variables are to be treated as nullable, even though the EGL variable does not have the nullable flag set. This is to make it compatible with VAG. Fixtest EGLFixtest200812090853 will contain the fix and can only be placed on top of a 7102 or 7101 (with fixtest EGLFixtest200811141515) system. This fixtest cannot be used with 751.
Problem conclusion
Software fixed
Temporary fix
Comments
APAR Information
APAR number
PK77180
Reported component name
RBD EGL FOR COB
Reported component ID
5724S5001
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-12-09
Closed date
2009-03-20
Last modified date
2009-03-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
RBD EGL FOR COB
Fixed component ID
5724S5001
Applicable component levels
R700 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
20 March 2009