RPG Academy: Write Better Code — Choosing Appropriate Names for Variables, Procedures, and Functions | RPG
RPG Academy: Write Better Code — Choosing Appropriate Names for Variables, Procedures, and Functions
SQL 101: Date-Related Functions, Part 2—Time-Saving Functions
Use SQL Embedded to handle Dates and Time in your SQLRPGLE code.
Thanks to Rafael Victoria-Pereira
I’ve got an IFS directory with a lot of CSV / TXT files for ERP-Ecommerce integration for one of my customer who, sometimes, has to search a string in all that files. Now he use Microsoft Windows Search utility but ask me for an utility from IBMi.
Googling csv, IFS and SQL I stumbled upon two awsome utilities:
I downloaded this two utilities, generate two UDF e build a little app who get string, filename, path in input and return an array with filename, filedate, rows with my string.
If you want understand Temporal Tables, take a look at those 2 posts by Andy Youens at PowerWire.eu :
Look at this Youtube Video by Sumit Goyal … he created an utility to generate RPG code and DSPF from a free SQL statement on any of your tables …
Download a SAVF from the link at this page : https://youtu.be/uohY9uGazfw
Nice job Sumit !