Football (was:Calling quick screen using shortcuts)

[Murray Scholz]

Nice one Bob,
though for most Aussies, it's probably more like....

IF source EQ 'Melbourne, Australia!'
THEN t_Football = 'Aussie Rules'
ELSE
BEGIN
     IF attended_private_school = 'True'
     THEN t_Football = 'Rugby (Union)'
     ELSE
     BEGIN
          IF parent_of_schoolage_child = 'True'
          THEN t_Football = 'Soccer'
          ELSE t_Football = 'Rugby League'
     END
END

To Graeme's query regarding indexed subfiles (>1 index) , we have not
experienced
any problems with them, (We're in a VMS environment, so the usual caveat
applies
about the slowness of creating records in them, as they are just RMS
indexed files
and Powerhouse is just creating records using RMS PUT's).
Fine for smallish numbers of records, but to be avoided for big
numbers.  In these
cases, we create a regular permanent (seqential file) subfile (this is
real speedy),
and then out at DCL use $convert/fdl=xxxx.fdl seqsubfile.sf
indsubfile.sf and copy across a permanent(saved) copy of the
indsubfile.sfd.... and lo and behold you've got yourself
an indexed subfile.

Murray Scholz
Agricultural Business Research Institute
University of New England
Armidale NSW 2351 Australia


"Edis, Bob" wrote:
> 
> IF source EQ 'Melbourne, Australia!'
> THEN t_Football = 'Aussie Rules'
> ELSE t_Football = 'Rugby League'
> 

> -----Original Message-----
> From: Lemin, Graeme [mailto:Graeme.Lemin@team.telstra.com]
> Sent: Thursday, August 01, 2002 5:29 PM
> To: Witkopp, Richard; PowerHouse List (E-mail)
> Subject: RE: Calling quick screen using shortcuts
> 
> Bzzt, wrong.  The REAL football season is about to draw to a close.  Just
> another 4 rounds to go, and then the finals start.
> 
> Hmm, I need to stick something Powerhouse in here, so I'm not off topic.
> Has anybody had experience with writing multiple indexes to a subfile?  Any
> gotchas I need to watch out for?
> 
> Thanks
> 
> Graeme Lemin
> Melbourne, Australia!
>