Re: DSPPGMREF and referenced libraries

On 6/30/2023 8:41 AM, tim ken wrote:

To get the references of all the objects i did DSPPGMREF (*ALL/*ALL)
OUTPUT(*OUTFILE) OBJTYPE(*ALL) OUTFILE(Mylib/myfile)

So after executing the above command a outfile with name myfile in mylib
got generated but the problem is that in select SQL query from above file
in 'WHLNAM'
field library name coming incorrectly except for library names 'QTEMP' and
'*LIBL'

Did I do something wrong here? Any suggestions on this please?

Why do you think WHLNAM is incorrect?

*all/*all is probably a very large file, if you have sufficient authority when issuing DSPPGMREF. You might not have seen enough records to judge that all of them are *LIBL or QTEMP. Try select * from mylib.myfile where whlnam not in ('QTEMP', '*LIBL'); Let the machine do some of the work. Consider select whlnam, count(*) from mylib.myfile group by whlnam order by whlnam;