Creating a table on the fly?

[Chiragz]

Is it possible to create a table with few columns on the fly, say on a
remote DB2 database using TDI?

[alchemisx yep]

On Jan 23, 11:56 am, Chiragz <chira...@gmail.com> wrote:
> Is it possible to create a table with few columns on the fly, say on a
> remote DB2 database using TDI?

You always have the ability to execute arbitrary SQL commands via
execSQL().

Ex: thisConnector.connector.execSQL("CREATE TABLE
<TABLE_NAME> ...")

If you have attribute variables to drop into the table you can call
them within the execSQL command.

Ex: thisConnector.connector.execSQL("CREATE TABLE " +
work.getString("someAttribute") + " ... ");

Then drop this into the connector hook that seems appropriate.

Hope this helps,

-rsxdc5

[Eddie Hartman]

Note also that the Database Connector will auto-create the table if
you have the connection option selected: Auto-create table. Although
you will have less control than if you issue your own DDL as rsxdc5
suggests.

-Eddie

[Chiragz]

Thanks, this was pretty useful!

[Chris]

> Thanks, this was pretty useful!- Hide quoted text -
>
> - Show quoted text -

And, check one post or so up. If you're just looking for a place to
park some data for awhile, the built-in Derby database works really
well too.