Announcement

**UserName10** · May 10, 2023, 09:30 AM

You can substring a numeric field if it is defined as zoned.

**Peder Udesen** · May 11, 2023, 01:37 AM

Take a look at this regarding the conversion from packed to decimal.

Data type for physical and logical files (position 35)

https://www.ibm.com/docs/en/i/7.4?topic=44-data-type-physical-logical-files-position-35

For a physical file, you use this position to specify the data type of the field within the database. You specify data type in a logical file only to override or change the data type of the corresponding field in the physical file on which this logical file is based.

As I see it if the field NCPONUMT is defined as packed in the physical file then you
could define it in the logical file with data type "S" for zoned and conversion happens automagically.
Then it can be used in the SST keyword

Announcement

Logical file SST in a numeric field

Logical file SST in a numeric field

Comment

Comment