ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Check CCSID for many files at the same time

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

  • Check CCSID for many files at the same time

    Hello !

    How is going on

    I have an issue need your help , Does anyone know how to check CCSID for many PF file at the same time , otherwise we need to check one by one with command DSPFD ?

    Many thanks for your help

  • #2
    The SYSCOLUMNS catalog view (in the QSYS2 library) lists all columns in all tables, views, physical and logical files.
    Among other information you also get the CCSID of the columns.
    With a simple SELECT statement you can get information about columns in multiple files.

    Birgitta

    Comment


    • #3
      Hi Birgitta
      Thank you so much for your reply , I always recieve the nice support from this room , Hope this room will be bigger and bigger

      Have a nice day

      Tintin

      Comment

      Working...
      X