473,396 Members | 1,998 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > db2 database > questions > v8 dynamic scrollable cursors

Join Bytes to post your question to a community of 473,396 software developers and data experts.

v8 Dynamic Scrollable Cursors

I am aware that v7 Static Scrollable Cursors do not work with
pseudo-conversational CICS because of the temp work file being
destroyed but will v8 Dynamic Scrollable Cursors work with
pseudo-conversational CICS due to these cursors directly using the base
table?

Nov 12 '05 #1
1 3023
I am not sure. But I don't think db2 dynamic scrollable cursors direct using
the base table. Either dynamic or static cursor, they both work on the copy
(in memory) of the physical table. One will lock the base table during the
update, another one will not.
<da*********@pstechnology.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
I am aware that v7 Static Scrollable Cursors do not work with
pseudo-conversational CICS because of the temp work file being
destroyed but will v8 Dynamic Scrollable Cursors work with
pseudo-conversational CICS due to these cursors directly using the base
table?

Nov 12 '05 #2
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
Dynamic Cursor versus Forward Only Cursor gives Poor Performance
by: Kevin Frey | last post by:
Hello, I have a test database with table A containing 10,000 rows and a table B containing 100,000 rows. Rows in B are "children" of rows in A - each row in A has 10 related rows in B (ie. B has...
Microsoft SQL Server
5
Cursors and dynamic SQL
by: Joško Šugar | last post by:
On this site: http://www.sommarskog.se/dynamic_sql.html I have found an example how to use cursor with dynamic SQL: DECLARE @my_cur CURSOR EXEC sp_executesql N'SET @my_cur = CURSOR FOR SELECT...
Microsoft SQL Server
5
php-odbc and dynamic vs forward only cursors
by: Todd Huish | last post by:
I have noticed something disturbing when retrieving datasets over a relatively slow line (multiple T1). I am looking at about 25 seconds to retrieve 500 rows via a php-odbc link. This same select...
DB2 Database
0
Trying to get scrollable result set from SQL stored procedure
by: 4.spam | last post by:
Hello. W2K, v8.2.1, jcc driver I am trying to get scrollable result set from SQL stored procedure in my java application using jcc driver. --- CallableStatement cs = conn.prepareCall (...
DB2 Database
2
Scrollable datagrid: dynamic paging
by: RJN | last post by:
Hi Sorry for posting again. I have a datagrid which is put inside a div tag to make it scrollable. I need to page the datagrid. The page numbers appear at the bottom of the datagrid and has...
ASP.NET
0
Dynamic scrollable region?
by: Quivis | last post by:
Hello, I have this idea for a "normal" css layout, header, scrollable area, footer, but I want the footer "static", in the sense that it should stay at the bottom of the window, and have the...
HTML / CSS
2
Ensurevisible doesn't work in listview when scrollable = false
by: Ben H | last post by:
Hello all I'm using a listview in my app but I want to scroll the listview programatically as I hate the look of the standard scrollbar. So, the listview is scrolled programatically using...
.NET Framework
2
dynamic cursor - sorting in declaration
by: Łukasz W. | last post by:
Hello everybody! I have a small table "ABC" like this: id_position | value --------------------------- 1 | 11 2 | 22 3 | 33
Microsoft SQL Server
0
Using .load() to load a dynamic/animated element
by: liz0001 | last post by:
I have seen many examples on how to use the .load() function to load in static elements, but I am trying to load a dynamic element, specifically a scrollable. I have gotten it to the point where:...
Javascript
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!