============================================================== SEARCH400.COM | Programmer Tip Feb. 12, 2003 ============================================================== FROM OUR SPONSORS: FREE White Paper: Building an E-Commerce Trust Infrastructure http://search400.com/r/0,,10186,00.htm?freeguide
iSeries WebFacing, WebSphere solutions from www.ebt-now.com http://www.ebt-now.com ============================================================== 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: -- Little-known feature of the CPYFRMIMPF command 1. Answers to Other Technical Questions: - There's a problem with the CPYFRMIMPF command - Transferring data from an Excel spreadsheet to the iSeries - Transferring spreadsheet data with blank cells to DB2 - Working with the CPYFRMIMPF command 2. Important Announcements and Links - Tips Contest: January winners announced - January 2003: Search400.com Month in Review - New Glossary: iSeries acronyms and terms defined - Advice: Programmer Discussion Forum _______________________________________________________________ ************ SPONSORED BY VeriSign - The Value of Trust ******* FREE E-COMMERCE SECURITY GUIDE Is your e-business built on a strong, secure foundation? Find out with VeriSign's FREE White Paper, "Building an E-Commerce Trust Infrastructure." Learn how to authenticate your site to customers, secure your web servers with 128-Bit SSL encryption, and accept secure payments online. Click here: http://search400.com/r/0,,10186,00.htm?freeguide ============================================================== Today's Featured Tip ============================================================== Little-known feature of the CPYFRMIMPF command When you're importing delimited data to the iSeries, such as a comma-delimited spreadsheet or data from a Unix or Windows NT system, the CPYFRMIMPF command is a huge timesaver. But even with this command, people still complain about null data, errors or formatting problems. Many are not aware that the CPYFRMIMPF command is also capable of helping with some of those types of problems. People overlook this capability because they don't know the functionality is there, and that's probably because of how the command does prompting. This tip highlights of few of the problem areas this command can help you with. >> CLICK here for the full tip: http://www.search400.com/tip/1,289483,sid3_gci879867,00.html ============================================================== Answers to Other Programmer Questions ============================================================== There's a problem with the CPYFRMIMPF command A user needed help getting some records in a CSV file written to an error file. Nothing he did seemed to work. Fortunately, site expert Tim Granatir had an idea. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid458659_tax285217,00.html Transferring data from an Excel spreadsheet to the iSeries "Widge" asks, "What's the best method for transferring an Excel spreadsheet to a PF on the 400. I have tried to download an existing file from the 400 and editing this in the spreadsheet, but when I try and send it back to the 400 the error message states the file must be an .fdf file." Several other users offered their preferred methods, including using the CPYFRMIMPF command, Client Access and a couple other products. http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/1700 Transferring spreadsheet data with blank cells to DB2 If you have to import a spreadsheet to your iSeries that is in .CSV format, you can use CPYFRMIMPF. However, this command will not work if any of the fields in the .CSV file are blank or zero. To get around this limitation, Search400.com member Francis Lapeyre shows you how to get around this limitation. http://search400.techtarget.com/tip/1,289483,sid3_gci756083,00.html Working with the CPYFRMIMPF command "Louielouie" is using V4R4 and is trying to use CPYFRMIMPF to import data from a '~' delimited file into a non-keyed physical file. He ran into a little trouble and turned to the Search400.com Programmer Discussion Forum for advice. A few members had some suggestions. Read what they had to say. http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]^[email protected]/1021 ______________________________________________________________ ********************** SPONSORED BY ebt-now ******************* QuickWebServices creates custom iSeries WebSphere, WebFacing apps - We plan, engineer, build, implement, train, support your solutions - Save money, time, mistakes, add more value with our custom Web apps - Contact mailto:[EMAIL PROTECTED] for your FREE, CUSTOM Web plan _______________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JANUARY WINNERS ANNOUNCED | Search400.com tips contest The wait is over and the results are in... Please join us in congratulating Herb Bujak. Herb's tip came in first place in the Search400.com's Tips Contest for January. Herb won a hand-held color TV and was added to our Hall of Fame for his tip: Yet another SQL program. http://www.search400.com/tip/1,289483,sid3_gci873216,00.html Congratulations also to our runner-up winners: Jean-Marie Sauvageot, Jean McMillan and Shyla Kumar-Thadikamala. View all winning tips in Search400's Hall of Fame: http://search400.techtarget.com/tipsHallOfFame/0,289489,sid3_prz826588_cts826578,00.html NEW CONTEST FOR FEBRUARY: This month we're giving away a Swing Groover II electronic golf coach and analyzer. The electronic driving range improves your game with feedback on accuracy, distance and club head speed. You can practice and improve your full-swing golf shots with every club. Choose fairway lie or tee up at your preferred height, view the tethered ball's virtual flight and landing in "real time." The LCD displays each club's "average" and "best" distance and speed. Send in your tip -- you could be our next winner. >> SUBMIT a Tip: http://search400.techtarget.com/tipsSubmit/1,289485,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SEARCH400.COM MONTH IN REVIEW | January 2003 It was a busy month with lots of news from IBM and nearly 30 tips submitted by members. Didn't catch it all? We have everything right here. >> CLICK here to review: http://www.search400.com/originalContent/0,289142,sid3_gci878871,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- NEW ISERIES GLOSSARY | Search400.com There are so many iSeries acronyms and terms and so little time to figure them all out. Search400.com has gathered and defined some of the industries top used acronyms and terms to help you stay abreast of the older -- and upcoming -- lingo out there. If you're puzzled by a term not seen here, please e-mail us at mailto:[EMAIL PROTECTED], and we'll add the definition to our list. >> CHECK out the glossary: http://search400.techtarget.com/glossaryPage/0,294242,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. http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636 >> RECENT Discussion threads you may find of interest: * Overlay with two display files http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/3260 * Receive SMTP mail into a program http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/3248 ______________________________________________________________ :::::::::::::::::::: 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 2003, 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."
