Re: Indexing file

["Molyneux, Tom" <TMolyneux@xxxxxxxxxxxxxx>]

Would a Logical File allow you to do what you need to do? 

We are on V6.04. I know BPCS uses SQL extensively but I've never created an 
index, as such, but we have a couple of logical files over GLH that effectively 
sort the file.

Apologies if I'm telling you things you already know.

The following code would create a logical file keyed by LHDREF. 

A**********************************************************
A*   File          -   GLHTESTLF1                          
A*   System        -   BPCS Additions                      
A*   Application   -   General Ledger                      
A*   Description   -   Journal History.                    
A*                     By : LHDREF                         
A**********************************************************
A*                                                         
A          R IPG100LH                  PFILE(GLH)          
A*                                                         
A          K LHDREF                                         
A*
A**********************************************************

Create a source member of type LF with the above code. Then create the actual 
logical file using the command :

CRTLF   FILE(bpcslib/GLHTESTLF1) SRCFILE(sourcelib/sourcefile) 
SRCMBR(GLHTESTLF1)

I don't know V6.002, so I'm assuming the record format in GLH was still 
IPG100LH at that version. If not, you need to change that line in the LF source.

Tom Molyneux

National Oilwell Varco
Mono Pumps Limited
MIS Department

Tel.     0161 214 2142
Fax.     0161 214 2344
E:mail   Tom.Molyneux@xxxxxxx
         tmolyneux@xxxxxxxxxxxxxx

-----Original Message-----
From: bpcs-l-bounces+tmolyneux=mono-pumps.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+tmolyneux=mono-pumps.com@xxxxxxxxxxxx] On Behalf Of 
Kusman Lim
Sent: 22 February 2007 09:27
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Indexing file

Sorry, This iSeries does not have SQL.

Thank 


Kusman LIM

-----Original Message-----
From: bpcs-l-bounces+kusman=takeda.co.id@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+kusman=takeda.co.id@xxxxxxxxxxxx] On Behalf Of Davide 
Roveda
Sent: Thursday, February 22, 2007 4:15 PM
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Indexing file

Hello

Directly with SQL, of by src member this is an example on IIM, apply as your 
GLH or any else need:

CREATE INDEX IIMA99 ON IIM (IID,IPROD)    

Thanks
-----Original Message-----
From: bpcs-l-bounces+davide.roveda=infor.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+davide.roveda=infor.com@xxxxxxxxxxxx] On Behalf Of Clare 
Holtham
Sent: giovedì 22 febbraio 2007 10.06
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Indexing file

or just STRSQL, then CREATE INDEX, specify GLH, and on the next screen select 
LHDREF. Encoded Vector indexes are not usually needed.

cheers,

Clare

----- Original Message -----
From: "Kusman Lim" <kusman@xxxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Thursday, February 22, 2007 3:38 AM
Subject: [BPCS-L] Indexing file


> 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: Clare.Holtham@xxxxxxxxxxxxxx

--
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: davide.roveda@xxxxxxxxx

--
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: kusman@xxxxxxxxxxxx



--
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: tmolyneux@xxxxxxxxxxxxxx