IBM Support

PM85793: ENHANCEMENTS TO FM/DB2 EXPORT TO SUPPORT A USER-SPECIFIED SELECTSTATEMENT AS INPUT

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Enhancements to FM/DB2 export to support a user-specified SELECT
statement as input

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: All users of File Manager DB2 component.     *
****************************************************************
* PROBLEM DESCRIPTION: 1. Provide a means to export data from  *
*                      the result table for a user-specified   *
*                      SQL SELECT statement.                   *
*                      2. Panel error FMN2PEXO when the export *
*                      data set does not exist, and a PDS is   *
*                      specified during the allocation dialog. *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************
1. File Manager DB2 component export function requires a DB2
object as the source, it is therefore not currently possible to
export data from a user-specified SQL SELECT statement without
first creating a view.
2. An invalid field is specified for the cursor position.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 1. Enhancement Apar.  File Manager DB2 component has been
changed to:
a.  Provide a batch option for the editor EXPORT primary
command.
b.  Provide two new keywords (SQLDD and SQLRECSZ) for the batch
FM/DB2 export function (DBX).  SQLDD can be used instead of the
current batch keywords that identify a DB2 object.  SQLRECSZ
can be used to specify the input columns that contain a user-
specified SQL SELECT statement.
2. File Manager DB2 component has been changed to correct the
problem.

Publication Closing Code: DEVCHNG
For the documentation changes associated with this APAR,
please refer to:
ftp://public.dhe.ibm.com/software/websphere/awdtools/
    filemanager/fmv12apar.pdf

The changes are to the following publications:

PUB ID        PUB NAME
------------  ----------------------------------------

SC19-3675-01 File Manager for z/OS V12R1 User's Guide and
             Reference for DB2 Data

The latest published manuals can be found at:
http://www.ibm.com/software/awdtools/filemanager/library/
       index.html.

    



APAR Information




    

  • APAR number
    PM85793
    • 

  • Reported component name
    FILE MANAGER Z/
    • 

  • Reported component ID
    5655W6800
    • 

  • Reported release
    C12
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2013-03-27
    • 

  • Closed date
    2013-06-30
    • 

  • Last modified date
    2013-08-02
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • FMN2LVL  FMN2LVLJ FMN2LVLK

    




Publications Referenced


SC19367501    





Fix information


    

  • Fixed component name
    FILE MANAGER Z/
    • 

  • Fixed component ID
    5655W6800
    • 



Applicable component levels


    

  • RC1B  PSY  UK95757
       UP13/07/13  P  F307
    • 

  • RC12  PSY  UK95759
       UP13/07/13  P  F307
    • 

  • RC13  PSY  UK95760
       UP13/07/13  P  F307
    • 



Fix is available


    

  • Select the PTF appropriate for your component level.
You will be required to sign in. Distribution on physical
media is not available in all countries.
    








      
              
                            

              

              [{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 August 2013
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback