Error when doing a lookup from a qualified file?

[Richard Kreiss]

Top post:

Are you copying to another file with the same qualifier?

If not change the file name to:

lookup filename@  k=41   i=b -nx

The @ sign tell your program to post to the unqualified file.


Richard Kreiss
GCC Consulting

Office: 410-653-2813



> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Bob Simcoe
> Sent: Friday, April 04, 2014 11:20 AM
> To: filepro-list at lists.celestial.com
> Subject: Error when doing a lookup from a qualified file?
> 
> Hi
> I only have one file with qualifiers, that only holds records. I never did any
> input processing with this file. Recently I needed to copy selected records
> using input processing. Sitting on the selected record in the qualified file I use
> the @wlf and the copy command to copy the record to the other file. I get the
> error below. I tested coping to other files and I get the same error. I used the
> same processing in a non-qualified file record and it worked correctly. Is the
> some restriction running input processing with a qualified file?
> 
> *** A System Error Has Occurred ***
> 
> On File: S:/filepro/filename/map
> 
> Input Processing
> Line Number: 9
> 
> lookup filename  k=41   i=b -nx
> ^
> Invalid argument
> 
> Thank you
> Bob Simcoe
> CFO
> Mid-City Office Equipment Inc.<http://www.midcityoffice.com/>
> A Women Business Enterprise
> P. 716.832.0138 x201
> C. 716.725.8311
> F. 716.832.0892
> Follow us on Facebook<http://www.facebook.com/pages/MidCity-Office-
> Furniture/298763689497?ref=ts>
> 
> For a Better Day at the Office
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20140404/e6eee658/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list