Identify the usage fields of file in all object of lib

[Vishal]

Hi all,

I want to know the process to retrieve all source programs.
My requirement is, where and how the certain fields of file in particular library are used.

Please give any example program to retrieve the program name and how it is used?

Thanks,
Vishal

[Marc_d]

Re: Identify the usage fields of file in all object of lib

SQL AS/400: Find where field used

This searches all tables on the system and gives list of those
that have the field OHPRO7 in them...

Select sys_Tname,sys_Dname From SysTables Where (Sys_TName) In
(Select TBNAME from syscolumns where name = 'OHPRO7')

[Vishal]

Re: Identify the usage fields of file in all object of lib

Hi Marc,

I want to find out all programs which are using a field of file in a particular library.

Thanks for quick reply.

[Marc_d]

Re: Identify the usage fields of file in all object of lib

Easy Field Search:

The next time you want to see where a field is used throughout your system, try this handy shortcut.

Rather than search all your source members using option 25 (Find string)
on Programming Development Manager's (PDM's) Work with Members display,
use the FNDSTRPDM (Find String Using PDM) command.

FNDSTRPDM lets you search for a string in a specified source file in a library, and you can search all the members in the file.

The command lets you display, print, and edit the matching members.

You can also create a report of matching members.

[Vishal]

Re: Identify the usage fields of file in all object of lib

how to create a report for this? I want to specify user defined report name.

Please give me exact command to generate report.

[Marc_d]

Re: Identify the usage fields of file in all object of lib

Type on your commandline:

Selection or command
===> FNDSTRPDM [F4]____________________________________

press: [F10]=extra parameters

press: [PageDown] [PageDown]

now you change:

Print list . . . . . . . . . . .   [B]*YES[/B]          *NO, *YES           
Print records:                                                       
  Number to find . . . . . . . .   [B]*ALL [/B]         *NONE, *ALL, number

[Vishal]

Re: Identify the usage fields of file in all object of lib

Thanks Marc.

it is possible to give outfile name in fndstrpdm command? (or it is generate report any default name)

[babu]

Re: Identify the usage fields of file in all object of lib

Hi,

It generagte the report see in spoolfile.

Thanks
R Babu