RE: DataArea vs. Tables

["Jerry C. Adams" <midrange@xxxxxxxx>]

At another location I used a data area to retain what I called environment
options.  I could add new options and just modify the /copy book that
defined the data area.  I had a control program that I used to set/change
the options.  I think I had 10-15 options defined by the time I left; some
alphameric, some numeric.  Much easier, I thought, than hard-coding in the
programs or putting them into a PF.

Used a couple more for passing information from one program to the next
program.  I, also, used the LDA for our legacy RPG II (36E) processing.

Jerry C. Adams
IBM i Programmer/Analyst
He has all the virtues I dislike and none of the vices I admire. -Winston
Churchill on Sir Richard Stafford
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Friday, May 13, 2011 11:08 AM
To: 'Midrange Systems Technical Discussion'
Subject: AW: DataArea vs. Tables

> > "store next available numbers(Faster)."

Instead of using an data area, I use an SQL sequence object (which is
nothing else than a data area).

In an sequence object a couple (depending on the cache you defined) of next
numbers are in the pipeline and you do not have to determine the next number
by yourself.
The next number is retrieved simply by requesting the next one:

Exec SQL Set :MyNxtNo = Next Value for :MySequence;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Mike Wills
Gesendet: Friday, 13. May 2011 17:56
An: Midrange Systems Technical Discussion
Betreff: Re: DataArea vs. Tables

I like that idea.

"store next available numbers(Faster)."
--
Mike Wills
http://mikewills.me