IBM i and OpenSource: Faq & Howto (Part 1) IT
22 March 2020
First steps with Node.js and Python in IBM i environment; recall of programs from QSH and management of messages from QSH; PASE default shell setting
---
Roberto De Pedrini
Faq400.com
DB2 for i & SQL - FAQ & Howto (Part.2) (IT)
15 March 2020
CSV and SQL, regular expressions, dates and timestamps sql, CLOB and IFS, SQL Dynamic Compound Statement, How to deal with Null Values, Merge to do Upsert in your tables
---
Roberto De Pedrini
Faq400.com
SQL - Audit trigger ... who moved my cheese!
13 March 2020
How to create a simple trigger to AUDIT a table: who and when to insert, delete and modify certain fields of my table?
We activate the trigger even if the file is in use, with this trick by Scott Forstie.
---
Roberto De Pedrini
Faq400.com
Get Euro Exchange Rates from ECB/BCE WebService
3 March 2020
Some of my clients every day or every week load Exchange Rates into ERP’s exchange tables: with a few lines of code we can get rates from ECB (BCE) through their Web API directly from…
---
Roberto De Pedrini
Faq400.com
SQLCODE: LET'S USE IT WELL
3 March 2020
SQLCODE is often used incorrectly … if nonzero it is not always an error … only negative values indicate a real error … let's see some small examples.
WHEN QTEMP IS NOT ENOUGH
28 February 2020
Talking about /tmp directory, something like our QTEMP but with some differences.