青青草原综合久久大伊人导航_色综合久久天天综合_日日噜噜夜夜狠狠久久丁香五月_热久久这里只有精品

Prayer

在一般中尋求卓越
posts - 1256, comments - 190, trackbacks - 0, articles - 0
  C++博客 :: 首頁 :: 新隨筆 :: 聯系 :: 聚合  :: 管理

Held and non-held cursors

Posted on 2010-05-12 23:21 Prayer 閱讀(219) 評論(0)  編輯 收藏 引用 所屬分類: DB2

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_heldnonheldcursor.htm

Held and non-held cursors

A held cursor does not close after a commit operation. A cursor that is not held closes after a commit operation. You specify whether you want a cursor to be held or not held by including or omitting the WITH HOLD clause when you declare the cursor.

After a commit operation, the position of a held cursor depends on its type:
  • A non-scrollable cursor that is held is positioned after the last retrieved row and before the next logical row. The next row can be returned from the result table with a FETCH NEXT statement.
  • A static scrollable cursor that is held is positioned on the last retrieved row. The last retrieved row can be returned from the result table with a FETCH CURRENT statement.
  • A dynamic scrollable cursor that is held is positioned after the last retrieved row and before the next logical row. The next row can be returned from the result table with a FETCH NEXT statement. DB2® returns SQLCODE +231 for a FETCH CURRENT statement.
A held cursor can close when:
  • You issue a CLOSE cursor, ROLLBACK, or CONNECT statement
  • You issue a CAF CLOSE function call or an RRSAF TERMINATE THREAD function call
  • The application program terminates.

If the program abnormally terminates, the cursor position is lost. To prepare for restart, your program must reposition the cursor.

The following restrictions apply to cursors that are declared WITH HOLD:
  • Do not use DECLARE CURSOR WITH HOLD with the new user signon from a DB2 attachment facility, because all open cursors are closed.
  • Do not declare a WITH HOLD cursor in a thread that might become inactive. If you do, its locks are held indefinitely.

IMS™

You cannot use DECLARE CURSOR...WITH HOLD in message processing programs (MPP) and message-driven batch message processing (BMP). Each message is a new user for DB2; whether or not you declare them using WITH HOLD, no cursors continue for new users. You can use WITH HOLD in non-message-driven BMP and DL/I batch programs.

CICS

In CICS® applications, you can use DECLARE CURSOR...WITH HOLD to indicate that a cursor should not close at a commit or sync point. However, SYNCPOINT ROLLBACK closes all cursors, and end-of-task (EOT) closes all cursors before DB2 reuses or terminates the thread. Because pseudo-conversational transactions usually have multiple EXEC CICS RETURN statements and thus span multiple EOTs, the scope of a held cursor is limited. Across EOTs, you must reopen and reposition a cursor declared WITH HOLD, as if you had not specified WITH HOLD.

You should always close cursors that you no longer need. If you let DB2 close a CICS attachment cursor, the cursor might not close until the CICS attachment facility reuses or terminates the thread.

The following cursor declaration causes the cursor to maintain its position in the DSN8910.EMP table after a commit point:

