PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Find all instances of a column names in Database files.

Go down

Find all instances of a column names in Database files. Empty Find all instances of a column names in Database files.

Post  maran Sun Jun 30, 2013 9:06 pm

Native method to find all instances of a column name in the database file is do DSPFFD

For example  DSPFFD FILE(*ALL/*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/FFDOUT)  

Instaed we can query the file COLUMNS which is present in the library QSYS2. Ofcourse this is faster.
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum