Cursor Modes in Siebel Scripting on DB2 UDB for z/OS and OS/390
(Doc ID 478276.1)
Last updated on FEBRUARY 04, 2022
Applies to:
Siebel Tools - Version 7.5.1 SIA [15026] and laterIBM z/OS on System z
IBM z/OS (OS/390)
Area(s):Siebel VB/eScript/COM
Release(s):V7 (Enterprise), V8 (Enterprise)
Database(s):DB2
App Server OS(s):IBM OS/390, IBM zOS
Latest release tested against:V8 (Enterprise)
Keywords:DB2, OS/390, z/OS, Cursor, mode, ForwardOnly, ForwardBackward, thread, threads, management, script
This document was previously published as Siebel Technical Note 592.
Purpose
This technical note explains how to write Siebel VB or eScript queries to prevent unwanted database threads on DB2 for z/OS and OS/390. Careful handling is required because of how the cursor in DB2 behaves when the script completes. The choice between ForwardOnly or ForwardBackward cursor modes affects the number of active database threads on DB2 for z/OS and OS/390. This choice must be made by the script to prevent exceeding storage limitations in DB2.
Scope
This document is informational and intended for any user.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Scope |
| Details |
| ForwardOnly Cursor Mode |
| MaxCursorSize |
| References |