on 08-23-2007 10:12 AM
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
<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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
<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
<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
maybe follow this link to understand better:
http://help.sap.com/saphelp_nw70/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.