Scribd Logo
Upload

Welcome to Scribd!

  • 119 views

    DB2 LF

    Uploaded by

    Arpit Sangal
    Logical files provide a logical view of physical files by allowing users to filter and select specific fields and records. They are created using the CRTLF command and can be used to change the access path or view a subset of data from the associated physical file. Common commands for logical files include CRTLF to create them, DSPFD to view file descriptions, and RUNQRY to view filtered data from the physical file through the logical file.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd

    DB2 LF

    Uploaded by

    Arpit Sangal
    119 views5 pages
    Logical files provide a logical view of physical files by allowing users to filter and select specific fields and records. They are created using the CRTLF command and can be used to change the access path or view a subset of data from the associated physical file. Common commands for logical files include CRTLF to create them, DSPFD to view file descriptions, and RUNQRY to view filtered data from the physical file through the logical file.

    Original Description:

    This presentation provides information about a Logical File.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Logical files provide a logical view of physical files by allowing users to filter and select specific fields and records. They are created using the CRTLF command and can be used to change the access path or view a subset of data from the associated physical file. Common commands for logical files include CRTLF to create them, DSPFD to view file descriptions, and RUNQRY to view filtered data from the physical file through the logical file.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    119 views5 pages

    DB2 LF

    Uploaded by

    Arpit Sangal
    Logical files provide a logical view of physical files by allowing users to filter and select specific fields and records. They are created using the CRTLF command and can be used to change the access path or view a subset of data from the associated physical file. Common commands for logical files include CRTLF to create them, DSPFD to view file descriptions, and RUNQRY to view filtered data from the physical file through the logical file.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 5

    LOGICAL FILE

    Defn: - LF is a logical file which contains the logical view of the physical file
    Points to be Remembered: CRTLF Command is used for creating the object of logical file Its object type is * File Its attribute is LF PFILE keyword is needed for the logical file [PFILE (Physical File Name)]

    Use of the Logical File


    For changing the access path* To see the limited no. of fields of the physical file To see the filtered data (Select / Omit)

    * Access Path is a way to retrieve the data from the database file, the way can be: Arrival Sequence Keyed Sequence
    Step Ahead Technologies Pvt. Ltd. 1

    Commands related to Logical File


    CRTLF - To create the object of the logical file DSPFD - To see the description of the file DSPFFD - To see the file field description DLTF
    - To delete all file type of the objects

    UPDDTA - To update the data through the logical file in physical file

    RUNQRY - To see the data of the physical file


    ADDLFM - To Add Logical File Member CHGLF - To Change Logical File

    CHGLFM - To Change Logical File Member

    Step Ahead Technologies Pvt. Ltd.

    Data Types used in Physical File


    A S P T Z L - Specify Alpha Numeric (Both character & numeric) Data - Specify Zoned Decimal Data - Specify Packed Decimal Data - Specify Time Data - Specify Time Stamp Data - Specify Date Data

    Prompt used for Logical File IPLF (Input Prompt for Logical File) Name Type
    ____

    Name
    EID

    Length
    ___

    Data Type
    ____

    Decimal Positions
    __

    Use
    __

    Functions _____________________________

    Step Ahead Technologies Pvt. Ltd.

    Examples of Logical Files


    File Level R Rec EID ENAME EAGE ESAL EDEG K EID S EID O EAGE S PFILE (PF01) 3A 10A 2 6 10A Record Format Level

    0 2

    Field Level Key Field Level COMP(GT 503) COMP(LT 40) ALL Select / Omit Level

    Levels of the Logical File


    File Level Record Format Level Field Level Key Field Level Select / Omit Level

    Step Ahead Technologies Pvt. Ltd.

    KEYWORDS
    File Level
    Unique (PF / LF)
    REF (PF) FIFO (PF / LF) LIFO (PF / LF) FCFO (PF / LF) Refaccpth (LF) Dynslt (LF)

    Record Format Level


    JFILE (JLF) PFILE (LF) FORMAT (PF / LF)

    Field Level
    Comp (PF / LF) Cmp (PF / LF) Rename (LF) Concate (LF) SST (LF) Range (PF / LF) DFT (PF) REFFLD (PF) ALWNULL (PF) COLHDG (PF / LF) DATFMT (PF / LF) DATSEP (PF / LF) TIMEFMT (PF / LF) TIMESEP (PF / LF)

    Key Field Level


    ASCEND (PF / LF) DESCEND (PF / LF)

    Select / Omit Level


    COMP CMP VALUE RANGE

    NOTE: All the keywords are specified in function parameter of IPLF Prompt
    Step Ahead Technologies Pvt. Ltd. 5

    You might also like