This can be done... by reading the PARTFILE into a table with
part-number as the key and storing part-description also in the same
table using the data option.

Sample query...

TABLE
PART-FILE-TBL,PART-NUMBER,FILE,partFILE,HOLD,DATA(part-description)

GET PARTS
IF $LOOKUP (.....)
EXT DESCRIPTION =$LOOKUP(PART-FILE-TBL,PART-NUMBER,PART-DESCRIPTION)

Rest of the Query is left to you....

I Think this will work....

Warm Regards
Venkat 

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Newton, Ernie
Sent: Friday, September 17, 2004 3:08 PM
To: [log in to unmask]
Subject: [HP3000-L] Suprtool $LOOKUP & UPDATE

Greetings,

I don't believe I can do what I want to do in Suprtool, but there
are far better minds on this list than me...so maybe there's hope.

I have a self-describing file, created using Suprtool, it looks like
this;

PART-NUMBER
PART-DESCRIPTION

Lets call that file PARTFILE

Now, using $LOOKUP, I want to look in my PARTS dataset for 
a matching PART-NUMBER. When true, I want to UPDATE 
the item DESCRIPTION with PART-DESCRIPTION, from PARTFILE.

I think it would look like this...

GET PARTS
IF $LOOKUP(blah, blah, blah)
UPDATE
EXT DESCRIPTION=PART-DESCRIPTION

Does that work?  I don't want to just "try it and see" for obvious
reasons.

Thanks,

Ernie

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *