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.
IBM i - Beware of "shares" (IFS and Ransomware)
28 February 2020
Viruses and malware in general, such as ransomware, can also damage IBM i if they find shared directories in the IFS!
---
Roberto De Pedrini
Faq400.com
