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.Dettagli
If you want understand Temporal Tables, take a look at those 2 posts by Andy Youens at PowerWire.eu :
To improve IBMi performance take a look at this guide:
Yes you can ! You can go to IBM RFE Community (Request for Enanchement) and add your request or vote for other’s requests …. Here’s some example … but follow the link to the updated list DB2 service for IFS listing I’d like to be able to get a list of IFS files within a directory using…Dettagli