EXEC SQL
DECLARE EMPLUPDT CURSOR WITH HOLD FOR
SELECT EMPNO, LASTNAME, PHONENO, JOB, SALARY, WORKDEPT
FROM DSN8910.EMP
WHERE WORKDEPT < 'D11'
ORDER BY EMPNO
END-EXEC.
青青草原综合久久大伊人导航_色综合久久天天综合_日日噜噜夜夜狠狠久久丁香五月_热久久这里只有精品
  • <ins id="pjuwb"></ins>
    <blockquote id="pjuwb"><pre id="pjuwb"></pre></blockquote>
    <noscript id="pjuwb"></noscript>
          <sup id="pjuwb"><pre id="pjuwb"></pre></sup>
            <dd id="pjuwb"></dd>
            <abbr id="pjuwb"></abbr>
            一区二区三区.www| 在线观看一区欧美| 亚洲永久精品国产| 亚洲视屏在线播放| 国产欧美一区二区三区在线老狼| 亚洲天堂免费观看| 亚洲自啪免费| 亚洲高清一二三区| 99精品99久久久久久宅男| 欧美性大战久久久久久久蜜臀| 亚洲欧美综合v| 久久九九久精品国产免费直播| 亚洲国产岛国毛片在线| 亚洲精品一区二区三区av| 国产精品高精视频免费| 久久天堂精品| 欧美天堂亚洲电影院在线播放| 欧美伊人久久久久久久久影院| 久久国产精品久久久久久| 亚洲精品免费在线| 亚洲影音一区| 亚洲三级视频| 欧美亚洲免费电影| 99视频在线精品国自产拍免费观看 | 亚洲伦理在线免费看| 一区二区高清| 在线成人小视频| 这里只有精品丝袜| 亚洲国产国产亚洲一二三| 亚洲视频欧美视频| 亚洲理论在线| 欧美一区二区三区在| 一区二区国产精品| 美女黄色成人网| 久久精品免费看| 欧美视频在线观看视频极品| 麻豆国产精品va在线观看不卡| 欧美新色视频| 亚洲人体影院| 在线精品国产成人综合| 亚洲一区二区三区四区在线观看 | 日韩一区二区高清| 久久亚洲精品网站| 久久久精品日韩| 欧美性猛交xxxx免费看久久久 | 久久综合99re88久久爱| 国产精品极品美女粉嫩高清在线| 欧美二区在线观看| 黑人极品videos精品欧美裸| 在线亚洲自拍| 亚洲天堂免费在线观看视频| 欧美暴力喷水在线| 欧美高清视频| 亚洲国产精品va| 久久躁日日躁aaaaxxxx| 久久久久五月天| 国产一区二区看久久| 亚洲欧美一区二区三区在线| 亚洲免费婷婷| 欧美香蕉视频| 亚洲午夜在线观看| 午夜久久电影网| 国产精品一二三四| 亚洲一区日韩| 久久久久www| 精品99视频| 久久手机免费观看| 欧美激情第三页| 日韩午夜av在线| 欧美精品一区三区| 日韩亚洲成人av在线| 亚洲综合二区| 国产视频一区二区在线观看| 欧美有码在线视频| 欧美成人精品一区二区| 91久久久国产精品| 欧美日韩视频在线观看一区二区三区| 亚洲精品小视频| 亚洲免费在线观看视频| 国产伦精品一区二区三| 久久国产精品久久久久久| 嫩草伊人久久精品少妇av杨幂| 亚洲高清免费视频| 欧美日韩成人激情| 亚洲欧美影音先锋| 欧美成人午夜剧场免费观看| 亚洲精品乱码久久久久久| 欧美日韩网站| 日韩午夜免费视频| 久久久久久久网| 亚洲三级毛片| 国产欧美日韩一级| 老司机凹凸av亚洲导航| 99国产精品久久久久久久久久 | 亚洲日本va午夜在线影院| 亚洲一区3d动漫同人无遮挡| 国产一区二区高清不卡| 欧美不卡福利| 欧美在线免费看| 亚洲精品乱码久久久久久久久| 欧美亚洲系列| 亚洲九九九在线观看| 国产亚洲免费的视频看| 欧美xxx成人| 久久成人综合视频| 99国产精品久久久| 欧美刺激性大交免费视频| 亚洲制服丝袜在线| 91久久香蕉国产日韩欧美9色| 国产精品白丝av嫩草影院 | 亚洲一区二区四区| 亚洲高清电影| 久久这里只有| 久久国产精品久久久| 亚洲精品偷拍| **网站欧美大片在线观看| 国产精品欧美日韩一区二区| 欧美福利电影在线观看| 久久精品国产77777蜜臀| 亚洲一区二区精品| 99热在线精品观看| 亚洲人精品午夜| 欧美激情一二三区| 美国十次成人| 久久人人爽人人| 久久成人18免费观看| 亚洲天堂av在线免费| 日韩一级精品视频在线观看| 亚洲国产精品v| 怡红院精品视频| 一区二区在线看| 国产一区二区三区久久 | 99精品热视频只有精品10| 永久免费精品影视网站| 国产一区二区三区日韩| 国产精品亚洲一区| 国产精品亚洲综合天堂夜夜| 国产精品v日韩精品v欧美精品网站| 欧美成人午夜激情在线| 欧美a级一区二区| 欧美国产日韩一区二区在线观看| 久久青草久久| 欧美成人一区二区| 欧美母乳在线| 国产精品高清免费在线观看| 欧美无砖砖区免费| 国产精品一国产精品k频道56| 国产精品人成在线观看免费| 国产精品xnxxcom| 国产精品爽黄69| 国产在线视频欧美| 在线日本欧美| 一本久久知道综合久久| 一区二区三区视频在线看| 亚洲天堂男人| 久久久精品欧美丰满| 蜜桃av综合| 亚洲欧洲久久| 亚洲视频axxx| 欧美在线观看视频| 欧美a级片一区| 欧美日韩亚洲一区二区三区在线观看 | 久久九九免费视频| 欧美成人性生活| 欧美三区在线| 国产真实乱子伦精品视频| 亚洲国产二区| 亚洲一区日韩| 久久久综合香蕉尹人综合网| 欧美激情网站在线观看| 99精品久久久| 久久久999精品| 欧美精品成人在线| 国产亚洲aⅴaaaaaa毛片| 91久久精品日日躁夜夜躁欧美| 在线亚洲国产精品网站| 久久av一区二区| 亚洲激精日韩激精欧美精品| 国产日本精品| 美女黄网久久| 国产精品一区一区三区| 蘑菇福利视频一区播放| 欧美第一黄色网| 久久久亚洲人| 欧美激情小视频| 亚洲欧美日韩国产一区| 快she精品国产999| 国产欧美日韩亚洲一区二区三区| 亚洲激情视频在线播放| 亚久久调教视频| 亚洲欧洲精品一区二区精品久久久 | 欧美精品999| 国内久久精品| 午夜精品www| 亚洲精品久久嫩草网站秘色| 久久精品国产91精品亚洲| 欧美午夜精品久久久久久孕妇 | 欧美在线视频导航| 一区二区三区欧美成人| 嫩草国产精品入口|