Logical file on a substring of a field ?

[Steen Lund-Pedersen]

Hej

Is it possible in DB/400 to create a LF on a part of a defined field..?
(and if yes - how should the DDS-description be.)

I'm running OS/400 V3R1 today - but will in 14 days upgrade to V3R7.

My problem is short that I've got articleno. where each digit (or group
of) have a certain meaning. ex:
the physical no. 'xxxx' 'xxxxxxxxxxxx'
my logical parts would be: 'xx xx' 'xxx xx xx xx xx x'

therefore every time a program (or query) shall process my statistic, or
article master, the AS/400 is building a temp. index....!! which gives
the hole compagny poor performance... :-(

By the way - how does the AS/400 decide wenn to buils a temp index, and
wenn to read seq. ??

[Helmut Salzer]

Hi,
you can do what you want with the SST keyword.

Example:
When your original fieldname is ARTNO and you want a key from byte 2 to 5
then make your dds as follows:

A NEWFLD I SST(ARTNO 2 4)
A K NEWFLD

The "I" in the first line means INPUT ONLY!
Don't forget to include all fieldnames from your physical file in this lf
!!!

--
Helmut Salzer
salz...@ping.at
http://members.ping.at/salzer.h/as400.htm

Steen Lund-Pedersen <slu...@post2.tele.dk> schrieb im Beitrag
<32CEA8...@post2.tele.dk>...