1 Reply Latest reply on Jan 17, 2016 2:10 PM by rareddy

Creating or Modify Table/View on VDB at runtime

yayan Jan 16, 2016 7:22 AM

Hi all.

Is currently possible in JDV 6.2 to do the following:

1. Creating virtual table/view on VDB at runtime? (e.g. via Web or JDBC, using DDL?)

2. Modify existing virtual table/view structure (add/modify/delete columns) on VDB at runtime? (e.g. via Web or JDBC, using DDL?)

3. Modify existing SQL transformation of virtual table/view on VDB at runtime? (e.g. via Web or JDBC, using DDL?)

I see some hints at the possibilities of those capabilities in the documentation related to Runtime Metadata Update and Dynamic VDB, but still not sure if it match with what I need.

Thanks,

Yayan

1. Re: Creating or Modify Table/View on VDB at runtime

rareddy Jan 17, 2016 2:10 PM (in response to yayan)

1. Creating virtual table/view on VDB at runtime? (e.g. via Web or JDBC, using DDL?)

No, the VDB needs to be redployed

2. Modify existing virtual table/view structure (add/modify/delete columns) on VDB at runtime? (e.g. via Web or JDBC, using DDL?)

No, currently there is no capability to add/remove columns on a runtime VDB

3. Modify existing SQL transformation of virtual table/view on VDB at runtime? (e.g. via Web or JDBC, using DDL?)

Yes, this is possible, as along as you are not modifying the veiw columns

Ramesh..
Actions