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

[Reeve <rfritchman@xxxxxxxxx>]

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