RE: Articles or links to build a case on why to improve your rpg-db2 database.

This solution was implemented a while ago. At the time, SQL was not in used at our company. Accessing those DS defined field trought SQL would not be obvious.

The division for which that was done as been sold. I think they have migrated to SAP since then.


Denis Robitaille
Chef de service TI - Solution d'entreprise
Infrastructure et opérations

CASCADES CENTRE DES TECHNOLOGIES
412 Marie Victorin
Kingsey falls(Québec) Canada J0A 1B0
Tél : 819 363 6100 Poste :52130
Cell : 819 352 9362



-----Message d'origine-----
De : MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Buck Calabro
Envoyé : 1 mars 2017 09:56
À : midrange-l@xxxxxxxxxxxx
Objet : Re: Articles or links to build a case on why to improve your rpg-db2 database.

On 2/28/2017 10:17 AM, Denis Robitaille wrote:

I think that my solution might be applicable to you.
In the file, I added a field at the end (this is the only time I have to recompile all programs). It is a *CHAR file of a big length (let say 500).
I also have define a DS (Data structure) that I can /copy in RPG programs that define the content of this extention field.
So, when I need a new field (whatever the type), I change the DS and that's it.

Is SQL used at all?

--
--buck

Try wiki.midrange.com!

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD