IBM Support

JR25953: SQL-BASED REPLICATION, SUBSCRIPTION ON MSSQL TARGET DOES FAILS IF COLUMN TYPE IS VARCHAR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the source column is of VARCHAR type, and if you
    attempt to create a subscription in SQL Replication env,
    and if target table does not exist on MSSQL  server,
    The SQL generated script will create the target table
    and maps the column type varchar to text.
    

Local fix

  • na
    

Problem summary

  • AS DESC IN THE APAR
    

Problem conclusion

  • FIXED IN API
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR25953

  • Reported component name

    WS Q-REPLIC LUW

  • Reported component ID

    5724N9801

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-02-14

  • Closed date

    2008-08-08

  • Last modified date

    2008-08-08

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

    GG04729

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

Fix information

  • Fixed component name

    WS Q-REPLIC LUW

  • Fixed component ID

    5724N9801

Applicable component levels

  • R910 PSY

       UP

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

Document Information

Modified date:
07 January 2022