I was referring specifically to the "CREATE INDEX" suggestion. I don't think that would be a drop-in replacement, like replacing the flat file with an corresponding DDS/DDL PF would be.
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Friday, March 02, 2018 8:39 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: DDS question
Well, since the existing RPG specs all use program defined files I am assuming that he already plans on addressing that.
Apparently the customer is a S/36 environment customer dragged kicking and screaming due to GDPR requirements.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/02/2018 08:50 AM
Subject: RE: DDS question
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
How well will existing RPG file specs handle that?
-----Original Message-----
From: Steve Needles [mailto:Stephen.Needles@xxxxxxxxxxx]
Sent: Thursday, March 01, 2018 4:04 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: DDS question
You can use a concept called "derived index" to address this.
CREATE INDEX &LIB/fileI01
ON file
(substr(company,1,15));
Steve Needles
midrange.com
