January 4, 2017 | Volume 16 Issue 1
• LEAD ARTICLE: Practical SQL: Field Reference Files in DDL
• FEATURED ARTICLE: RPG Academy: Write Better Code - More on Commenting and Documenting Strategies
• NEWS HIGHLIGHT: New Bluemix Services with GitHub and Slack Integration
• BUYER'S GUIDE: TLAForms
• EVENT: Stop Re-keying Data Between IBM I and Other Applications
SQL does field reference files, too!
Written by Joe Pluta
In a previous article, I discussed how naming conventions really help in database design and programming, and in so doing I touched upon the concept of the field reference file. Field reference files are an easy way to make sure your data elements are consistent, but I'll bet you didn't know you could use them in DDL as well. In this article, I'll show you how it's done.
The time is NOW to get the top books for tech professionals at our lowest prices ever!
Pay only $35 each for our newest titles! You save a whopping 40% to 70% off the regular price.
9 of our best titles for just $25 each! Perfect gifts for your favorite Power Systems pro! Treat yourself or a colleague!
10 titles 70-85% Off. Get your copies today! Pay just $15 each for popular books on RPG, PHP, Java, Project Management, DB2, and more. Don’t wait – at these prices, books will sell out soon!
19 books for $10 each Buy them ALL for less than $200. Select every one or just a few before they're gone!
Give the Gift of Knowledge: Over 50 titles for $5 each! RPG, IBM i, Security, PHP, Programming, DB2, Analytics, and more. Shop now—at these prices, books are going fast!
An old dog can learn new tricks! Flexible Input, Dazzling Output with IBM i is full of clever ways to get data into your IBM i system, as well as new techniques to export and present this data in a modern, business-friendly manner. No more boring spreadsheets or ugly printouts! Your DB2 data will look great in program-generated spreadsheets and browser-based, interactive charts. Whether you’re an old dog or not, you’ll get the most out of your ILE RPG programs with the open source, free tools in this smart new release! Order your copy today!
Just $25 during the MC Press New Year Knowledge Sale!
This ain’t your mama’s RPG! Time to move on from OPM—with Evolve Your RPG Coding. This comprehensive new book gives you all the tools to move to a more modern, modular, and efficient ILE RPG. The book guides you through the transition at a comfortable pace, making every ILE concept totally accessible. You’ll start with simple, easy-to-understand examples and analogies to OPM, then advance to complete and complex ILE code. Finally, you’ll go beyond ILE with a detailed discussion of SQL, code organization, and structure. Pre-order your copy today!
Just $35 during the MC Press New Year Knowledge Sale!
This TechTip will continue to discuss the documentation topic, focusing on the tools that an RPG programmer has available and offering a few tips to help define a proper documentation strategy (even if you think you don’t need one).
Written by Rafael Victória-Pereira
One of my favorite things about “modern” languages is the self-documenting features that most of them have. For instance, Java has Javadoc, a documentation generator from Oracle Corporation that is designed to automatically produce documentation in HTML format from Java source code. The HTML format is used to add the convenience of being able to hyperlink related documents together. The “doc comments” format used by Javadoc is the de facto industry standard for documenting Java classes. Some Integrated Development Environments (IDEs), such as NetBeans and Eclipse, automatically generate Javadoc HTML code. There are a lot of file editors to assist the developer in producing Javadoc source and using the Javadoc…
TLAForms by TL Ashford converts your traditional IBM i spool files into high quality, professional forms.
Use a GUI Designer to create forms using data from a spool file and data from your IBM i files. Forms can be designed with true-type fonts, bar codes – including QR Code and Datamatrix, color images, overlays, lines, boxes and ellipses all in full color.
The software generates your forms as PDF documents that are archived to the IFS, automatically emailed and/or printed. Forms can be printed to IBM i PostScript printers, any printer connected to the network, or any printer connected to a PC. IFS locations, email addresses, and printers can be variable based on data within the spool file, data within the IBM i file or spool file attributes.
No programming is required to generate the new forms from your existing ERP, WMS or in-house application software.
The experienced TL Ashford technical support team will provide any pre-designed templates like the VICS Bill of Lading, and make sure working with the software is as easy and productive as possible!