|
|
Archives of the TeradataForum
Message Posted: Mon, 06 Jul 2009 @ 11:54:09 GMT
Subj: | | How to get "locking row for access" on child and parent query? |
|
From: | | Poddar, Gautam |
Hi,
Can anyone tell me what is wrong with this query?
Locking row For access On config_item_obs
Select *
From
csi.systemx
Where csi_system_num In
(
Select csi_system_num
From config_item_obs
Where
config_item_class_name = 'SOFTWARE'
)
Locking row For access
Select *
From
csi.systemx
Where csi_system_num In
(
Locking row For access
Select csi_system_num
From config_item_obs
Where
config_item_class_name = 'SOFTWARE'
)
Locking row For access
Select *
From
csi.systemx
Where csi_system_num In
(
Locking row For access
Select csi_system_num
From config_item_obs
Where
config_item_class_name = 'SOFTWARE'
)
Basically I am trying to achieve locking row for access on both the tables (csi.systemx, config_item_obs).
Thanks,
Gautam Poddar
| |