Find all instances of a column names in Database files.
Page 1 of 1
Find all instances of a column names in Database files.
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.
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.
Similar topics
» SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
» CPYTOIMPF and CPYFRMIMPF Supports column headings
» Limits w.r.t Database
» What are the different Database (dB) functions?
» Find a String in a DBF records.
» CPYTOIMPF and CPYFRMIMPF Supports column headings
» Limits w.r.t Database
» What are the different Database (dB) functions?
» Find a String in a DBF records.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum