Manual Create index in Universe Stage

cheerfu1 · Post by **cheerfu1** » Tue Jun 17, 2003 3:58 am

Hi,
may i know how to manually create an index in Universe Table ?[:(]

Appreciate your kind attention[:D]

WoMaWil · Post by **WoMaWil** » Tue Jun 17, 2003 4:56 am

Hi cheery,

Universe Table and Hash-File is the same. All key field are automaticly indexed. Read the Manual concerning Hash-files and Universe, there are many more things to keep in mind about them.

Wolfgang Huerter
=====================
Cologne, Germany

ray.wurlod · Post by **ray.wurlod** » Tue Jun 17, 2003 6:15 pm

How you create a secondary index on a hashed file/UV table depends on how it was created.

(1) If it was created with a CREATE TABLE statement (SQL), then you use the SQL statement CREATE INDEX, which has a conventional SQL syntax.

(2) If it was created with a CREATE.FILE statement (that is, in an account), then you use the CREATE.INDEX commmand (note the period).
CREATE.INDEX hashedfilename columnname
This can only create a single-column index.

(3) If it was created with a mkdbfile command (that is, in a directory), then you need to create a VOC pointer to the hashed file using the SETFILE command (search for this in the archives) then proceed as in (2) above.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

cheerfu1 · Post by **cheerfu1** » Tue Jun 17, 2003 8:19 pm

Thanks Ray and ranjan! I have never taken any of the courses... therefore a bit stuck [xx(]

ray.wurlod · Post by **ray.wurlod** » Wed Jun 18, 2003 12:18 am

Creating secondary indices on hashed files isn't in any of the Ascential courses. You can learn about it on IBM's UniVerse classes.
There is no real guarantee that things will stay the same forever.