JR40886: "VIEW DATA" FAILS FOR DB2 CONNECTOR STAGE IF UNABLE TO FETCH THE TABLENAME FROM USER DEFINED SQL WHEN USING PARAMETER FOR SCHEMA

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• For a job where the DB2 Connector stage has user defined SQL
  (Generate SQL = No), and the table name in the update or insert
  statement is coded with a parameter for schema name (i.e
  #SchemaName#.Tablename ), View Data will fail for that stage
  since it is unable to fetch the correct table name.
  

Local fix

Problem summary

• In a writejob,ViewData failed to display the resultset when the
  tablename was of the format #Schema#.<tablename>
  

Problem conclusion

• DETAILS:
  
    In a writejob partitioner type set to DB2Connector, and
  GenerateSQL = NO; when the table name was of the format
  #Schemaname#.<tablename>, ViewData was not able to fetch the
  correct tablename as SQLBuilder failed to build the correct
  table name from the 'Write Type' property because of which it
  failed to generate the resultset.
  
  RESOLUTION:
  
    This problem has been fixed, ViewData will now be able to
  display the correct result set when any write job with DB2
  Connector as partitioner type, GenerateSQL = NO; and table name
  of the format #Schemaname#.<tablename> is used.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
   a
  

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

• R850 PSY

     UP