DSXchange

Great ! it works ! I put tablespace="<tblspace>" in the db option... it works. Thanks stefanfrost1 ! In the DB-enterprise stage using for example MODE = Write Create, you get a option called DB Options within which you can specify tabelspace amongst other (however missing a whole lot of op...

Too bad...
Thanks Ray...
btw... anyway to change the default tablespace DS is using ?

I understand I could create the table by using DDL to specify the tablespaces.
But just wondering whether DataStage can specify tablespaces also. (it makes the process simpler

I also assume there's some kind of custom option available in DataStage . But I couldn't find anyway to specify the tablespaces when create DB2 tables through using DB2 Enterprise Stage. Anyone knows how to specify that ? Thanks. Well... that *is* what the 'default tablespaces' are for, to be used b...

I am using DB2 Enterprise stage to create tables in the DB2 9.1 partitioning db. It seems it use the default tablespaces by default and no other option.

Is there any way to specify the tablespaces use when creating tables by DB2 Enterprise stage ?

Thanks in advance.