GET-statement with or without VIA option.

[Deskin, Bob]

The reason for using VIAINDEX generally is where the index cannot be
determined based on the VIA option and which index is used makes a
difference. The often comes up where you have partial indexes defined in the
dictionary or where, as Chris says, you have the same segments but defined
as ascending or descending.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: Chris Sharman [mailto:chris.sharman@ccagroup.co.uk]
Sent: Wednesday, February 13, 2002 10:14 AM
To: ressingm@unive.nl
Cc: PowerH List
Subject: RE: GET-statement with or without VIA option.



>the GET-statement I showed is performed from within an internal procedure.
>That procedure is called from within the INITIALIZE-procedure, inside a
>While retrieving on the file GEDD037Z (sequential).

There's a warning in the manual about using get during initialize.
Sometimes you can get away with ignoring these warnings, but other times
they can result in obscure problems, which can be hard to track down.

Merol & Bob made interesting suggestions, although I thought Bob implied
"VIAINDEX x USING a, b" would use a for the first segment & b for the
second, contradicting what Merol said. I don't know which is right: it used
to be taught that VIA was preferable to VIAINDEX (mattered in some
circumstances, not in others). The only time you'd have to use VIAINDEX as
opposed to VIA would be if, say, you had two matching indices, one
ascending, one descending, and needed to specify which to use.

Chris



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.

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

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.