PQ17675: USER ABEND U002 DUE TO AN ABEND S0C1 IN MODULE DRLPSQL WHILE EXECUTING ONLINE A REPORT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User abend code 0002, reason code 00000000.
  Abend in external subroutine DRL1SQLX.
  Program Check 1  (operation)
    In module DRLPSQL  97.343 5695101 starting at 075181C8
    executing 00000002  0000813F AAA00000 00000000 000000FD
    at address 00000002
  The module was
    called from offset 00001646
    in module DRL1SQLX 97.343 5695101 starting at 0751C790
  Register contents at termination:
    R0 000C515C  R4 00000000  R8 00000007 R12 075181C8
    R1 000C511C  R5 40000000  R9 00000000 R13 000C5888
    R2 000C515C  R6 00000000 R10 0751E78E R14 840C002A
    R3 000C52F2  R7 00000000 R11 0751D78F R15 00000000
  
  IRX0251E User abend code 0002, reason code 00000000.
  IRX0254E Abend in external subroutine DRL1SQLX.
  IEA995I SYMPTOM DUMP OUTPUT
    USER COMPLETION CODE=0002
   TIME=15.04.47  SEQ=00217  CPU=0000  ASID=002B
   PSW AT TIME OF ERROR 078D0000  87519CDE ILC 2 INTC 0D
  ACTIVE LOAD MODULE   ADDRESS=07514330  OFFSET=000059A
  NAME=DRL1SQLX
   DATA AT PSW  07519CD8 - 40001810  0A0D90EC  D090D20F
   GPR  0-3  00000002  00000002  00000002  00000002
   GPR  4-7  0751B8F0  00000001  00000000  00000000
   GPR  8-11 000CB000  00000000  0751E78E  0751D78F
   GPR 12-15 07519C28  000CB150  87519CD6  0751ACA8
  END OF SYMPTOM DUMP
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All PR/MVS V1R2M0 and V1R3M0 users.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: User abend code 0002 (U0002) in module  *
  *                      DRL1SQLX due to ABEND S0C1 Program      *
  *                      Check 1 in module DRLPSQL.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The user enters an SQL statement ended with a semicolon
  to run an online report w/o using QMF.
  At that point an abend S0C1 (ABENDS0C1) in module DRLPSQL
  occurs.
  The DRLERDIR exec doesn't handle an SQL statement ended
  with a semicolon.
  

Problem conclusion

• The DRLERDIR exec has been changed. A STRIP
  function has been added to delete the semicolon
  into the input query, if present.
  201Y
  301Y
  DRLERDIR
  

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:

  UQ19899 UQ19900

Modules/Macros

• DRLERDIR
  

Fix information

• Fixed component name

  EPDM 1.1

• Fixed component ID

  569510100

Applicable component levels

• R201 PSY UQ19900

     UP99/01/26 P F901 Ž

• R301 PSY UQ19899

     UP99/01/26 P F901 Ž

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.