Can somebody please show me an example of how to activate an external Index.
I was able to create a few external indexes using the tech doc. But I can't get it to activate by simply following the syntax on the tech doc. Here are the particulars:

Physical WebFocus database: TEST.CUST.HVP.HVPCOST.FOCUS
Master Name : HVPCOST
Index database names:
/u/iadminp/ibi/srv71/wfm/edatemp/contract.idx
/u/iadminp/ibi/srv71/wfm/edatemp/orig_zip.idx
/u/iadminp/ibi/srv71/wfm/edatemp/dest_zip.idx
/u/iadminp/ibi/srv71/wfm/edatemp/hauler_i.idx
/u/iadminp/ibi/srv71/wfm/edatemp/sizip_id.idx
/u/iadminp/ibi/srv71/wfm/edatemp/proc_yyp.idx

I tried the ff statement and it failed:
USE
TEST.CUST.HVP.HVPCOST.FOCUS AS HVPCOST
contract.idx WITH HVPCOST
orig_zip.idx WITH HVPCOST
dest_zip.idx WITH HVPCOST
hauler_i.idx WITH HVPCOST
sizip_id.idx WITH HVPCOST
proc_yyp.idx WITH HVPCOST
END
-RUN
0 ERROR AT OR NEAR LINE 24 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: TEST.CUST.HVP.HVPCOST.FOCUS
0 ERROR AT OR NEAR LINE 25 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: contract.idx
0 ERROR AT OR NEAR LINE 26 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: orig_zip.idx
0 ERROR AT OR NEAR LINE 27 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: dest_zip.idx
0 ERROR AT OR NEAR LINE 28 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: hauler_i.idx
0 ERROR AT OR NEAR LINE 29 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: sizip_id.idx
0 ERROR AT OR NEAR LINE 30 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED: proc_yyp.idx
-EXIT

Hi Ronn,

Has this issue been resolved on your side?

If not, the best channel for assistance would be Information Builders' Customer Support Services. To open a case, you may either call at 1-800-736-6130, or access online at InfoResponse at any time.

Hope this helps.

Cheers,
Kerry

quote:

TEST.CUST.HVP.HVPCOST.FOCUS

Are you sure of your file name and that it has data in it. I would think the last extent would be .FOC rather than .FOCUS

quote:

TEST.CUST.HVP.HVPCOST.FOCUS

Seems to me you're mixing mainframe (or native AS400) terminology with unix.
Since you run a unix flavor of the server, should it not all be in unix terminology?

On z/OS, the USE statement should have the DDNAME instead of the filename. Did you try that?

Good luck!