Regarding JDBC Adapter

[Former Member]

Hi All,

If We r Dealing with JDBC Serder Means

We have "<b>Query Sql Statement & Update Sql Statement "</b> in Processing Parameters.

what is the Use of these ??? When we Will use these ?????

Can Any one Please Explain this

Regards

Vamsi

[prabhu_s2 · Accepted solution]

<b>Query Sql Statement</b> executes the query and retreives the data for processing.

<b>Update Sql Statement</b> upon retreival of some data u may want to update few fields. in this case u write an update query here

[Former Member · Accepted solution]

Hi,

>>>><i>Update Sql Statement upon retreival of some data u may want to update few fields. in this case u write an update query here</i>

Q1) If we did this, this will be the Permanant Changes to the database or Temporarly changes ????

Q2) This Update Sql Stement is Mandatory Input to the JDBC Sender or Optional One ???

Regards

Vamsi

[prabhu_s2 · Accepted solution]

<b>Q1) If we did this, this will be the Permanant Changes to the database or Temporarly changes ????</b>

permanent

<b>

Q2) This Update Sql Stement is Mandatory Input to the JDBC Sender or Optional One ???</b>

updation of DB is optional but mandatory input is required somehting like <TEST> if u are not goping to update any table in DB.

Message was edited by:

Prabhu S

[Former Member · Accepted solution]

It will be permanent changes.

If u dont wanna update then put <NONE> or <TEST>.

Regards

Sushil

[santhosh_kumarv · Accepted solution]

<b>Q1) If we did this, this will be the Permanant Changes to the database or Temporarly changes ????</b>

Temporary...[ But permanant untill u make any changes to that data in future ]

Q2) This Update Sql Stement is Mandatory Input to the JDBC Sender or Optional One ???

Optional....[ But mandatory when u make changes to table content using JDBC]

Regards

Santhosh

[prabhu_s2]

maybe follow this link to understand better:

http://help.sap.com/saphelp_nw70/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

[santhosh_kumarv]

Hi Vamsi,

The UPDATE statement is used to modify the data in a table i.e if u make some changes to the existing content of the table u actually UPDATE the table to make the changes effect.

QUERY returns the result of the table selected by the SELECT * statement.

http://www.w3schools.com/sql/sql_update.asp

Regards

Santhosh

[former_member614185]

---

>Query Sql Statement used to select some records from your database

-

---

>Update Sql Statement used to update your database records after your select query fetches records from you DB

[Former Member]

Query string is ur select statement i.e. on what conditino u wannt to select the data from database.

Update statement it to update the record so next in next select it should not be picked up or in other words, to set the record as read which has been selected in select query.

Regards

Sushil