JR48623: ODBC CONNECTOR LOB REFERENCE JOBS WITH BIGINT AS KEY ABORT WITH INCORRECT SYNTAX ERROR

InfoSphere Information Server, Version 11.3 for Microsoft Windows
InfoSphere Information Server, Version 11.3 for AIX
InfoSphere Information Server, Version 11.3 for Linux
IBM InfoSphere Information Server Enterprise Edition V11.3 for Windows

APAR status

• Closed as program error.

Error description

• ODBC Connector LOB jobs with BIGINT as key aborts with
  incorrect syntax error due to invalid locator query generation.
  
  
  Message seen
  
  ODBC_Connector_1,0: ODBC function "SQLExecDirect" reported:
  SQLSTATE = HY000: Native Error Code = 102: Msg = [IBM
  (DataDirect OEM)][ODBC SQL Server Wire Protocol
  driver][Microsoft SQL Server]Incorrect syntax near '='.
  (CC_OdbcInputStream::open, file CC_OdbcInputStream.cpp, line
  121)
  

Local fix

• Use another supported dataype for primary key column in source
  table.
  
  Disable lob referenes, in which case you may need to increase
  the value of APT_DEFAULT_TRANSPORT_BLOCK_SIZE for the job.
  

Problem summary

• ODBC Connector LOB jobs with BIGINT as key abort with invalid
  syntax error due to incorrect locator query generated.
  

Problem conclusion

• Code has been corrected generate the locator query properly.
  

Temporary fix

• Pass them inline or use another type as key column.
  

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

• R850 PSY

     UP

• R870 PSY

     UP

• R912 PSY

     UP