Ask the Experts: How and when to use DB2 scrollable cursors

[Search390.com]

Title: Ask The Experts

Featured Offer: Management of On Demand Computing This paper explores IBM's vision of the on demand business environment in which organizations dynamically respond to market changes and customer demands. Discover the critical role played by orchestration and learn how to best utilize resources by adopting the latest techniques in automated just-in-time provisioning. Visit our Resource Center today to download this paper highlighting IBM's latest automation offerings.

Using an open cursor to scroll forward and backward
[Search390.com]
A Search390.com user asked: Given a table, my application specification requires me to position somewhere in the middle of the set of records and then fetch records either forward (increasing sort key order) or backward depending on user selection. Is there a straightforward way of doing it in SQL a special way for table or query definition?
Click here for the answer.

Hot DB2 V8 features
[Search390.com]
A Search390.com user asked: What new features in DB2 V8 jump out at you? Data Partioned Secondary Indexes (DPSIs)? New SQL commands? Better use of Unicode?
Click here for the answer.

Error using FETCH ABSOLUTE in scrollable cursor
[Search390.com]
A Search390.com user asked: We are using DB2 V7 on OS/390 and trying scrollable cursors in a stored procedure. When we try to use the FETCH statement like: FETCH ABSOLUTE FROM INTO, it's throwing for the host variable and saying "variable should be zero scale." I had declared the variable as an INTEGER, and I even tried it with DECIMAL(n,0), but I get the same error.
Click here for the answer.



FEATURED TOPIC:  Mainframe migration
Migration is always an issue for a mainframe shop. Are you are thinking about upgrading to the newest version of z/OS or DB2 release. Check out our best migration links.

QUICK POLL:  Software negotiation
Would you consider your most recent negotiation with a software vendor successful?

ITKNOWLEDGE EXCHANGE:  Help us beta test this new feature
ITKnowledge Exchange is a place where storage professionals can share ideas, expertise and get difficult technical questions answered by other IT pros. Better than a forum or a listserv, it provides the opportunity to collaborate with groups and individual experts who share similar areas of IT expertise. This new feature is currently in beta. Sign up today and help us make it a success!

	Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] Free E-Newsletters! Select e-newsletters you would like to receive via e-mail! Search390: Today's News Not a Member? We'll activate your membership with your subscription.

ABOUT THIS E-NEWSLETTER

			This e-newsletter is published by Search390.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Ask The Experts": Go to unsubscribe: http://search390.techtarget.com/u?cid=496017&lid=430652&track=NL-16 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search390 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494