============================================================ SEARCH400 | Programmer Tip January 30, 2002
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: - Retrieve the IP address of an active device 1. Answers to Other Technical Questions: 1. Syntax check your SQL statements 2. Why is my RPGLE program blowing up? 3. SQLRPGLE -- SQL Statement Prompting 4. ISeries 400 bar code programming 2. Important Announcements and Links - Current Poll: A Linux-only iSeries server? - Advice: Programmer Discussion Forum - Featured book: Enterprise Java Programming - Search400 Search Engine: Find iSeries information fast _____________________________________________________________ **************** SPONSORED BY Aldon Computer Group ************** Whether you're a WebSphere expert or just getting started, Aldon Affiniti provides the BEST multi-platform change management system to streamline your WebSphere application development process. Aldon Affiniti manages Windows, NT, Unix and iSeries code in the same way, through ONE single graphical user interface. With Affiniti, you can leverage your legacy source code for e-business solutions. Learn more with a FREE online seminar at: http://ad.doubleclick.net/clk;3859403;5058249;q?http://www.aldon.com/cgi-bin/banner.pl?src=WS ======================================================= Today's Featured Tip ============================================================ Retrieve the IP address of an active device Have you ever wanted to know the IP address of a connected workstation? Well, the iSeries has an API that can get that for you. You may want to implement security schemes, add business rules, use different display files, etc. depending on the IP. By knowing all or even part of the IP address, you can control how your programs communicate with the device. The "QDCRDEVD" API retrieves information about a device description. This is simple to use and will return a host of information in addition to the IP address. Site expert John Kohan gives you the typical RPG IV call to the "Retrieve Device Description" API as well as information about the different formats in which information is returned. >> CLICK here for the full tip: http://www.search400.com/tip/1,289483,sid3_gci799055,00.html ============================================================ Answers to Other Programmer Questions ============================================================ 1. Syntax check your SQL statements SQL is a wonderful tool -- but a typo can burn us all. This tip will help to ensure you have correctly typed the SQL statements. You'll want to process via the RUNSQLTM command and use the RUNSQLSTM parameter PROCESS(*SYN) to first syntax check your statements. http://search400.techtarget.com/tip/1,289483,sid3_gci798016,00.html 2. Why is my RPGLE program blowing up? One user writes, "We are on V4R4, and the command I am using to copy a file that was FTP'd onto the iSeries 400 is not working. I want to place the data into a physical file on the iSeries. Does anyone know how this can be done?" Application development expert John Brandt offers some advice. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid432356_tax285217,00.html 3. SQL RPGLE -- SQL Statement Prompting This member is having difficulty with embedded SQL prompting. He finds every entry following C/ and C+ is treated by his editor as comments or free form? Can anyone help him out? http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]^[email protected]/1033 4. Help printing bar codes This search400 member said he needed help writing a program to print the values from a database file as bar codes and a scanner program. Click over to read the advice application development expert Tim Granatir had for him. http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]^[email protected]/1058 ======================================================== FREE SUBSCRIPTION TO STORAGE MAGAZINE ======================================================== Storage is now a front and center issue. No longer "just capacity," storage is a critical IT asset that must be managed effectively. Increasingly complex, it's become a huge percentage of your overall IT budget. That's why we created Storage magazine, a new resource to help you set your storage strategy, manage storage effectively, and make key vendor selection and architecture decisions. Subscribe today FREE and as a bonus you get the FREE 42-page Storage Networking special report! http://ad.doubleclick.net/clk;3802160;5058249;e?http://www.storagemagazine.com _____________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TAKE OUR POLL | search400 Reader Survey A Linux-only iSeries server? How interested are you? >> Cast your Vote: http://www.search400.com/poll =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 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]^[email protected] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- THIS WEEK'S FEATURED BOOK | search400's Bookstore Title: Enterprise Java Programming with IBM WebSphere Author: Kyle Brown, Russell Stinehour, Dr. Gary Craig, David Pitt, Greg Hester and Jaime Niswonger This hands-on guide delves into Java 2 Enterprise Edition (J2EE), servlets, JavaServer Pages and Enterprise JavaBeans. It provides techniques for an efficient e-commerce solution. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=0201616173&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SEARCH400 SEARCH ENGINE | Find iSeries information fast Is Google one of your favorite search tools? We've partnered with Google to make our iSeries-specific search engine even better. Why waste time slogging through irrelevant search results? Try our newly tweaked search engine for the most targeted iSeries results. >> Search Engine: http://search400.techtarget.com/integratedSearchAdvanced/0,289518,sid3,00.html ____________________________________________________________ ::::::::::::::::::: SEARCH400 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. ____________________________________________________________ KATE EVANS-CORREIA, News Editor (mailto:[EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. ____________________________________________________________ GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ____________________________________________________________ **********************ABOUT THIS NEWSLETTER****************** Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://search400.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
