×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
1+
Definitely the way to go.
See also:
https://www.rpgpgm.com/2019/08/executing-cl-commands-using-runsqlstm.html
Thomas.
-----Ursprüngliche Nachricht-----
Von: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> Im Auftrag von Brian Parkins
Gesendet: Donnerstag, 28. Januar 2021 21:36
An: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Betreff: Re: How do you change the initial size when creating DDL Tables
Within the RUNSQLSTM script you can still issue CL commands. Would this work for you?
CREATE OR REPLACE TABLE
QTEMP/TABLE1 (COLUMN1 INTEGER NOT NULL, COLUMN2 CHAR(100));
CL: CHGPF FILE(QTEMP/TABLE1) SIZE(100 1 1)
(The ability to issue CL commands is supported by RUNSQLSTM, STRSQL and ACS Run SQL Scripts.)
Brian.
On 28/01/2021 14:52, Timothy Feldmeier wrote:
I use Turnover for work management. When I create a DDL Table through Turnover, the command is RUNSQLSTM.
Does anyone know how to set the initial size and increment within the CREATE TABLE source file?
Thank You
Tim Felmeier
--
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
midrange.com
