JR40362: SQL BUILDER DOES NOT HANDLE LISTS OF TABLES CORRECTLY

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1

APAR status

• Closed as program error.

Error description

• SQL Builder does not handle lists of tables correctly
  
  1. First table name is missing in a returned list of tables
  2. <Table> tag repeats  many times when it contains parameters
  3. Tables sometimes appear as alias names rather than actual
  table names in a returned list
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Applies to all jobs designed using connectors to read a database
  with userdefined select statement, where in userdefined select
  statement has job parameters in it.
  ****************************************************************
  PROBLEM DESCRIPTION:
  In database read jobs using connectors, when a user defined SQL
  with job parameters is used, the design time parsing for
  tablenames and columns is has some drawbacks, from the user
  defined SQL statements tablenames and columns tokens are
  required to pass to the connector runtime and hence job run is
  failing.
  ****************************************************************
  RECOMMENDATION:
  Apply the patch JR40362.
  ****************************************************************
  

Problem conclusion

• The connector UI code is fixed to read the tokens (tablenames
  and columns) correctly passed by the SQLBuilder and pass to
  connector runtime
  

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

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R810 PSY

     UP

• R850 PSY

     UP