Fixes are available
APAR status
Closed as new function.
Error description
DB2 Connector supports external tables in all write modes only with generated SQL statements. There is no way to use custom SQL statements together with external tables or temporary work table, not even in Write mode User-defined SQL.
Local fix
n/A
Problem summary
**************************************************************** USERS AFFECTED: DB2 Connector users who want to use external tables with custom SQL statements in User-defined SQL write mode **************************************************************** **************************************************************** PROBLEM DESCRIPTION: DB2 Connector supports external tables in all write modes only with automatically generated SQL statements. There is no way to use custom SQL statements together with external tables or temporary work table, not even in User-defined SQL write mode. **************************************************************** RECOMMENDATION apply patch for JR61935 ****************************************************************
Problem conclusion
Add support for external tables and temporary work table in DB2 Connector's User-defined SQL Write mode. Write using external tables implies the use of temporary work table. The connector introduces two place holders (parameters) that can be used in the custom User-defined SQL to refer to the temporary work table (TWT) and the target table: [[twt]] - temporary work table name [[table]] - target table name The use of placeholders is crucial in automatic temporary work table mode, where the TWT name is not known in advance. The place holders will be replaced with actual names at run time. Examples of user-defined SQL statements using the place holders: INSERT INTO [[table]] SELECT * FROM [[twt]] UPDATE [[table]] SET [[table]].col1 = [[twt]].col1
Temporary fix
Comments
APAR Information
APAR number
JR61935
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B71
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-01-28
Closed date
2020-02-17
Last modified date
2020-02-17
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
RB71 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021