===================================================================== SEARCH400.COM | Programmer Tip Sept. 25, 2002 ===================================================================== FROM OUR SPONSORS: Do IT with DBU and ProData utilities! http://search400.com/r/0,,6039,00.htm?prodata ===================================================================== Essential explanations, tools and code for the iSeries programmer. More tips: http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f9,00.html
==================================================================== In today's technical advice roundup you'll find tips, expert answers and input from your peers to the following iSeries programmer questions and concerns: Today's Featured Programmer Tip: -- Six quick tips for working with DDS 1. Answers to Other Technical Questions: 1. Add lots of info to your sign-on screen 2. Simple way to retrieve mixed-case data 3. Physical file changes made easy 4. IBM's plans for DDS with DB2 2. Important Announcements and Links - Search400 IT Excellence Awards: Accepting nominations now - White Papers: Hundreds of iSeries-related white papers - Advice: Programmer Discussion Forum - Featured Book: The AS/400 Programmer's Handbook, Volume II ____________________________________________________________________ **************** SPONSORED BY ProData Computer Svcs **************** DBU 6.0... the best database utility now in GUI! ProTools, 18-utility suite...zip files, e-mail from the 400, program x-ref, menu system, all with source code included for $495! CvtRPGIV, new with RPGIV program templates and includes Cozzi's book on RPGIV! FREE Trials! Contact us today at [EMAIL PROTECTED] Or visit our Web site at http://search400.com/r/0,,6039,00.htm?prodata ==================================================================== Today's Featured Tip ==================================================================== Six quick tips for working with DDS DDS provide a powerful and convenient way to describe data attributes in file descriptions external to the application program that processes the data. People are always uncovering ways, however, for DDS do even more. Drawing from his own expertise, site expert Dwight Beech offers a few DDS tips when working with logical files. They include resizing a field, renaming a function, and creating a key field for a joined logical using the SST function. >> CLICK here for the full tip: http://www.search400.com/tip/1,289483,sid3_gci852539,00.html ==================================================================== Answers to Other Programmer Questions ==================================================================== 1. Add lots of info to your sign-on screen Although placing message fields on a sign-on display will allow you to modify the content displayed at sign on, needing a different message field for each line makes it irritating to work with. Fortunately, you can get the same display capability by using just a single message field. http://search400.techtarget.com/tip/1,289483,sid3_gci754602,00.html 2. Simple way to retrieve mixed-case data Follow this tip from site expert John Kohan to learn how to retrieve the key field and ignore the case it's currently in. http://search400.techtarget.com/tip/1,289483,sid3_gci780163,00.html 3. Physical file changes made easy When changing the DDS for a physical file with many logicals, Search400.com member Faithie Lewis says there's one simple way to implement the changes without going through the hassle of removing logicals, copying the file, recompiling the file empty, and mapping the data back in. Use CHGPF. http://search400.techtarget.com/tip/1,289483,sid3_gci820988,00.html 4. IBM's plans for DDS with DB2 One user writes, "What is IBM's plan for DDS with DB2. Is IBM planning on upgrading DDS to match RPG IV field lengths and to add 'blob' or other field types that can only be accessed via SQL now? How should I get data from Sybase running on Unix to DB400?" DB2/400 and DB2 UDB Expert Pascal Jacquemain offers his thoughts. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid427435_tax285216,00.html ____________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- ACCEPTING NOMINATIONS NOW | Search400 IT Excellence Awards We're on the lookout for medium- and large-scale companies that are blazing new trails in iSeries 400 computing. Are you pushing the limits of the iSeries server capacity or taking Web development for the iSeries to the next level? If so, then submit your nomination for Search400's IT Excellence Awards. This awards program recognizes the IT achievers at end-user companies who design, build and manage these complex technologies (no vendors, please). The deadline for submissions is Friday, Oct. 25, 2002. >> NOMINATE a company today: http://search400.techtarget.com/awards =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- HUNDREDS OF FREE WHITE PAPERS | Search400.com research Visit our white papers section and start boning up before your next purchase decision. You can browse by topic, author, or even search with your own keywords. If you know of other white papers that should be included, e-mail us or use our simple submission form. Check back often as we're adding more white papers every day. >> CLICK for iSeries-related white papers: http://search400.techtarget.com/whitepapers/0,293835,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- DISCUSSION FORUM | Interact with other programmers Are you an iSeries programmer with questions? Join your peers in Our Programmer Forum to ask and answer questions about XML, COBOL, CL, ILE, Web development, Java and much more. >> RECENT Discussion threads you may find of interest: * Automatic close of display files http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/2600 * Subfile cursor positioning http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/2587 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FEATURED BOOK | Search400.com's Bookstore Title: The AS/400 Programmer's Handbook, Volume II Author: Mark McCall Now you can stop wasting countless hours wading through IBM's technical manuals, looking for programming examples to show you how a technique really needs to be coded. This book and companion CD contain more than 70 prototypical techniques and coding examples that you can use and adapt for hundreds of applications. From system APIs to SQL, the material presented encompasses the most useful and powerful features of the iSeries 400. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=1583470123&partner_id=55 ____________________________________________________________________ :::::::::::::::::::::: SEARCH400.COM CONTACTS :::::::::::::::::::::: TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. ____________________________________________________________________ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. ____________________________________________________________________ DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. ____________________________________________________________________ DAVID GABEL, executive tech editor (mailto:[EMAIL PROTECTED]) >> Send me your technical tips and tip ideas. ____________________________________________________________________ GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ____________________________________________________________________ ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002 TechTarget. All rights reserved. Unsubscribe from 'Programmer Tips' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search400.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
