Hi PI Experts,
I have issue using INSERT statement with JDNC Adapter channel.
The Target system has a schema for any SQL Satement.
even when it is select, insert or update it requires to add scema before Table.
for example Select * from xyz.TABLE;
or insert into xyz.TABLE (A, B, C) values (1, 2, 3);
so in both above the cased i need to add xyz.
i can do it while declaring the table as a Data element
but the schema has . (dot) in it like xyz. which PI is throwing error when creating a field with dot in data type.
Can any one has any idea how we can overcome this or how to add a string with dot before the table name.
Please let me know if you are not clear with what i have mentioned.