|
Hi Tom,A logical file is a way of doing it, but has performance disadvantages compared to an index these days....
cheers, Clare----- Original Message ----- From: "Molyneux, Tom" <TMolyneux@xxxxxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> Sent: Thursday, February 22, 2007 10:07 AM Subject: Re: [BPCS-L] Indexing file 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.
midrange.com
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 HelloDirectly 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 fileor 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@xxxxxxxxxxxxBefore 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@xxxxxxxxxxxxBefore 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@xxxxxxxxxxxxBefore posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.
Delivered-To: tmolyneux@xxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
