Four Stars

programatically changing schema and properties of components`

Can I, using tJava, change the schema or other properties of tJDBCRow? 

I read a table from tJDBCInput with dynamic column (since I only know the query and connection sting at run time). I need to either insert this data in another table (using some output component) or run a procedure/generic query using the returned fields (which in this case will return only one row).

Since the Row components (and also tJDBCOutput) cant use the dynamic column I need to read it using tJava and the fix the other components some how.

Any solution for this?

Thanks

3 REPLIES
Ten Stars

Re: programatically changing schema and properties of components`

you ca do this it' working fine.

you can also create insert our update query dynamically to create/update your table first.

regards,

Francois

Francois Denis

Don't forget to tag when it's "solved"!

Four Stars

Re: programatically changing schema and properties of components`

Thanks for the answer.

Do you happen to have any sample code?

Thanks!

Ten Stars

Re: programatically changing schema and properties of components`

I'm sorry I cannot send you samples but it's working I already done it two time.

 

Francois Denis

Don't forget to tag when it's "solved"!