RE: How do you change the initial size when creating DDL Tables

Defining the size on a table is a DevOps control: unless somebody has
misbehaved with the system reply list, a program gone out of control would
fill a small table and then throw a QSYSOPR message which hopefully IT
operations would recognize as an abnormal situation.

IBM has provided a lot of product-specific shortcuts (example: CRTPF creates
a table, specifies the size, can allocate the space and control space reuse,
allows memory residency, etc.) in the midrange family and its developers,
taking advantage of those shortcuts, have been exceptionally productive.
When you adopt industry-standard technologies like SQL, you have to accept
some tradeoffs.

-reeve

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon
Hamberg
Sent: Saturday, January 30, 2021 7:05 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How do you change the initial size when creating DDL Tables

Just verified this is the case about *NOMAX. However, you _can_ change it
after it is created, from *NOMAX to a fixed size limit with CHGPF.

Vern

On 1/30/2021 8:33 AM, DFreinkel wrote:

Subject to correction but when you create tables, you cannot set the size

of a table.

It is always the equivalent of *nOMAX

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com