PK70968: Rational Business Developer V7.1.0: SQLCODE -305 received on host variable field defined with ? extension

APAR status

• Closed as program error.

Error description

• Rational Business Developer V7.1.0.1:  SQLCODE -305 received on
  host variable field defined with ? extension.
  
  An EGL GET statement uses the SQL MAX function with a nullable
  variable but in the generated Cobol code no null indicator is
  generated in the SQL SELECT statement.  At runtime, an SQLCODE
  -305 is received.  This error means:
  
    THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE
    NUMBER position-number BECAUSE NO INDICATOR VARIABLE IS
    SPECIFIED).
  
  Example : use of nullable variable in INTO clause
  
  EGL Code
  
  Definition of the result field:
  
    record wy4f028_2   type BasicRecord
      res_Fld   unicode(04)?;
    end
  
  SQL get statement:
  
    get cbvoif10_max singleRow with #sql{
      select max (CTR_NR)
      from   CBVOIF10
      where VAT_RCP_CD = :cbvoif10_max.vat_Rcp_Cd}
    into wy4f028_2.res_Fld;
  
  Generated SQL select statement:
  
    EXEC SQL
      select max (CTR_NR)
      INTO :EZESQL-HOST-VARS.EZESQL-HST-411
      from CBVOIF10
      where VAT_RCP_CD = :EZESQL-HOST-VARS.EZESQL-HST-406
    END-EXEC
  
  Job output:
    select max with nullable type, no records will be found
    Error in select max (CTR_NR), sqlcode: -305
    sqlerrmc: 1
    Max CTR_NR:
  

Local fix

• A tempfix is available from support,
  

Problem summary

• Nullable types were not being checked in all places
  

Problem conclusion

• Fixtest provided
  

Temporary fix

Comments

APAR Information

• 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

  RBDE EGL FOR CO

• Fixed component ID

  5724S5001

Applicable component levels

• R710 PSN

     UP