StarQuery for JDE is a BI solution that queries JDE ERPs using MS Excel. Join us July 13th and learn how to simplify your JDE DB and empower users to create queries for themselves. JDE database challenges such as meaningless field names and unfamiliar date formats are automatically corrected by SQ for JDE.
This command can support an extensive list of trim characters.
Written by Bruce Vining
In the previous article, "Cut, Snip, Trim with TRMLFTCHR," we saw how the Trim Left Characters (TRMLFTCHR) command could allow the user to specify what leading character to trim when left-adjusting a character string value. Today, we will see what is required to have TRMLFTCHR trim any number of various leading characters from an input string of any length, left-adjust the remaining characters, and then pad the returned character string with blanks to its declared length.
Upgrade your skills — and discover new ways to leverage the amazing IBM i — at the next RPG & DB2 Summit. Learn practical, use-it-today tips and techniques and get 1-on-1 advice from top experts Paul Tuohy, Susan Gantner, Jon Paris, Skip Marchesani, Scott Klement and others in a highly interactive, invigorating, fun environment. Hear the latest on RPG IV, DB2, embedded SQL, RPG & the Web, PHP, RDi, SQL tuning & more. Click to see the sessions!
With free, new, easy-to-use interfaces, access to cloud storage services is as simple as using Windows Explorer.
Written by Chris Smith
Because there can be a profound economic benefit, cloud computing is here to stay, and for those of us wishing to extend our little toes into the ethereal blue haze, there may be no better tool to start the flight into the wild blue yonder than CloudBerry Explorer.
Grant varying levels of IBM i security to different interfaces.
Written by Robin Tatam
Do the majority of your users have access to your critical data? Do you still rely on menu and command-line restrictions for security? Can you monitor network access attempts? Is your security program flexible enough to restrict access to individual objects?