header6.jpg
首頁 arrow 專業討論區 
TWIUG Forum
歡迎, 訪客
登入註冊.
遺失密碼?
請教TABLE LOCK MODE的問題 (1 人正在瀏覽)
前往最底 張貼回覆

主題: 請教TABLE LOCK MODE的問題

#45
barry (訪客)
請教TABLE LOCK MODE的問題 2007/06/08 14:39  
各位前輩,你們好,小弟有個有關TABLE LOCK MODE的問題想請教,目前使用IDS 10.x版本,程式開發工具使用4GL。
日前新建立了一個table,於是呢當然要利用alter table modify lock mode (row)來修正該table的lock模式,也去systables和studio je工具裡面去查核,確定lock mode為row lock,但是當程式寫完之後,user上線使用的狀況一點都不像row lock,感覺就是page lock,明明不同筆資料,改A筆,B筆也不能改,程式的寫法都一直是這樣也沒 過,實在想不出來,故來跟各位前輩求救,感恩...
程式寫法列於下方
DECLARE t100_cl CURSOR FOR
SELECT * FROM xia_file
WHERE ROWID = g_xia_rowid FOR UPDATE

OPEN t100_cl
FETCH t100_cl INTO g_xia.*
  管理員已關閉公開寫入.
#47
Eric Lam (用戶)
Senior Boarder
文章: 11
graphgraph
回覆:請教TABLE LOCK MODE的問題 2007/06/10 23:16 聲譽: 1  
How many records will be updated in your "select..for update" TRANSACTION?

This is nothing to do with table lock mode.

All the locking records will only be released once you have committed.

文章曾經由此用戶編輯: Eric Lam, 於: 2007/06/13 03:35
  管理員已關閉公開寫入.
#49
barry (用戶)
Fresh Boarder
文章: 3
graphgraph
回覆:請教TABLE LOCK MODE的問題 2007/06/12 12:13 聲譽: 0  
不好意思 可能是我描述不清楚
我一次是根據g_xia_rowid來lock一筆資料
A user如果正在修改ROWID=2350這筆
B usre叫出ROWID-2365這筆資料要進行修改的動作
系統就會出現-244的錯誤訊息

別的程式都不會這樣
唯讀這支程式搭配xia_file table就會這樣
我程式寫法都沒變過
  管理員已關閉公開寫入.
#51
s8514012 (用戶)
Fresh Boarder
文章: 1
graphgraph
回覆:請教TABLE LOCK MODE的問題 2007/06/14 13:50 聲譽: 0  
請問你己有用oncheck -pt 再去檢查過lock mode己在row lock 了嗎??
  管理員已關閉公開寫入.
#163
parry (用戶)
Platinum Boarder
文章: 64
graphgraph
回覆:請教TABLE LOCK MODE的問題 2011/09/22 13:55 聲譽: 0  
Approval of the SFC announced on tera gold September 11, gold futures listed on the wow gold Shanghai Futures Exchange, the implementation in the near future is expected to be listed. tera gold Recently, the reporters to the futures industry in said.
  管理員已關閉公開寫入.
#988
rslifE01 (用戶)
Platinum Boarder
文章: 833
graph
HGTcEEa5 2011/12/31 14:57 聲譽: 0  
So! You've finally called. And I suppose you wow gold think I'll just be here. Well you're swtor credits wrong. I gave up on that yesterday. buy wow gold Seventeen weeks is long enough. Waiting for rift gold you; staring at the phone; never going cheap wow gold anywhere... Well I've had enough! I decided everquest 2 platinum toTwo Polish guys were taking their first buy ffxiv gil train trip to Warsaw on the train. archeage gold A vendor came down the corridor selling rsgold bananas which they'd never seen before. Each bought one. The first one eagerly peeled the banana and bit into it just as the train went int
The reasons why over 200,000 customers pick our services are wow gold as follows.- We do free delivery service on wow rift plat gold 24/7 and have online friendly support 24/7 as buy rs gold well.- Each of our customers with sincerity and enjoy runescape gold doing so.- With the fastest delivery and reliable service, rift gold we never lie to every customer about issues we buy wow gold may be having.- We reward our customers with our runescape money unique and wonderful gifts.- Members enjoy discounts on the world of warcraft gold lowest wow gold prices.- We are by far the wow gold for sale most secure company out there as we guarantee all our customers against fraud. We Sincerely hope that the information is very helpful for you. At the same time we welcome your feedback as well as good suggestion and will make effort to perfect it.The cheapest wow gold on both US and EU server are hot required.
  管理員已關閉公開寫入.
前往最頂 張貼回覆
Copyright 2007 Best of Joomla, Powered by FireBoard直接取得最新文章到你的桌面