db2 - tablespace clause in DDL

Darshak

unread,

May 4, 2023, 1:39:27 AM5/4/23

to SQL Workbench/J - DBMS independent SQL tool

Hi,

SQL Workbench/J Build 129
Java version=11.0.15.1

Database = DB2

db explorer -> objects -> [ table name ] -> "SQL Source" in right panel

"SQL Source" does not have tablespace clause for table in generated DDL.

While in Oracle, it shows tablespace clause .

Will be possible to have tablespace clause for tables in generated DDL in case of Db2 ?

Thanks,

Darshak

Thomas Kellerer

unread,

May 4, 2023, 3:40:11 AM5/4/23

to sql-wo...@googlegroups.com

Which DB2 "type" are you using? LUW, iSeries or ZOS?

Darshak schrieb am 04.05.2023 um 07:39:
> Hi,
>
> SQL Workbench/J Build 129
> Java version=11.0.15.1
> Database = DB2
>

> *db explorer -> objects -> [ table name ] -> "SQL Source" in right panel *
>
> "SQL Source" does not have /tablespace clause /for table in generated DDL.
> While in Oracle, it shows /tablespace clause ./
> /
> /
> Will be possible to have /tablespace clause /for tables in generated DDL in case of Db2 ?
>
> Thanks,
> Darshak

Darshak

unread,

May 4, 2023, 4:03:53 AM5/4/23

to SQL Workbench/J - DBMS independent SQL tool

It's DB2 LUW .

Reply all

Reply to author

Forward