Hi,

can we index multiple column with below index on a hold file

ON TABLE HOLD AS HOLDFILE_123 FORMAT FOCUS INDEX COLUMN_1 COLUMN_2 COLUMN_3 COLUMN_4

I am not able to find it in documentation which I have.

Thank You
Sakeesh

This message has been edited. Last edited by: Kerry,

Yes, multiple fields/columns can be indexed when holding output as a FOCUS file. I believe the limit is four index fields. There may also be a name length limit of 12 characters for indexed field names. The syntax of your sample statement is correct.

MKS, I don't know what the purpose of those indices is but just in case you are doing it so you can later JOIN to that FOCUS file, you can only do so using *one* field.

Multiple index fields is news to me. If you need multiple index fields your best options are:

1. Create the table in a format other than FOCUS (write to an SQL*Server table, DB2, etc.)

2. Concatenate your several fields into a single text field via a DEFINE, and then index on that combined field. Field name 12 characters or less.

J.