Administrator Tip: Special features make creating tables simple

[Search400.com]

Title: Administrator Tips

July 21, 2004 Published by  Search400.com    Administrator Tips IN THIS ISSUE:   >  Special features make creating tables simple   >  Create tables with SQL   >  Use the SQL Rename command to make everyone happy   >  Sorting tables by fields containing Polish characters   >  Monitoring your iSeries system   >  Free Book Excerpt: Experts' Guide to OS/400 & i5/OS Security 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! Special features make creating tables simple [Search400.com] by Ron Turull With the help of prompting and basing table support, creating conversion tables and sort sequence tables is now a very intuitive process. No longer must you count your finger along the SEU screen making sure your hex codes are in the correct position. Tables are used extensively on the AS/400-iSeries. Although most of their use is under the covers, there are many instances in everyday programming when tables -- both conversion tables and sort sequence tables -- are very handy tools. MORE INFO: > View other tips by Ron Turull Create tables with SQL [Search400.com] A user kept receiving an error SQL7905 when trying to create tables with SQL. What was he doing wrong? Site Expert Kent Milligan had some advice. Use the SQL Rename command to make everyone happy [Search400.com] Search400.com member David Ford provides code that defines a "static" short 10-character name for the tables (and record-format and member and columns) AND it allows the Java programmers to have their descriptive long name. Sorting tables by fields containing Polish characters [Search400.com] A user was trying to use an OLE DB provider for DB2 UDB to connect to DB2/400, but he kept having problems sorting tables by fields containing Polish characters. What was going on? Site expert Kent Milligan figured it out. Monitoring your iSeries system [Search400.com] Monitoring your system and notifying your team of a problem in a timely manner can be a tedious job, but it is also an important, ongoing job. We've assembled our best tips and tricks to make your job easier. FREE BOOK EXCERPT:  Free Book Excerpt: Experts' Guide to OS/400 & i5/OS Security Log on and download for free an excerpt from Chapter 12 of Experts' Guide to OS/400 & i5/OS Security written by Carol Woodbury and Patrick Botz and published by 29th Street Press. This chapter, "Single Sign-on," addresses problems associated with the multitude of user IDs and passwords your users must remember. Win a copy of the book: After you read the chapter, test how much you learned and then send us the results for a chance to win a copy of Experts' Guide to OS/400 & i5/OS Security. Send your e-mail to [EMAIL PROTECTED]. SURVEY:  User poll Do you have plans to invest in an eServer i5? TIP CONTEST:  Win an iSeries.mySeries. prize pack -- submit your tip today This month we're giving away what may be our coolest prize ever -- the iSeries.mySeries. prize pack. If you have a shortcut or time-saving tip that could help out other iSeries users, submit it today. Winning this prize pack would truly help you to show your love for your iSeries. This pack consists of a polo shirt, temporary tattoo and bumper sticker. Don't miss out -- send in your tip for a chance to win.   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!  Search400: Programmer Tips  Search400: Security Tip  Search400: Today's News Not a Member? We?ll activate your membership with your subscription.   This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. To unsubscribe from "Administrator Tips": Go to unsubscribe: http://search400.techtarget.com/unsubscribe?track=NL-176&ad=487449 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 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494