JDBC query

[Former Member]

Hello,

I am trying to do a JDBC connection and doing a select query to bring “UPTO 300” rows. But I want to do an update on these 300 rows and is there a way I can write a query to do an update on the 300 rows selected?

-AR

[bhavesh_kantilal]

Antonio,

This should ceratinly be possible. Ask an SQL guru to help you frame the SQL select statement such that only n number of records are selected.

Regards,

Bhavesh

[Former Member]

in ur jdbc adapter , ther r two options..selct and update...after each selct..make an update...

hence ur data will not only b fetched but updated also...

(syntax in sql ofcous)

[Former Member]

Thanks for all the responses. But how do I write the query to limit to 300 records. Do I do a count in the substring or can I specify an explicit query statement??

-AR

[Former Member]

Hi,

If I understand your question properly, your select querry will select 300 records and you need to update these 300 records. If so, you can do it easily. Use the update querry with the condition you used in the select querry(same where clause)

Regards,

Jai Shankar.