Ask the Experts: Rownum code solution for DB2 on the OS/390

[Search390.com]

Title: Ask The Experts

September 02, 2004 Published by  Search390.com Ask The Experts NEWS     TOPICS     ASK THE EXPERTS     TIPS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > KnowledgeStorm IN THIS ISSUE:   >  Rownum code solution for DB2 on the OS/390   >  Duplicating Oracle's rownum function in DB2   >  Why deadlocks occur and what to do about them   >  Using an open cursor to scroll forward and backward   >  DB2 Version 8 explained Rownum code solution for DB2 on the OS/390 [Search390.com] A Search390.com user asked: My supervisor and I figured out how to simulate the Oracle rownum feature in DB2, version 7.1 , on the OS/390. Here it is, could you share this code with the world for us? To see the answer, click here.   KnowledgeStorm One of the best research tools for new product purchasing is right at your fingertips. Visit the Search390.com Product and Vendor Guide, powered by KnowledgeStorm, to compare specific hardware and software solutions. Don't jump from one vendor site to the next -- do all your comparisons all in one place. You can also receive quotes directly Click Here   Duplicating Oracle's rownum function in DB2 [Search390.com] A Search390.com user asked: Can I join two or more tables in new DB2 utility UNLOAD? To see the answer, click here. Why deadlocks occur and what to do about them [Search390.com] A Search390.com user asked: We already tried to update the rows of the same table in order but why are we still getting deadlocked to the same program? We use DB2 V6 for OS/390 and CICS TS V1.3 on OS/390 V2.9. The transaction came from RS6K CICS and routed to CICS/390 using DPL. To see the answer, click here. 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? To see the answer, click here. FEATURED TOPIC:  DB2 Version 8 explained DB2 V8 has been out for months but most mainframers still haven't upgraded. Search390.com this week features a host of content on the newest version of the venerable database. WEBCAST:  IMS meets the Web! If you said Web-enabling a database, most people probably think you mean connecting DB2 to the Web. But IMS, IBM's older database, is just as Web worthy. IMS is geared for fast and frequent access. You can directly attach IMS to the Web or go via CICS or DB2. In this Webcast, Jim Keohane will discuss the ins and outs of bringing IMS databases to the Web. TIP:  Should you upgrade to DB2 V8 now? Recently, a Search390.com user recently asked Craig Mullins, our DB2 and database management expert, whether he should upgrade to DB2 V8 now. Read Craig's reply. 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?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