programatically changing schema and properties of components`

[Anonymous]

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

[fdenis]

you ca do this it' working fine.

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

regards,

Francois

[Anonymous]

Thanks for the answer.

Do you happen to have any sample code?

Thanks!

[fdenis]

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