By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

SELECT ... FOR UPDATE

P: n/a
I need som ehelp concerning queries using SLEECT ... FOR UPDATE

I have two tables (see description below)

One is the table of reference, the other one is a table where i have daily infoirmation

I want to check the differences on the two tables based on the fields omc_index and bsc for each cellname.
Then when I have inconsistency, I want to update the first table with information picked up in the second table.

My query is the following

Select t1.omc_index, t1.bsc from edw_object t1, edw_object_ref t2 WHERE t1.cellname=t2.cellname and t1.day='20031214' and (t1.omc_index<>t2.omc_index or t1.bsc<>t2.bsc) FOR UPDATE of t2;

I can not find much information on FOR UPDATE.

Thank you for your help

*************************

Table "public.edw_object_ref"
Column | Type | Modifiers
-----------------+---------+-----------
edw_group_table | text |
omc_index | text |
cellname | text |
cellid | integer |
bsc | text |
country | text |
super_region | text |
region | text |
area | text |
subarea | text |
zone | text |
ibc | text |
road | text |
trial | text |
subtrial | text |
date | integer |
Indexes: ix_cellname_edw_object_ref btree (cellname),
ix_omc_index_edw_object_ref btree (omc_index)

Table "public.edw_object"
Column | Type | Modifiers
-----------------+-----------------------+-----------
cellname | character varying(50) |
bsc | text |
region | text |
edw_group_table | text |
omc_index | text |
day | integer |
cellid | integer |
subarea | text |
road | text |
trial | text |
ibc | text |
subtrial | text |
country | text |
super_region | text |
area | text |
zone | text |
Indexes: edw_object_day btree ("day"),
ix_edw_object_omc_index btree (omc_index)

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.