October 19, 2016
• FEATURED ARTICLE: SQL 101: Tools of the Trade - Old, Reliable STRSQL, Part 1
• NEWS HIGHLIGHT: Kisco Announces New System Monitoring Tool for IBM i
• BUYER'S GUIDE: TLAForms
• EVENT: Work Smarter: Integrate IBM i and Desktop Applications
Written by Brian May
DBU - allows access to ALL data on ALL systems using ONE interface. Use DBU to access, analyze and secure data on all your servers. DBU for RDi now available!
RDB Connect - provides direct access to remote data (like MySQL, Oracle, etc.) from all high-level languages on the IBM i.
SQL/Pro - saves time/money by reducing workloads with fast/easy informational retrieval.
Increase productivity with these easy-to-use database utilities.
Your IBM i RPG applications are the lifeblood of your business. But with old-fashioned green-screens, they are the old brown shoes of your business.
ASNA Wings puts a modern Web user interface on your RPG applications quickly and easily. Wings quickly adds power and pizzazz to your IBM i RPG portfolio. Learn how in our free October 20th, 1pm CDT Webcast.
Now available at a special price! One of our most popular certification study guides, DB2 10 for z/OS Database Administration, prepares you for IBM Certification Exam 612 like nothing else can. This is a comprehensive review, written by two members of the test creation team, which walks you through all areas covered on the exam. You’ll get tips on working with DB2 for z/OS and new information about Version 10. Includes an 85-question practice exam complete with detailed answers.
This article kicks off a new subseries in which I’ll discuss a few tools at your disposal to write, validate, and run SQL statements. The first of the list is the Interactive SQL, better known as STRSQL.
Written by Rafael Victória-Pereira
Perhaps the most used (and certainly the oldest) tool to execute SQL statements is the green-screen Start Interactive SQL Session command, STRSQL. This command is somewhat similar to the QCMD command in the sense that it provides similar function keys.
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!