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

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>
            亚洲激情黄色| 欧美激情 亚洲a∨综合| 一本色道久久综合狠狠躁篇怎么玩| 久久久精品视频成人| 亚洲电影免费在线| 亚洲经典视频在线观看| 欧美精品色网| 亚洲欧美一级二级三级| 欧美专区18| 亚洲精品九九| 亚洲综合欧美| 亚洲国产精品成人综合| 亚洲啪啪91| 国产亚洲免费的视频看| 亚洲国产高清aⅴ视频| 欧美日韩无遮挡| 久久精品国产视频| 欧美精品亚洲一区二区在线播放| 亚洲一区视频| 久久久免费精品| 中国成人亚色综合网站| 欧美自拍偷拍午夜视频| 99国产精品一区| 久久成年人视频| 99这里只有久久精品视频| 午夜精品免费在线| 一区二区精品国产| 久久久久九九视频| 亚洲一区二区三区欧美 | 老司机一区二区| 国产精品国产成人国产三级| 欧美国产日本韩| 国产情人节一区| 一本一本久久a久久精品牛牛影视| 国内自拍一区| 亚洲网在线观看| 亚洲精品一区二区三区四区高清| 午夜精品久久久久久久| 亚洲视频精选| 蜜臀91精品一区二区三区| 欧美在线1区| 国产精品草莓在线免费观看| 亚洲高清色综合| 怡红院精品视频| 欧美在线播放视频| 欧美在线三区| 国产精品视频精品| 在线视频你懂得一区| 99在线精品观看| 欧美国产日本在线| 亚洲国产精品久久91精品| 狠狠入ady亚洲精品经典电影| 亚洲在线一区| 午夜免费久久久久| 国产精品久久久久77777| 日韩午夜在线观看视频| 一区二区三区日韩在线观看| 欧美激情a∨在线视频播放| 欧美国产精品中文字幕| 亚洲国产精品一区二区www| 久久狠狠婷婷| 久久嫩草精品久久久精品一| 国产午夜亚洲精品理论片色戒| 亚洲欧美一区二区在线观看| 欧美一级在线亚洲天堂| 国产精品久久一卡二卡| 亚洲一区二区三区在线观看视频| 亚洲欧美日韩一区| 国产精品一区二区在线| 久久国产精品72免费观看| 久久蜜桃精品| 亚洲国产专区校园欧美| 欧美激情中文字幕在线| 99精品黄色片免费大全| 亚洲自拍偷拍福利| 国产麻豆成人精品| 久久激情五月婷婷| 亚洲第一精品福利| 一个色综合导航| 国产欧美二区| 久久精品欧美| 亚洲区欧美区| 午夜免费日韩视频| 精品成人乱色一区二区| 欧美激情欧美狂野欧美精品| 亚洲少妇自拍| 裸体歌舞表演一区二区| 99re热精品| 国产日韩在线视频| 蜜桃伊人久久| 亚洲永久在线观看| 欧美国产精品中文字幕| 亚洲尤物影院| 亚洲第一页中文字幕| 欧美日韩中文字幕| 久久国产精品网站| 亚洲美女av在线播放| 久久久久久高潮国产精品视| 亚洲三级影院| 国产精品入口夜色视频大尺度| 久久一区二区视频| 亚洲视频一区在线| 美国十次成人| 午夜精品在线视频| 亚洲美女精品久久| 国产一区二区你懂的| 欧美精品综合| 久久激情视频久久| 亚洲网友自拍| 亚洲日本乱码在线观看| 久久米奇亚洲| 欧美一区二区视频97| 99成人精品| 亚洲二区在线视频| 国产在线精品二区| 国产精品久久久久久久久果冻传媒 | 国内精品久久久久久| 欧美午夜片在线观看| 欧美成人精品高清在线播放| 欧美在线观看一区二区| 亚洲一品av免费观看| 亚洲精品一区在线观看香蕉| 老巨人导航500精品| 羞羞色国产精品| 亚洲综合国产激情另类一区| 亚洲免费av电影| 亚洲国产日韩一区| 黄色资源网久久资源365| 国产欧美日韩激情| 国产精品美女久久福利网站| 欧美日韩午夜在线| 欧美精品久久久久久| 欧美大片一区二区| 欧美a级一区| 欧美不卡激情三级在线观看| 免费在线观看日韩欧美| 久久综合久久综合久久综合| 久久精品国产免费| 久久久久在线观看| 久久久99免费视频| 久久综合中文| 美乳少妇欧美精品| 欧美黄网免费在线观看| 欧美成人有码| 欧美精品日韩三级| 欧美日韩直播| 国产精品卡一卡二卡三| 国产精品区一区二区三| 国产日韩欧美在线播放| 国内精品伊人久久久久av影院| 国产综合久久| 亚洲第一在线综合在线| 亚洲人午夜精品| 一区二区欧美精品| 亚洲一级免费视频| 欧美专区第一页| 免费观看在线综合| 亚洲全黄一级网站| 宅男噜噜噜66国产日韩在线观看| 亚洲在线成人精品| 久久久伊人欧美| 欧美激情亚洲| 国产精品萝li| 亚洲高清免费视频| 亚洲视频一区二区免费在线观看| 午夜精品久久久久久久99水蜜桃| 久久国产精品久久久| 欧美成人午夜影院| 国产精品99久久久久久宅男| 欧美综合77777色婷婷| 欧美精品成人| 国产欧美在线视频| 亚洲精品日日夜夜| 欧美一级理论性理论a| 欧美成人官网二区| 亚洲无线视频| 麻豆久久婷婷| 国产精品一卡| 日韩一区二区免费高清| 欧美亚洲一区二区三区| 亚洲国产你懂的| 亚洲欧美激情在线视频| 欧美大片专区| 国产亚洲亚洲| 亚洲一区二区三区视频播放| 蜜臀va亚洲va欧美va天堂| 99亚洲伊人久久精品影院红桃| 久久久久久午夜| 国产精品国色综合久久| 最近中文字幕mv在线一区二区三区四区 | 久久er精品视频| 欧美日韩精品一区二区在线播放| 国产综合自拍| 欧美亚洲一区| 一本久久青青| 欧美国产免费| 最新国产拍偷乱拍精品| 久久九九国产精品| 亚洲免费视频中文字幕| 国产精品xnxxcom|