All,
After seeing LIST.INDEX hashedfile, i have lot of question in my mind.
a) what are all the types of indexes supported by datastage? clustered or nonclustered. if both of them are supported, will it work as is in datastage too?
b) i am creating a external path hashed file. which index will be created by default? is there any option to add some more indexes ( say for example, create unique nonclustered index id1 on <tablename> ) once I created the hashed files?
c) how many indexes can be created for a hash file?
c) will LIST.REINDEX work like REORG command (db command) ?
Inputs are welcome!
LIST.INDEX hashedfile
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
LIST.INDEX hashedfile
Karthik
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: