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?
you ca do this it' working fine.
you can also create insert our update query dynamically to create/update your table first.