ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Reading IFS Entries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reading IFS Entries

    Hi All,

    Is there any SQL command in v7r3 which can list all the IFS entries along with Created date, Modified date of the stream files?
    Regards,
    Vinothkumar S.

  • #2
    Here is a little open source thing.


    Regards

    Kit
    http://www.ecofitonline.com
    DeskfIT - ChangefIT - XrefIT
    ___________________________________
    There are only 3 kinds of people -
    Those that can count and those that can't.

    Comment


    • #3
      The RTVDIRINV CL Command will generate 2 files (one ended with D = Directory Information and the otherone ended with O = File Information)
      If you join both files with SQL using the QEZDIRIDX column located in both files, you'll get all information about the IFS directory including the creation and modification date of the stream files
      Code:
      select * from YourSchema/YourPrfxD d join YourSchema/YourPrfxO o on d.qezdiridx = o.qezdiridx;
      Birgitta

      Comment


      • #4
        Thanks
        Regards,
        Vinothkumar S.

        Comment

        Working...
        X