JR50776: OPTIMIZED DATASTAGE JOB FAILS WITH TERADATA ERROR: RDBMS CODE 5758: THE SEARCH CONDITION MUST FULLY SPECIFY THE TARGET TABLE

APAR status

• Closed as program error.

Error description

• A DataStage job containing Teradata Connector stages as source
  and target, and fully optimized with the Balance Optimizer tool
  fails at run time with the following error:
  RDBMS code 5758: The search condition must fully specify the
  Target table primary index and partition column(s) and
  expression must match INSERT specfication primary index and
  partition column(s)
                                                                 .
  The generated merge statement is missing table reference for
  one or more columns.
  

Local fix

Problem summary

• ERROR DESCRIPTION:
  A DataStage job containing Teradata Connector stages as source
  and target, and fully optimized with the Balance Optimizer tool
  fails at run time with the following error:
  RDBMS code 5758: The search condition must fully specify the
  Target table primary index and partition column(s) and
  expression must match INSERT specfication primary index and
  partition column(s)
                                                                 .
  The generated merge statement is missing table reference for
  one or more columns.
  

Problem conclusion

• The fix for this APAR is an a patch which addresses APARs
   JR50953 JR50960 JR50776
  

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

• R912 PSY

     UP