IBM Support

PI59971: SQL BATCHING IS NOT SUPPORTED WHEN THE TRANSLATOR IS RUN IN STAND ALONE MODE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • SQL batching is not supported when the translator is run in
    stand alone mode.
    
    The following is the translator log after running the
    translation through the Java API.
    
    The Batching is turned off during translation.
    
    [1:main] [2016-03-22 16:19:47.928] DEBUG  000620070008
    TRANSLATION.TRANSLATION_ENGINE.DEB_TranslationEngineImpl_str3
    Writing output...
    [1:main] [2016-03-22 16:19:47.995] ALL  [SQLWriter] executeSQL()
    : SQL batching is off
    

Local fix

  • WTXCQ - WTX00048413
    LV / LV
    Circumvention: None
    

Problem summary

  • Users Affected:
    Customers running Sterling SQL maps in SPE/ITXA
    
    Problem Description:
    Enabling ?sql.statement.UseBatching? is not taking effect when
    a map editor SQL map is run in an SPE context.
    
    Platforms Affected
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    
    
    Delivered In:
    SPE.COMMON.8.5.1.1
    SPE.COMMON.9.0.0.1
    5020601_7
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI59971

  • Reported component name

    SPE

  • Reported component ID

    5725SPE00

  • Reported release

    200

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-30

  • Closed date

    2016-08-15

  • Last modified date

    2017-03-08

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

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

Modules/Macros

  • MAPEDITR
    

Fix information

  • Fixed component name

    SPE

  • Fixed component ID

    5725SPE00

Applicable component levels

  • R201 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDF7K","label":"Transformation Extender Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
15 May 2022