RE: IS there a way to compile a DDL Create Table script with Runsqlstm. But, let the script determine what library to put the Table in?

If you specify the database objects (Table, Views etc.) to be generated
without library.
Then you can pass the default/object library in the RUNSQLSTM Command with
the Option Default Collection (DFTDBCOL).
The object will be generated within this Default Schema.

RUNSQLSTM SRCFILE(SRCLIB/SRCFILE)
SRCMBR(SRCMBR)
COMMIT(*NONE)
MARGINS(*SRCFILE)
DFTRDBCOL(YOURLIBRARY)


Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i

IBM Champion since 2020

"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)
"Learning is experience ? everything else is only information!" (Albert
Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Michael Quigley
Sent: Thursday, 15 June 2023 23:05
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: RE: IS there a way to compile a DDL Create Table script with
Runsqlstm. But, let the script determine what library to put the Table in?

If you execute a CHGCURLIB before the RUNSQLSTM, the current library
(*CURLIB) will act like the default library/collection--but the rest of your
library list can still be used for unqualified tables/views/etc.

Michael Quigley
Computer Services
The Way international
www.TheWay.org

-----Original Message-----
message: 5
date: Wed, 31 May 2023 18:23:57 +0200
from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: RE: IS there a way to compile a DDL Create Table script with
Runsqlstm. But, let the script determine what library to put the

Table

in?

Do not qualify the Object in your SQL Script and set the Default
Collection
- DFTRDBCOL Option in the RUNSQLSTM command to your schema

RUNSQLSTM SRCFILE(YOURSRCLIB/YOURSRCFIL)
SRCMBR(YOURSRCMBR)
COMMIT(*NONE)
DFTRDBCOL(YOURTBLLIB)

Note: Once you have set the Default Collection (DFTRDBCOL) the library
list is no longer searched ... and you have to qualify all objects
(Tables, Views
...) that are not located within your default collection.

Mit freundlichen Gr??en / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i

IBM Champion since 2020

"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) "Learning is experience ?
everything else is only information!" (Albert
Einstein)

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.