Cursor Modes in Siebel Scripting on DB2 UDB for z/OS and OS/390
(Doc ID 478276.1)
Last updated on MARCH 13, 2020
Applies to:Siebel Tools - Version 7.5.1 SIA  and later
IBM z/OS on System z
IBM z/OS (OS/390)
Release(s):V7 (Enterprise), V8 (Enterprise)
App Server OS(s):IBM OS/390, IBM zOS
Latest release tested against:V8 (Enterprise)
Checked for relevance on 11-Sep-2013
Keywords:DB2, OS/390, z/OS, Cursor, mode, ForwardOnly, ForwardBackward, thread, threads, management, script
This document was previously published as Siebel Technical Note 592.
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.
This document is informational and intended for any user.
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
|ForwardOnly Cursor Mode|