Skip to Content
0
Former Member
Oct 28, 2010 at 10:34 PM

issue with Insert using JDBC adapter

33 Views

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.

Thanks,

Kiran.