-v processing

[Dennis Malen]

Nancy,

Thanks for your detail explanation. I have a number of questions for 
clarification of this process..

(1) The lookup you posted here was: lookup - k="M" i=a -nx

With this line wouldn't you need a getnext because of "-nx".

On the other examples you gave and on your site and others they used "-ng" 
which would then take you to the next higher record that was identified in 
"-K="M"".

I assumed that the existence of the -ng there was no need for a getnext. Is 
this distinction incorrect?

(2) The next point I want to question is "Does this approach with the use of 
the -v and the automatic index pertain only to a "lookup -". If I identify 
the name of the file which is not the file I am sitting in and use this same 
technique (-v -In on the command line and a lookup statement in the 
processing that also identifies the use of "In", is that a fatal flaw?

(3) Will the following processing line in file A: system 
"/appl/fp/rreport"<(ba)<"-f"<(bc)<"-v vrab -a -u<(bi)" satisfy your 
requirements for a successful automatic scan in conjunction with the 
reference to the lookup - and an auto index in the -v processing table? 
ba=the name of the file. bc=the format name. bi=the index to be used (-Ib).

(4) There are some that believe the entire technique should be used very 
cautiously (especially if posting payments) as the index could either be 
corrupted or become corrupted. Should there be any concerns here?

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Nancy Palmquist" <nlp at vss3.com>
To: "Dennis Malen" <dmalen at malen.com>
Cc: "filePro List" <filepro-list at lists.celestial.com>
Sent: Friday, June 12, 2009 3:17 PM
Subject: Re: -v processing


> Dennis Malen wrote:
>> Using Nancy's suggestion concerning the use of the automated index I have 
>> found the following:
>> When I use:
>>  ~ If:    ww="" and 3 lt dt
>>  Then: lookup -  k=dt   i=B -ng
>> ------   -   -   -   -   -   -
>>  ~ If: 3 ge dt and 3 le dy     '
>>  Then: select
>> ------   -   -   -   -   -   -
>> I get an additional record that does not meet my criteria. It is the 
>> first record that filepro sees that it seems to accept.
>>
>> In order to fix the problem I reversed the process and used:
>>  ~ If: 3 ge dt and 3 le dy     '
>>  Then: select
>> ------   -   -   -   -   -   -
>>  ~ If:   ww="" and 3 lt dt
>>  Then: lookup -  k=dt   i=B -ng
>> ------   -   -   -   -   -   -
>>  This fixed the problem.
>> I am on 5.0.
>>
>> ANOTHER POINT:
>>
>> I did not have to put the -In on the menu line in order for the index to 
>> work.
>>
>> Dennis Malen
>> 516.479.5912
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>> .
>>
>>
> Dennis,
>
> I saw your comment and thought maybe you just got lucky but you may want 
> to review this information.
>
> The point of the lookup dash (-) is to move you to another record.
>
> So if you picture the file as a list of letters like the alphabet and you 
> start at record A,
>
> you do a lookup - k="M" i=a -nx
>
> What you are doing is moving to record M.  Now that does not identify 
> direction when you select that record and issue an END command.  What 
> insures that you move to the N record is the fact that you used index A 
> which is built alphabetical when you ran the report.
>
> Without doing the -iA on the menu line, what you get is the next record in 
> the file, which may or may not be >M.  If it is not, you will need to do a 
> lookup - to get to M, which kind of puts you in an infinite loop.
>
> Now if you do not move alphabetically by design so you can jump to the 
> beginning of the group and then watch to see when you pass the end of the 
> group, you are jumping all over the file with no end in site.
>
> Remember you can have more than one M entry so you can not get to the 
> second M using lookup - you have to let the normal movement from record to 
> record happen to get all the records you need.
>
> Also you need to issue the SELECT command when you are sitting on a record 
> that matches your criteria and not on the other records, that you need to 
> see at the beginning and end of the file.
>
> Nancy
>
>
>
> -- 
> Nancy Palmquist MOS & filePro Training Available
> Virtual Software Systems Web Based Training and Consulting PHONE: (412) 
> 835-9417    Web site:  http://www.vss3.com
>