Unix type *for $file in loop* for Quiz?

[Ronald W. Olenic]

This is a multi-part message in MIME format.
--------------CCF793A70C78A1FDB04F3AD5
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Stamps!

:quiz
>access *raw_sub   &
>  link d_invoice to invoice of somefile
> 
> report ....
>
>
This would take the invoice number from the subfile and create a link to
only the records in the data file that you want to extract.

For more complicated manipulation of data, you can access the subfile in
QTP as well.

The opinions expressed are my own, and for the most part, have a firm
basis in reality.
 
"Stamps, Theron" wrote:
> 
> Theron J. Stamps
> Systems Analyst
> San Angelo Standard-Times
> Voice:  915.659.8220
> Pager:  1.800.788.0207
> Text Pages:  www.skytel.com
> Email:  stampstj@texaswest.com
> Emergency Email:  theron@beepwear.net
> (This will cause a pager notification to be sent)
> 
> > -----Original Message-----
> > From: Ronald W. Olenic [SMTP:olenicr@dteenergy.com]
> > Sent: Monday, February 21, 2000 2:18 PM
> > To:   'PowerHouse List'
> > Subject:      Re: Unix type *for $file in loop* for Quiz?
> >
> > Hello!
> >
> > If I understand the question, you have a file with multiple records that
> > you want quiz to read.
>         [Stamps, Theron]  Yes and no, it needs to read the file to get the
> invoice numbers and use them to control the database extraction.
>         I was hoping to do the following, or something like it
> 
>         sh>For $NUM in RAWFILE
>         sh>>do
>         sh>>Database
>         sh>>  Extraction
>         sh>>    Routine for $NUM.
>         sh>>done
>                 Basically Quiz would run the information extraction while
> refering back to RAWFILE for qualifying accounts.  If RAWFILE contained
> 1,2,3,4,... then it would extract info on invoice 1,2,3,4,........
> 
>         Is this *do-able*?
> 
> > For PowerHouse to read the file, it must be a fixed length record.  If
> > this is the case, there are two ways for quiz to read a file.  Create a
> > dictionary definition for your "raw" file, or create a subfile
> > definition for your "raw" file.  either way, you will need to know the
> > record definition.
> >
> > For example if the raw file contains a 5 character invoice, you would
> > need to do the following.
> >
> > > define d_invoice char * 5 = "ARRGH"
> > > set subfile name raw_sub portable keep
> > > go
> >
> > This will create a 1 record subfile and dictionary.  Replace the data
> > portion of the subfile with your data file and access the subfile from
> > within quiz.
> >
> >
> > The opinions expressed are my own.  They are not intended to replace the
> > advice of a physician.  Always consult you family physician before
> > beginning a strenuous program of PowerHouse coding.
> >
> > Ron Olenic
> > Senior Systems Analyst
> >
> > "Stamps, Theron" wrote:
> > >
> > >         Good Day fellow list members,
> > >         I'[m hoping someone can shed some light on a possible QUIZ
> > feature.
> > >         An associate and I are working on a project to create a
> > delineated
> > > file from our Image database.  We currently use a third party product
> > from
> > > GEAC for transient billing, although the file it produces is "raw" it
> > does
> > > contain a list of the qualifying transient invoices we want to bill.
> > >         Does QUIZ have a function that will allow us to use the
> > transient
> > > numbers in the *raw* file for control numbers to qualify the extraction?
> > > Something like the *for $FILE in [FILENAME]* Unix function to create a
> > > looping program the refers back to the control file for each account
> > number
> > > to extract.
> > >         Thanks in advance.
> > >
> > > Theron J. Stamps
> > > Systems Analyst
> > > San Angelo Standard-Times
> > > Voice:  915.659.8220
> > > Pager:  1.800.788.0207
> > > Text Pages:  www.skytel.com
> > > Email:  stampstj@texaswest.com
> > > Emergency Email:  theron@beepwear.net
> > > (This will cause a pager notification to be sent)
> > >
> > > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > = =
> > > Subscribe: "subscribe powerh-l" in message body to
> > majordomo@lists.swau.edu
> > > Unsubscribe: "unsubscribe powerh-l" in message to
> > majordomo@lists.swau.edu
> > > This list is closed, thus to post to the list, you must be a subscriber.
> > << File: Card for Ronald W. Olenic >>
--------------CCF793A70C78A1FDB04F3AD5
Content-Type: text/x-vcard; charset=us-ascii;
 name="olenicr.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ronald W. Olenic
Content-Disposition: attachment;
 filename="olenicr.vcf"

begin:vcard 
n:Olenic;Ronald
x-mozilla-html:TRUE
org:Compuware
adr:;;;;;;
version:2.1
email;internet:ronolenic@bigfoot.com
title:Senior Systems Analyst
note;quoted-printable:The opinions expressed are my own, and as such are subject to change or  even complete reversal without notice=0D=0A
fn:Ronald Olenic
end:vcard

--------------CCF793A70C78A1FDB04F3AD5--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.