RE: Re-Compilation problem (RPG III)

["Njål Fisketjøn" <n.f@xxxxxxx>]

> Every time there is a change in the DDS of any of the Physical
> files that are
> being used in my RPG programs, I have to re-compile my programs.
> Is there a
> better solution to this?
>
>
>
> All responses will be appreciated.


I try to create service programs related to each ("basic data") PF. Then the
impact of a database change is minimal. There's of course an overhead in
doing so, but it depends on the size of your files. You gain in terms of ease
of maintenance.

Example *srvpgm: Cust
Procedures:
 CustIsValid
 CustGetName
 CustGetList
 a.s.o.

In "my" applications i found that 80+% of all DB use is a simple setll/chain
to check if a key is valid and an additional 5+% is retrieving the name/text
of a given key. Replacing the file def., key def., and code required for this
eases the database change process considerably.