Linking to a subfile (was Subphyla question)

[Ohmes, Matt]

Welcome Merol, :-)

You are correct of course. It is Record 0 on the Unix.  I was relying on my
memory (a very doubtful exercise at this stage of my life).  I rarely work
on Unix so the memories aren't grooved as deeply on the stone tablets of my
brain. ;-)
Matt

Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX  75039
214-259-6200
"Matt doesn't really know anything.  He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated.  Don't lend him
money and don't let him talk to your sister!" ;-)

-----Original Message-----
From: Merol Newman [mailto:meroln@specialist.co.uk]
Sent: Thursday, March 02, 2000 4:48 AM
To: matt.ohmes@Cognos.COM
Cc: powerh-l@lists.swau.edu
Subject: RE: Linking to a subfile (was Subphyla question)


Hello Matt

I only joined yesterday, and I don't think I'll have time to read anything
most
days, let alone reply! And little did I think I would have anything useful
to
say - I joined to pick other people's brains. But somewhere in the flood of
messages I think one programmer said his report took 45 minutes to link to
record 1 of the subfile on Unix. Could it be because Unix can't find record
1,
and so doesn't use the buffer as described?

It should be:-      record 1 on Vax VMS
                    record 0 on HP MPE (HP3000, HP/XL)
                    record 0 on Unix

I've been using this method for years, including at various times all three
platforms, and never found any performance problems.
 
Merol Newman
E-mail: meroln@specialist.co.uk <mailto:meroln@specialist.co.uk>

I've just found the relevant bit:-

 G'day Matt
>
> I have to challenge you on what you said about "Quiz will read the
> subfile
> record once".  I 'fixed' a report for a client last year on a
> HP/UX box
> where a report was taking 45 minutes to run.  This report was
> reading a
> table and linking to record 1 of a subfile.  It read the subfile for
> each
> occrrence on the primary file.
>
> I replaced the logic using an environment variable and a CHOOSE on the
> primary file instead.  This reduced the run time to only 5 minutes.
>
> Blue


> >
> > Actually you can link to the subfile from your data file. Try this:
> >
> > ACCESS datafile LINK TO RECORD 1 OF *subfile
> >
> > SELECT IF dateitem of subfile = dateitem of datafile
> >
> > Quiz will read the subfile record once and keep it in memory
> > through the
> > entire run, so it should be quite effecient.
> >
> > You didn't say what machine you are on, but the above works
> > for VAX and
> > UNIX
> > (I believe). If you are on an HP3000, substitute a zero for the "1" in
> > the
> > ACCESS statement.
> >
> > Matt
> >


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.