IBM Support

JR34764: A WRONG 'CREATE TABLE" SQL STATEMENT IS GENERATED WITH [CREATE] IN ODBC CC STAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Summary]
    A wrong 'create table" sql statement is generated with
    [generate] button when a table name is set using a variable of a
    parameter set.
    
    
    [Details]
    THis occurs in [Properties]tag of ODBC Connector stage.
    
    When settings in [Properties]tag  are below, a wrong "create
    table" sql statement is generated.
    
    - Table name : set a variable in a parameter set
    - Table action : create or replace
    - Generate create statement when a job is launched : No
    
    When pushinng [generate] button for "Create Statement" in the
    right side of the window and click the same variable as the one
    in "Table name", unnecessary tags like below are added in
    "create table" sql statement.
    
    CREATE TABLE TableName><EnableQuotedIDs type='bool'><![CDATA[0 (
    c1 INTEGER NOT NULL,   c2 CHAR(4) NOT NULL   )
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users using Common connectors on 8.1 and above IS builds
    ****************************************************************
    PROBLEM DESCRIPTION:
    A wrong 'create table" sql statement is generated with [create]
    button in ODBC CC stage when a table name is set as a variable
    of a parameter set.
    
    The problem is described for ODBC , but appears for all
    connectors.
    ****************************************************************
    RECOMMENDATION:
    Apply patch "patch_JR34764v2_client_windows_8101.zip"
    available in the patch server.
    ****************************************************************
    

Problem conclusion

  • The above problem is seen because the replacement of parameters
    in the generated SQL statement is not correct
    
    Fix - This has now been fixed by not replcaing the parameters in
    the generated SQL statements and leaving them to be resolved at
    runtime.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34764

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-06

  • Closed date

    2010-02-02

  • Last modified date

    2010-02-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • CLIENT
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R810 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021