Re: Indexing file

[Al Mac <macwheel99@xxxxxxxxxxx>]

Does it have DDS?

> 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: macwheel99@xxxxxxxxxxx