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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback