Qa400 Jun 16, 2011   7:58 PM GMT

I am afraid that is beyond my current Iseries skills. I have no idea what the database looks like, etc. But thanks for the suggestion!!!

45 pointsBadges:

TomLiotta Jun 16, 2011   11:47 PM GMT

I have no idea what the database looks like... You shouldn't need to know. The query interface will tell you. Can you explain a little more what file attributes you're looking at? Tom

125,585 pointsBadges:

philpl1jb Jun 17, 2011   9:48 AM GMT

Since you have a database, you could use the command DSPPFM (Display physical file member) it has a search like find string. But the query/400 tool is very easy to use .. WrkQRY command will start it. Plenty of info on it available on the Web or come back here with your questions. Phil

54,090 pointsBadges:

Qa400 Jun 17, 2011   3:21 PM GMT

Tom - I am looking at many different attributes - I am testing a software product and I want to be able to easily verify in an automated way that certain attribs are being set correctly via the software when it creates a file. (alwdlt, alwupt, delpct,expdate,etc) There will be many tests so I was trying to keep as simple as possible. I will take a look at the query interface - Thanks for your help

45 pointsBadges:

Qa400 Jun 17, 2011   3:23 PM GMT

Thanks Phil - I am going to look into the query tool.

45 pointsBadges:

AnchorS Jun 17, 2011   6:20 PM GMT

If youi're looking for the attributes of the file, you're using the right command, dspfd, just dump it to an *outfile. You'll need to provide the file name and library. Then query the resulting database file.

380 pointsBadges:

TomLiotta Jun 17, 2011   7:18 PM GMT

I am testing a software product and I want to be able to easily verify in an automated way that certain attribs are being set correctly... In that case, you probably want a basic CL program that does most/all of the work. Try these two commands to get some background on what happens:

DSPFD FILE(QAFDPHY)
      TYPE(*ATR)
      OUTPUT(*OUTFILE)
      FILEATR(*PF)
      OUTFILE(QTEMP/ATR)
RUNQRY QRYFILE((QTEMP/ATR))

The DSPFD command converts the attributes of one of the system files on your system into an outfile. The RUNQRY command does a basic query of the content of the outfile. The outfile is created in QTEMP, so it will disappear when you sign off of your session. That system file is one of the "model" files that are supplied with your system. In fact, it's the model that is used by the DSPFD command when you request TYPE(*ATR) for FILEATR(*PF) files. So the DSPFD command is retrieving the attributes of the file that defines what the output of the DSPFD output will contain -- kind of a circular reference there. (It seemed like a good example to use.) By looking at what RUNQRY shows, you can see if the attributes that you're looking for are supplied. If they are, then the rest is fairly straightforward. If they aren't, then we need to know what else you need to see. Post back if this is a direction we can go or not. Tom

125,585 pointsBadges:

TomLiotta Jun 17, 2011   7:22 PM GMT

BTW, what is your programming background? A Windows or Unix background might indicate other directions are better. Tom

125,585 pointsBadges:

Qa400 Jun 20, 2011   12:31 AM GMT

Thanks Tom. I am going to try the CL programming. I have done some things in CL but by no means an expert. My background is MVS - Z/os. I do not have a development background so things get tricky for me sometimes.

45 pointsBadges:

Featured Member: AnchorS - ITKE Community Blog Jun 21, 2011   6:51 AM GMT

[...] I want to dump the contents of the DSPFD command to file and then use FNDSTRPDM to find certain text... [...]

0 pointsBadges: