sql update query

[Former Member]

hello

I have a scenario DB 2 RFC. I run the query on oracle 10.2.0.4

I am writing a query select * from <table name>.

I would like to know what is the update query to write in order for it to do nothing, meaning run the select query even the table is empty

[Former Member · Accepted solution]

Hi,

The update query is executed after the select query is finished. If you dont want the update query to do anything just enter <TEST> in the placeholder.

Thanks,

Pragati

[Former Member · Accepted solution]

my problem is that the talbes are non-updateable (big organization). is there a way to not do the update query, or it is mandatory? as a workaround i can also create a view talbe which will be updateable and also run the update query on this table for every interface that I develop (I will have a few).

kfir

[stefan_grube · Accepted solution]

This is a mandantory field, so you have to put in something.

[Former Member · Accepted solution]

Hi,

Just enter the text <TEST>, it will work fine.It won't update any of the tables.

Regards,

Pragati

[Former Member]

use u201C<test>u201C if you want only test the db query and do not want an update. you may leave the other fields unchanged.

[stefan_grube]

The table should have a column which identifies whether the data have already been read or not.

Lets assume you have a column "flag".

Then you have a select:

select * from <table name> where flag = null

and an update:

update <table name> set flag = 'X'

[stefan_grube]

If you really want to do nothing, as workaround you can create a stored procedure "dummy" and call this.