Can we use Views JDBC Sender adapter

[pankaj_yadav3]

Hello Expert

I am creation the JDBC to SOAP scenario . My DBA provided me the views name instead of SQL statement . i have few question .

Q1. Can we use Views instead of Sql statement ?

Q2. what is source structure ?

Q3: Please share some link for this process.

Thanks & Regards

Pankaj Singh

[former_member190293]

Hi Pankaj!

A1. Since the View object in database actualy is a pre-defined SQL statement (with additional parameters or without) it's no difference between selecting from DB table or View object. When you select from View, SQL statement defined for that View is performed first and than you perform select from result table.

For example: We have a View object named "Customers_View" in DB defined as:

SELECT TOP (100) PERCENT CustomerID AS CustID FROM dbo.Customers ORDER BY CustID

To query this View in sender JDBC adapter we use SQL statement:

SELECT CustID FROM Customers_View

A2. Your DBA should provide the View result table structure definition.

One thing: while querying the View, you should provide the way for updating source table(s) after receiving data in order to avoid repeatable reading of the same data from View object.

Regards, Evgeniy.

[pankaj_yadav3]

Thanks Evgeniy Kolmakov for quick response and helpfull answer.