PURGE QUERYIN,TEMP
PURGE QUERYIN
[disregard warnings for files that do not exist]
ECHO BASE=dbname.group.account                > QUERYIN
ECHO readpass                                 >>QUERYIN
ECHO 5                                        >>QUERYIN
ECHO SET=dataset                              >>QUERYIN
ECHO FIND field = !HPYYYYMMDD                 >>QUERYIN
ECHO some additional Query commands           >>QUERYIN
ECHO EXIT                                     >>QUERYIN
RUN QUERY.PUB.SYS<QUERYIN

Note: the single '>' in the first ECHO statement is intentional.

===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax:   617-509-3737
pager: 781-226-2431







Kim Borgman <[log in to unmask]> on 12/13/2000 12:41:55 PM

Please respond to [log in to unmask]








 To:      [log in to unmask]

 cc:      (bcc: Leonard Berkowitz/CORP/HPHC)



 Subject: [HP3000-L] HPVARIABLES IN QUERY








I am trying to write a quick little query rpt.

I want to search on date.  Todays date in fact.  Want to use the contents of
hpvariable HPYYYYMMDD.

so I am doing a find in query:  f entry-date = !hpyyyymmdd

No good.

Anyone have any clues how to get query to accept the hpvariables ?

thanks in advance.

Mr Kim Borgman - IS Mgr
NWS Corp
317-636-6092 x1399