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
Thanks,
Ronnel C
WebFocus 7.1.5
IBM ZOS 1.6