=========================================================== SEARCH400.COM | Programmer Tip Sept. 24, 2003 =========================================================== FROM OUR SPONSORS:
Secure AS2/EDI-INT Sponsored by Patrick Townsend & Assoc http://search400.com/r/0,,18820,00.htm?patricktownsendassoc Free E-Commerce Security Guide http://search400.com/r/0,,18787,00.htm?verisign ===================================================================== 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: -- Where does the 01-01-0001 default date come from? 1. Answers to Other Technical Questions: - Using date data-type fields in RPG IV - Working with date and timestamp in DB2 - Using RPG/400, convert a date from MMDDYY to YYMMDD - iSeries IFS file creation date 2. Important Announcements and Links - User Poll: Experiencing problems with IBM billing? - Book Excerpt: Subfiles in RPG IV - Advice: Programmer Discussion Forum ___________________________________________________________________ ************ SPONSORED BY Patrick Townsend & Assoc **************** SECURE AS2/EDI-INT Alliance AS2 Integrator is a native AS/400 solution for the secure exchange of EDI and other files using EDI-INT with the AS2 standard. You can automatically send and receive files with multiple trading partners. Alliance integrates easily with EDI translators like Inovis TrustedLink, Sterling Gentrans, Extol, and the optional Alliance EDI and XML translator products. http://search400.com/r/0,,18820,00.htm?patricktownsendassoc ==================================================================== Today's Featured Tip ==================================================================== WHERE DOES THE 01-01-0001 DEFAULT DATE COME FROM? You're working on a program written in RPG IV when you notice the date of 01-01-0001. "Wait a minute," you say. "How did that get there when I didn't enter anything?" The answer lies in the requirements of DB2 and the function of date data types. >> CLICK here for the full tip: http://www.search400.com/tip/1,289483,sid3_gci928844,00.html =================================================================== Answers to Other Programmer Questions =================================================================== USING DATE DATA-TYPE FIELDS IN RPG IV Date data types are incredibly powerful and flexible, but figuring out how to use them to do date format conversions can be frustrating. The key to understanding them: the date data-type field is in ALL formats. http://search400.techtarget.com/tip/1,289483,sid3_gci519460,00.html WORKING WITH DATE AND TIMESTAMP IN DB2 Is it possible for DB2/400 to automatically keep track of the timestamp when the record is inserted or updated? Site expert Kent Milligan explains. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid518958_tax288615,00.html USING RPG/400, CONVERT A DATE FROM MMDDYY TO YYMMDD Is there an easy way to convert a date in MMDDYY format to a date in YYMMDD format? Yes, says site expert Laird Scranton, and he provides a formula. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid372954_tax285217,00.html ISERIES IFS FILE CREATION DATE "Rajeev400" wonders if anyone knows the commands to find the creation date of an IFS file through the iSeries? He's running V5R2. "Chipster" had one suggestion, but "Rajeev400" is looking for an API. Do you know of one? http://search400.discussions.techtarget.com/[EMAIL PROTECTED]@.ee84636/4209 ___________________________________________________________________ ************ 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,,18787,00.htm?verisign ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TAKE OUR POLL | Search400.com Reader Survey When dealing with IBM, do you experience problems with billing? >> CAST your vote: http://search400.techtarget.com/#poll =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BOOK EXCERPT | Subfiles in RPG IV Log on and download for free Chapter 7 of Subfiles in RPG IV: Rules, Examples, Techniques, and Other Cool Stuff written by Kevin Vandever and published by MC Press. This chapter, "Subfiles and Data Queues -- A Perfect Combination," looks at how to incorporate all the features in the Program Development Manager (PDM) into a subfile application. >> DOWNLOAD the chapter: http://www.search400.com/whitepaperPage/0,293857,sid3_gci920707,00.html >> BUY the book: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=1583470034&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: * JAR command from QSHELL http://search400.discussions.techtarget.com/[EMAIL PROTECTED]@.ee84636/4297 * Copying Java files to IFS folder http://search400.discussions.techtarget.com/[EMAIL PROTECTED]@.ee84636/4285 ___________________________________________________________ :::::::::::::::::: 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. ___________________________________________________________ AMY PANZA, 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. ____________________________________________________________________ To unsubscribe from "Programmer Tips": Reply to this e-mail with REMOVE in the Subject line - OR - Go to unsubscribe: http://Search400.com/u?cid=468871 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.
