Re: Create table only if does not exist?

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

Perfect!  The BEGIN/END was the missing link I needed.

Thanks, everybody!



On Thu, Apr 3, 2025 at 10:38 AM Daniel Gross <daniel@xxxxxxxx> wrote:

> Hi Justin,
>
> this might work in your script:
>
> begin
> if not exists (select 1 from systables where table_schema = 'MYLIB' and
> table_name = 'MYTABLE') then
> create table mylib.mytable as (
> ...
> ) with data;
> end if;
> end;
>
> I don't have a session at hand right now - but this should work - maybe
> with some syntax errors corrected.
>
> SQL compound statements (begin ... end;) do work in SQL scripts - in iACS
> and in RUNSQLSTM.
>
> HTH
> Daniel