Administrator Tip: Manage your database with DB2's cross-reference files

[Search400.com]

Title: Administrator Tips

June 09, 2004 Published by  Search400.com Administrator Tips NEWS     TOPICS     ASK THE EXPERTS     TIPS     WEBCASTS     WHITE PAPERS     IN THIS ISSUE:   > How to use DB2's cross-reference files to help manage your database -- Part I   > Logical files in different library than physical files   > How to update iSeries databases using JDBC, SQL   > DB2 vs. DB2 UDB   > Expert advice on DB2   > Reader survey: The state of the iSeries industry SPONSORED BY:  Search400.com Product and Vendor Guide The Buyers guide is one of the most comprehensive directories of vendor and product information on the Web. It covers a wide range of areas for your research needs, including Application Dev, E-Commerce Solutions, Security and more. Simply search by topic, company name or keyword and you have access to complete vendor and important product information without having to comb through multiple sites. Click Here! How to use DB2's cross-reference files to help manage your database -- Part I [Search400.com] by Ron Turull DB2 maintains a number of cross-reference files that you can use to easily retrieve information about files on your system. They contain information on files, fields, keys, referential constraints and much more -- and they are easy to work with. MORE INFO: > View other tips by Ron Turull Logical files in different library than physical files [Search400.com] Here's a simple way to list logical files where the logical file is in a different library than its associated physical file. How to update iSeries databases using JDBC, SQL [Search400.com] Here are some common JDBC examples to create, write, read and update data in normal iSeries data files using JDBC and SQL and how to efficiently update iSeries databases using Java Database Connectivity (JDBC). DB2 vs. DB2 UDB [Search400.com] A user asks, "What's the difference between DB2 and DB2 UDB?" Site expert John Brandt was on hand with an explanation. Expert advice on DB2 [Search400.com] Need a little help using DB2/400 or DB2 UDB? Check out these 10 tips from IBM's Kent Milligan. TOPICS: Reader survey: The state of the iSeries industry With IBM's latest announcements, things seem to be looking up for the iSeries market. But are they really? Is IBM doing enough to boost sales? Are more applications being developed for the iSeries? Are applications being moved onto other platforms? Take this 15-minute survey and tell us about the most critical issues affecting you as AS/400-iSeries professionals. TOPICS: iSeries word scramble game Need a little break from the monotony? Let's test your iSeries terminology out. Unscramble these 24 iSeries-related words. When you've completed the list, e-mail us with your answers. All Search400.com members that submit jumbles that are complete -- and correct -- will be placed into a drawing for a $25 Amazon gift certificate. Give it a try! TOPICS: Managing the iSeries Forum -- Interact with other administrators Are you an iSeries administrator with questions? Join your peers in our Managing the iSeries Forum to ask and answer questions on systems management issues. Search400.com experts frequent the forums and share their expertise. 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] ABOUT THIS E-NEWSLETTER This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Administrator Tips": Go to unsubscribe: http://search400.techtarget.com/u?track=NL-176 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: Search400 MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494