JR41587: ViewData fails to identify the correct schema of the table when in Request Context

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

• ViewData fails to work when a parameterized table of the form
  <SchemaName>.#Tablename# is being used in the
  'Select Statement' property of the DB2 Connector which is being
  used in a REQUEST context
  

Local fix

• Hard code the schema in the DB2 connector stage
  

Problem summary

• ViewData fails to identify the correct schema of the table when
  in Request Context
  

Problem conclusion

• DETAILS:
  
    ViewData(in Server job) fails to work when a parameterized
  table of the form <SchemaName>.#Tablename# is being used in the
  'Select Statement' property of the DB2 Connector which is being
  used in a REQUEST context.
  
  
  
  RESOLUTION:
  
    This problem has been fixed, ViewData will now be able to
  display the correct result set when any read job with DB2
  Connector as Source, GenerateSQL = NO; and table name of the
  format #Schemaname#.<tablename> is used.
  

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

• R850 PSY

     UP