Date:         Sat, 13 Jan 2001 10:28:35 -0500
Reply-To:     Richard DeVenezia <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard DeVenezia <radevenz@IX.NETCOM.COM>
Organization: MindSpring Enterprises
Subject:      Re: Retrieving Index information by SCL

Walter:

Current index names, associated columns and properties such as uniqueness
and nullness can be obtained from SASHELP.VINDEX.

--
Richard DeVenezia - SAS Macros and AF Tools
http://www.devenezia.com

"Walter Smetsers" <Walter.Smetsers@eomdata.nl> wrote in message
news:NEBBLKCNIBMKGHNLLHOBCEPOCGAA.Walter.Smetsers@eomdata.nl...
> Hi y'all,
>
> I have a question about retrieving information about
> indexes within SCL.
>
> Problem:
> * I have a dataset with password-protection (PW=...).
> * I want to register all the indexes which are available
>   for the dataset.
> * I don't have the ability to use SUBMIT blocks.
>
> Solution uptill now:
> * I can retrieve information about a single/composite index
>   by using IVARLIST. The missing part with this solution is
>   that IVARLIST needs a indexname => I don't know which
>   indexes are used on the dataset, so no information possible.
>
> Any help on this matter would be appriciated.
>
> T.I.A.
>
> Walter Smetsers
> E.O.M Data - Hilversum
> The Netherlands