PI52915: A SIMPLE WARNING FROM DB2 ABOUT A SEMI-COLON AT THE END OF THE SQL STATEMENT RESULTS IN A MAP FAILURE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Testing with a simple map doing a select from a table.
  
  When the JCL has an input override like this:
  
  -ID1 '-STMT SELECT * FROM TEST1'
  
  ...the map completes successfully.
  
  Hoeever, when it is changed to:
  
  -ID1 '-STMT SELECT * FROM TEST1;'    <--- (note the semi colon
                                               at the end)
  
  ...then DB2 issues a warning, and the map fails.  Audit shows:
  
  <ExecutionSummary MapStatus="Error" mapreturn="75"
  ElapsedSec="-0.7993" BurstRestartCount="0">
     <Message>Adapter failed to get data on input</Message>
     <CommandLine>MAPTORUN -AE -WH -TIO -ID1 '-STMT SELECT * FROM
  TEST1;' -OF1 OUTPUT</CommandLine>
  
  <SourceReport   card="1"   adapter="DB"   bytes="0"
  adapterreturn="-1006">
     <Message>Failed to prepare the SQL statement</Message>
     <Settings>0006106D4EF0</Settings>
  </SourceReport>
  
  JOBOUT shows:
  
   Starting a database unload...
   Query      : SELECT * FROM TEST1;
   Query size : 20
   Context: Input Card, Transaction scope: Map
   On Failure: Rollback, On Success: Keep
   TRACE command specified, file: //DD:DBTRACE
   DBS_ExecuteStmtDirect: EXEC SQL PREPARE Q(0-7) FROM :sqlst
   SELECT * FROM TEST1;
   DSNT404I SQLCODE = 098, WARNING:  A DYNAMIC SQL STATEMENT ENDS
   WITH A
   SEMICOLON
   DSNT418I SQLSTATE   = 01568 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNHTOKR SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00002710'
                         X'42DB09EB'  X'00000013'  X'00000322'
  

Local fix

• WTXCQ - WTX00047862
  PB / PB
  As a workaround, avoid SQL statements that produce warnings in
  DB2
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of WebSphere Transformation        *
  *                 Extender V8.3                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: A SIMPLE WARNING FROM DB2 ABOUT A       *
  *                      SEMI-COLON AT THE END OF THE SQL        *
  *                      STATEMENT RESULTS IN A MAP FAILURE.     *
  ****************************************************************
  * RECOMMENDATION: Apply this maintenance                       *
  ****************************************************************
  A SIMPLE WARNING FROM DB2 ABOUT A SEMI-COLON AT THE END OF THE
  SQL STATEMENT RESULTS IN A MAP FAILURE.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI52652

• APAR is sysrouted TO one or more of the following:

  UI33202

Modules/Macros

• DTXMPAXB
  

Fix information

• Fixed component name

  WTX INT SRVR ZO

• Fixed component ID

  5655R9503

Applicable component levels

• R833 PSY UI33202

     UP15/11/25 P F511

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.