Logical file inquiry

[dcutaia]

Hi,

When I am creating a new logical file is there a way I can separate a field into two separate fields. For example if I have a 11 character field in my physical file named custix and I want to create two new fields in the logical based on the first 8 characters and the last 3 characters is that doable?

Thanks,

DAC

[tomholden]

Re: Logical file inquiry

yes but why? IIRC building this using DDS (and possibly DDL) the LF can only be used for input only (but my memory is failing me these days). it's trivial to split the data in your program with a simple DS

[Scott M]

Re: Logical file inquiry

Yes, use the SST keyword (substring).

From the DDS manual
The format of the keyword is:
SST(field-name starting-position [length])


You could also use an SQL view or just as part of the Select statement.

[jamief]

Re: Logical file inquiry

SQL is the way to go here

A
A          R BATCHR1                   PFILE(BATCH)
A            ZBACTV
A            ZBGDAT
A            ZBJDYS
A            ZBWKNM
A            ZBWKEN
A            ZBFIL1
A            ZBYEAR             I      SST(ZBGDAT 5 2)
A          K ZBYEAR
A          K ZBJDYS 

[kitvb1]

Re: Logical file inquiry

No, it's not restricted to input only.