============================================================== SEARCH400.COM | Programmer Tip July 30, 2003 ============================================================== FROM OUR SPONSORS:
Unifying Software Development Teams - A Free White Paper http://search400.com/r/0,,16686,00.htm?aldon ============================================================== 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: -- The proper way to transfer data to the iSeries 1. Answers to Other Technical Questions: - The new AS/400-to-PC transfer request - Transferring DB2/400 data from the iSeries - Answers to your questions on FTP - Transferring data from an AIX box to the iSeries 2. Important Announcements and Links - Expert Profile: John Brandt, Search400.com expert - Book Excerpt: JDBC: Database Programming with J2EE - Advice: Programmer Discussion Forum _________________________________________________________________ ********************** SPONSORS BY: Aldon *********************** Unifying Software Development Teams - A Free White Paper Want to learn about Source Development Management and its importance to development teams? Want to know how to manage WebSphere and Java Development in any environment? In this paper, learn from Aldon, the software development management leader, how to provide a complete multi-environment SCM solution for development, supporting the iSeries and all other platforms. To get your free white paper, click here: http://search400.com/r/0,,16686,00.htm?aldon ================================================================== Today's Featured Tip ================================================================== The proper way to transfer data to the iSeries by Ken Dafoe Most users want to pull data down from their iSeries. Those who want to push data back usually require specific clearance from IT. IT is leery of users returning data to their iSeries systems, and rightly so. Any time a file is changed on the iSeries without an audit trail of the changes, IT becomes nervous. What do you do if you need to return data to the iSeries? Here's a step-by-step guide. >> CLICK here for the full tip: http://www.search400.com/tip/1,289483,sid3_gci912991,00.html ================================================================== Answers to Other Programmer Questions ================================================================== THE NEW AS/400-TO-PC TRANSFER REQUEST The data transfer component of Client Access has come a long way since the early years of PC Support. First and foremost, it is now fronted with a GUI interface. But much more than that are the great improvements made to the data selection and output format options. http://www.search400.com/tip/1,289483,sid3_gci859872,00.html TRANSFERRING DB2/400 DATA FROM THE ISERIES A Search400.com member says he wants to transfer DB2/400 data from the iSeries system to DB2 on a Linux server, but he isn't sure if any conversion is required. Site expert Kent Milligan offers some advice. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid534766_tax285216,00.html ANSWERS TO YOUR QUESTIONS ON FTP Chris Peters, guest speaker from last year's webcast "FTP fundamentals for the iSeries," fields questions from Search400.com members. http://search400.techtarget.com/tip/1,289483,sid3_gci835013,00.html TRANSFERRING DATA FROM AN AIX BOX TO THE ISERIES A Search400.com member says he needs to transfer data from an AIX box to the iSeries. He has been able to do this using interactive SQL with DRDA. What he wants to do is create code to run this transfer in batch, but he can't figure out how to control or specify session attributes to write to an outfile on the local database. Site expert Kent Milligan has a suggestion. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid526483_tax285216,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= EXPERT PROFILE | John Brandt, Search400.com expert John Brandt is vice president of technical services at iStudio400.com, an IBM business partner. He has six years' experience working on System/38, 12 years' experience working on the iSeries 400, 21 years' experience with PCs and 12 years' experience with PC servers. In addition, John has worked on software development, maintenance and distribution. Languages he's familiar with include RPG, ILE, CL, COBOL, Java and JavaScript. John also has extensive experience with networking and systems management. You name the iSeries subject, OS/400, Application Development, Backup and Recovery, DB2/400 and DB2 UDB, and John can answer almost any question about it. Let John's experience work for you. Ask John your questions anytime. >> CLICK HERE TO ASK John an application development question: http://search400.techtarget.com/ateQuestion/0,289624,sid3_cid371927_tax285217,00.html >> CLICK HERE TO READ John's recent Q&A's: http://search400.techtarget.com/ateAnswers/0,289620,sid3_cid371924_tax285217,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BOOK EXCERPT | JDBC: Database Programming with J2EE Log on and download for free Chapter 1 of JDBC: Database Programming with J2EE written by Art Taylor and published by Prentice Hall PTR. This chapter focuses on JDBC design, how Java works with relational databases, the JDBC API and more. >> DOWNLOAD the chapter: http://search400.techtarget.com/whitepaperPage/0,293857,sid3_gci914472,00.html >> BUY the book: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=0130453234&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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/[EMAIL PROTECTED]@.ee84636 >> RECENT Discussion threads you may find of interest: * Optically archived SCS spool files http://search400.discussions.techtarget.com/[EMAIL PROTECTED]@.ee84636/4087 * Returning multiple variables from subprocedures http://search400.discussions.techtarget.com/[EMAIL PROTECTED]@.ee84636/4076 ______________________________________________________________ :::::::::::::::::::: 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. ___________________________________________________________ JILLIAN CORBY, sales representative (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: This newsletter is published by TechTarget, the most targeted IT media. http://www.techtarget.com Copyright 2003 TechTarget. All rights reserved. Unsubscribe from 'Programmer Tips' - Simply Reply to this E-mail 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."
