ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Find all source files on the system

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

  • Find all source files on the system

    I am moving all source to an SVN repository.

    My problem is to find all the source files.

    Does anyone know how I could find all the source files (PF-SRC) from ALL libraries.

    I know I could do it library by library, this is a mature system with far too many libraries.

    Any suggestions appreciated.


  • #2
    I used DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*FILE) OUTPUT(*OUTFILE)

    When I used it I thought the attribute would be PF-SRC. It is not. It is PF.

    I can use that.

    Comment


    • #3
      I believe this will do it:

      select * from systables
      where file_type = 'S'
      and table_type = 'P'

      The SYSTABLES view contains one row for every table, view or alias in the SQL schema, including the tables and views of the SQL catalog.


      Cheers,

      Emmanuel

      Comment


      • #4
        Thank You. That is better than What I was using.

        Comment


        • #5
          This is what I used

          SELECT substr(TABLE_NAME,1,20), substr(TABLE_SCHEMA,1,20)
          FROM systables WHERE file_type = 'S' and table_type = 'P'
          order by table_schema


          Comment

          Working...
          X