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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Several have offered this solution - a very good one. I googled for 
using CL in RUNSQLSTM and found a very helpful hit in an article by 
Simon Hutchinson - he expands on this idea with examples of using both 
SQL's QCMDEXC function and the CL: syntax. He also offers an idea about 
how effectively to have MONMSG behavior if certain commands fail - such 
as CRTDTAARA if the DTAARA already exists.

The link is - 
https://www.rpgpgm.com/2019/08/executing-cl-commands-using-runsqlstm.html

Cheers
Vern

On 1/30/2021 4:07 AM, Birgitta Hauser wrote:
> If you already store the CREATE (OR RELACE) TABLE statement in a source
> physical file member ... why not to include the CHGPF statement (after the
> CREATE TABLE Statement) in this source member?
> May be I do not understand your problem, but when adding the CHGPF to the
> source member, it will be performed if you run the SQL Script via RUNSQLSTM.
>
> 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!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Timothy
> Feldmeier
> Sent: Freitag, 29. Januar 2021 19:12
> To: 'rpg400-l@xxxxxxxxxxxxxxxxxx' <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: Re: . How do you change the initial size when creating DDL
>
> Let me re-explain.  Through Turnover, I am trying to  promote a source file
> that Creates a DDL Table.
> I do not want to go back later, to use command CHGPF to give the Table an
> initial number of records.
> CREATE TABLE within the source file should have a way to set the initial
> number of records.
> ... my staff does not want do this in 2 steps. CRTPF does not require 2
> steps.
>
>
>
> 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