Sender JDBC query forming

[Former Member]

I have two sender JDBC interfaces. I am not able to form a query

Both are SQL to ECCinterfaces. We are fetching data from database views not table nd hence we are not able to omport structure to PO as external definition. Databese virews cannot be imported as external definition

Firts interface

I have three fields

Name (varchar(50),not null)

PhoneNumber (varchar(50),not null)

Active (bit,null)

Bit means it's like a flag field which should be checked to avoid duplicaton of data?

I used this query and it is not working select * from view_xyz

table_xyz is the view

the next interface has three fields and additionally a filed datemodified (datetime, not null)

I take it that we need to take data based on that field

So what querry should be used?

[Bhargavakrishna]

Hi Madhav,

Alternatively you can directly create DT / MT in SAP PO.

Did you try to execute the same query directly in the database?

Please check the communication channel logs and provide more info about the error.

Did you deployed the compatible  JDBC drivers in SAP PI?

Go through the below link for your reference.

SQL CREATE VIEW, CREATE OR REPLACE VIEW, DROP VIEW Statements

Regards

Bhargava Krishna