Writing messages to the job log with SQL
9 May 2020
LPRINTF is a simple utility that allows you to write messages in the current job’s log, directly with SQL. Let’s see when it can be useful!
Who's calling my program ?
8 April 2020
Sometimes you may need to know which program has called the program that is currently running. With SQL and DB2 services, knowing that it is very easy!
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
Exploring the IFS with DB2 services
23 February 2020
The numerous DB2 for i services recently have been enriched with a new category, that allows you to poke around in the IFS directly with SQL
Masking sensitive data with DB2 and SQL
24 January 2020
Carnival is still a few weeks away, but for SQL and DB2 it’s always time for masks! Let’s see how to implement the column-level masking functions with simple SQL statements.