Retrieving file’s keys with SQL, having to use DSPFD Simon Hutchinson

​[[{“value”:”In my last post I wrote about how to list a file’s key fields using the file QADBKATR to retrieve the key fields’ information from.
I mentioned that there may be times that you are not authorized to use the QADBKATR file. If you are not authorized how else can you get the key fields? And present them as I did in the previous example?
I have to fall back and use the Display File Description command, DSPFD, using the Access Path value in the “Type of information” parameter:

DSPFD FILE(MYLIB/TESTFILE) TYPE(*ACCPTH)

Read more »”}]] Read More 

Leave a Reply

Verified by MonsterInsights