where to write SQL query when we use JDBC adapter

[Former Member]

Hi Gurus,

I have seen many places that when we use JDBC adapter in XI we need to write or use SQL statements like Insert, update, delete etc.

SQL statement for query: SELECT * FROM table WHERE processed = 0;

SQL statement for update: UPDATE table SET processed = 1 WHERE processed = 0;

Thanks,

Vinay.

[Former Member · Accepted solution]

Hi

JDBC Adapter requires a special structure.

Document Formats for the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

The name of the element beneath the statement element specifies the name of the database table and contains the attribute action with the value INSERT, UPDATE, UPDATE_INSERT, DELETE, or SELECT.

The access element contains the table columns which are to be accessed.The key elements describe a condition for access.

Column values within a <key> element are combined with a logical AND; different <key> elements are combined with a logical OR.

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

It here where the query is actually written.

FILE to JDBC Adapter using SAP XI 3.0

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Thanks

[Former Member · Accepted solution]

Thank you very much for very nice reply with helpful answer.

i have checked the last link i.e scenario using JDBC

i have few questions.

What is ADAPTER MONITOR where it will be available and how to log into it.

What is SQL STUDIO and how to login to it and where it will be available.

can you please answer.

[Former Member · Accepted solution]

Hi

SQL Studio provides easy access to the data held in a SAP DB database instance. You can use two different clients.SQL Studio or Web SQL Studio

SQL Studio has a comfortable graphical user interface and runs on Microsoft Windows platforms. To those looking for a database query tool available on all operating system platforms, SAP DB offers the Web-based application Web SQL Studio.

Refer for more info

http://www.sapdb.org/7.4/sap_db_sql.htm

Adapter monitoring is used to check the status of the Communication Channels.Lots of information is there on SDN for Adapter Monitoing.In RWM go to Adpter Monitoring there you can start and stop CC.

Thanks