IBM Support

PH47212: FETCH IN DELETE STATEMENT CAUSED WARNING [999] : SYNTAX ERROR: 'FETCH' DURING COBOL BUILD.

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

  • FETCH in DELETE statement caused

    Warning [999] : Syntax error: 'FETCH'

during Cobol build.

Local fix

  • n/a

Problem summary

  • The AD Cobol compiler would not recognize the SQL FETCH clause
in the context of a SQL DELETE statement.

Problem conclusion

  • Fixed by adding support for DELETE...WHERE...FETCH SQL syntax in
 the AD Cobol compiler.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH47212
    • 

  • Reported component name
    APPL DISCOVERY
    • 

  • Reported component ID
    5737B1600
    • 

  • Reported release
    600
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-06-14
    • 

  • Closed date
    2022-10-12
    • 

  • Last modified date
    2022-10-12
    • 





    

  • 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
    APPL DISCOVERY
    • 

  • Fixed component ID
    5737B1600
    • 



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSRR9Q","label":"IBM Application Discovery"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"600","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 October 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback