PI25564: S0C4 ABEND IN ADVANCED SQL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An S0C4 abend (SYSTEM COMPLETION CODE=0C4  REASON CODE=0000003B)
  can occur in module HAA$TSQL when executing Advanced SQL.  The
  following message will also appear in ISPF:
    Abend 0C4000 hex occurred processing command 'HAA$MAIN'.
  .
  The problem occurs when there is a comma immediately preceding a
  column name.
  

Local fix

• Reformat the SQL and place the commas following the column
  names.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: S0C4 ABEND IN ADVANCED SQL              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An S0C4 abend (SYSTEM COMPLETION CODE=0C4  REASON CODE=0000003B)
  can occur in module HAA$TSQL when executing Advanced SQL.  The
  following message will also appear in ISPF:
    Abend 0C4000 hex occurred processing command 'HAA$MAIN'.
  
  The problem occurs when there is a comma immediately preceding a
  column name.
  

Problem conclusion

• Code has been added to correct this issue.
  

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:

  UI27178 UI27179

Modules/Macros

•    HAA#TS10 HAA#TS7  HAA#TS8  HAA#TS9
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R410 PSY UI27178

     UP15/05/06 P F505

• R420 PSY UI27179

     UP15/05/06 P F505

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.