Page 1 of 1
Manual Create index in Universe Stage
Posted: Tue Jun 17, 2003 3:58 am
by cheerfu1
Hi,
may i know how to manually create an index in Universe Table ?[:(]
Appreciate your kind attention[:D]
Posted: Tue Jun 17, 2003 4:56 am
by WoMaWil
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
Posted: Tue Jun 17, 2003 6:15 pm
by ray.wurlod
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
Posted: Tue Jun 17, 2003 8:19 pm
by cheerfu1
Thanks Ray and ranjan! I have never taken any of the courses... therefore a bit stuck [xx(]
Posted: Wed Jun 18, 2003 12:18 am
by ray.wurlod
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.