What you can do is to surround the CREATE TABLE Statement with a dynamic
compound statement (BEGIN END).
Within the compound statement you execut the CREATE TABLE Statement and if
an error occurs, handle it with a exit handler (and leave the compound
statement)
Something like this
Begin
Declare Exit Handler for SQLEXCEPTION
Begin End;
Create Table ...;
End;
Instead of handling any SQL error you may also check the SQLSTATE that
occurs if the table does already exist.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
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 Justin
Taylor
Sent: Thursday, 3 April 2025 17:14
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Create table only if does not exist?
I have a SQL script (running in ACS RSS) with a CREATE TABLE:
create table MyLib.MyTable as (
-- select statement here
) with data;
If the table already exists, I want the script to skip that statement and
just go on. Any suggestions?
Thanks
--
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.
midrange.com
