JR35047: DRS STAGE FAILS WITH AN UNEXPECTED TOKEN "M900W40" WAS FOUND FOLLOWING "TRUNCATE TABLE ".

APAR status

• Closed as program error.

Error description

• When running an ETL map on DB2 UNIX with the target update
  action of
  
  the DRS Stage is set to  Truncate and Insert,  the job aborts
  with the
  following message:
  J_Fact_PS_F_LEDGER_TMP..DRS_TGT_PS_S_LEDGER_TMP: [IBM][CLI
  Driver]
  [DB2/SUN64] SQL0104N
   An unexpected token "m900w40" was found following "TRUNCATE
  TABLE ".
  Expected tokens may include:  "JOIN".  SQLSTATE=42601
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ODBC-drs
  ****************************************************************
  PROBLEM DESCRIPTION:
  When running DRS-odbc on DB2 UNIX with the target update action
  of "Truncate" or "Truncate and Insert,"  the job aborts
  with the following message:
  
  J_Fact_PS_F_LEDGER_TMP..DRS_TGT_PS_S_LEDGER_TMP: [IBM][CLI
  Driver][DB2/SUN64] SQL0104N  An unexpected token "m900w40" was
  found following "TRUNCATE TABLE ".
  
  Expected tokens may include:  "JOIN".  SQLSTATE=42601
  ****************************************************************
  RECOMMENDATION:
  apply JR35047
  ****************************************************************
  

Problem conclusion

• fix in JR35047
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP