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?

-----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)