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

Some will challenge this assertion but I think the size of a table is
a *practical,
operational constraint* and not an attribute of said table. And
because different OS's have different ways of allocating space, each OS's
implementation of SQL would be cluttered up with extensions for table size,
extent size, space allocation, and so on. I understand why it's not part
of the standard (or any extension that I'm aware of).

The answer is in your script:
Create Table XX;
CL: CHGPF FILE(XX) SIZE(50000 1000 3)

On Thu, Jan 28, 2021 at 4:01 PM Timothy Feldmeier <
Timothy.Feldmeier@xxxxxxxx> wrote:

We do not want to create a table with 2 steps.

1. Create Table

2. CHGPF FILE(XX) SIZE(50000 1000 3)



The Create Table command should have a way to set the initial size.





The information transmitted is intended only for the person or entity to
which it is addressed and may contain proprietary, business-confidential
and/or privileged material. If you are not the intended recipient of this
message you are hereby notified that any use, review, retransmission,
dissemination, distribution, reproduction or any action taken in reliance
upon this message is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
--
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