Re: Indexing file

Husman,

Create a SQL Source - GLH____E01 (We add the "E" for an Encoded Vectore
Index because you use only 1 field),

Create Encoded Vector Index LIB/GLH____E01
   on LIB/GLH
      (LHDREF)

Create the index then as follows:
RUNSQLSTM SRCFILE(SRCLIB/QSRCFILE) SRCMBR(GLH____E01)

Hope this helps,


Kobie Jooste
Clover Information Services
Tel: +2711 758 5387 / Mobile: +2783 798 3155 / Fax: +2711 758 5301
E-mail: kobie.jooste@xxxxxxxxxxxx
Web: www.clover.co.za





                                                                           
             "Kusman Lim"                                                  
             <kusman@xxxxxxxxx                                             
             .id>                                                       To 
             Sent by:                  "SSA's BPCS ERP System"             
             bpcs-l-bounces+ko         <bpcs-l@xxxxxxxxxxxx>               
             bie.jooste=clover                                          cc 
             .co.za@xxxxxxxxxx                                             
             om                                                    Subject 
                                       [BPCS-L] Indexing file              
                                                                           
             2007/02/22 05:38                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              SSA's BPCS ERP                                               
                  System                                                   
             <bpcs-l@midrange.                                             
                   com>                                                    
                                                                           
                                                                           




Dear Alls

How to create index file GLH for field LHDREF on BPCS Database ? We use
iSeries, BPCS ver 6.002plf.


Thanks
Kusman LIM

--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: kobie.jooste@xxxxxxxxxxxx