PFQUAL= NEED HELP

[hjkelsheimer]

i have never used PFQUAL and am working on an old fedora 5 box with fp5.0 etc. one of the output processes uses this command to run it.

/appl/appl/fp/rreport glcomain -f eoy -s 1 -h "EOY PROCEDURES" -m $PFQUAL

i really don't understand what it is doing since there is no PFQUAL="filename" -- at least that is how i understand the usage of it.


it appears it is setting the fields from some file but how is it doing it.

can anyone please give me some tips or where to look or anything at all to point me the right direction.

"eoy" output processing is shown below:




  1 · If:                                                                   ·
       Then: sy=bom(28+"1")                                                    ·
  2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       · If:                                                                   ·
       Then: 5=sy;6=eom(sy);7=bom(6+"1");8=eom(7);9=bom(8+"1");10=eom(9);11=bom>
  3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       · If:                                                                   ·
       Then: 13=bom(12+"1");14=eom(13);15=bom(14+"1");16=eom(15);17=bom(16+"1")>
  4  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       · If:                                                                   ·
       Then: 19=bom(18+"1");20=eom(19);21=bom(20+"1");22=eom(21);23=bom(22+"1")>
  5  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       · If:                                                                   ·
       Then: 25=bom(24+"1");26=eom(25);27=bom(26+"1");28=EOM(27);29="1";30=5;38>
  6  -------   -   -   -   -   -   -

[Joe Chasan]

PFQUAL sets the default data set for the runtime program (in this case, rreport).
using "-m" overrides default data set with with the given qualifier - but using "-m $PFQUAL" is somewhat redundant since you are saying to override the default with the default.

be that as it may - your quoted processing references bom() and eom() - which are not lookups to some other file, but built-in functions that get the beginning and ending dates of month of their arguments, respectively.

[hjkelsheimer]

wow!! thanks a ton. i have never used those built in functions -- let me work with it a little bit and see if i can get it now.

you also indicate that the -m PFQUAL  is redundant and since no other file is designated it is just looking up itself. correct?? in the file it is running from w/ rclerk right?

the guy i am following has used several time a command that doesn't need to be there etc. but since he died i have to try to decipher what he was doing.

this is all run from a .bat menu file see below:

trap "" 2
/appl/appl/fp/rreport gldocpos -f eoy -v seleoy -a -h "End of Year Procedure" -m $PFQUAL -db -y zzz -iD
/appl/appl/fp/rreport glacctma -f eoy -a -h "End of Year Procedure" -m $PFQUAL
/appl/appl/fp/rreport glcomain -f eoy -s 1 -h "End Of Year Procedure" -m $PFQUAL

does this shed any light on it?? anything else you can tell me about this setup from looking at all this?? any help is appreciated. i have been going thru the processing but this processing shown prev messed me up as i had never used. don't hestitate to let me know if you think of anything else about this that might help me understand what he was doing.

thank you, thank you

hubert

[Joe Chasan]

the -m PFQUAL on the command line tells the entire program called by that command line to operate on the data set $PFQUAL
i just did not get the use of PFQUAL in particular, as choice of variable, since that is a built-in one used to set the default - but either way, redundant or not, it won't hurt.

the quoted processing table does no actual lookups to other files, but if it did, it would use the qualifier in the current and other files designated by $PFQUAL (this can also be overridden on the lookup command line in the process table)

without looking at what your fields are, i'm guessing it is used to set monthly accounting periods start/end dates automatically (using first/last dates of each month)
running it more than once per year, however, might give you a problem since it does not look to see if it already was run, it will increment all again.

to see what records are selected - for the first rreport command line/filename gldocpos, check out process table called seleoy
to see what records are selected - for the second rreport command line/filename glacctma, you are selecting all records in the file
to see what records are selected - for the third rreport command line/filename glcomain, you are selecting all records in the selection set (extended selection) called "1"

[hjkelsheimer]

thanks again. i am reviewing and trying to fix the processing. will go over the sel set also.

hubert