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.
Naming SYS vs SQL how many differences
1 January 2020
SQL has become the industry standard for all relational DBs, both for defining databases and for accessing database objects. “DB2 for i” is the only database integrated directly into the operating system and at the…
ACS 1.1.8.3 SQL Script Assistant! (Video)
22 December 2019
The latest version of ACS Access Client Solution 1.1.8.3 has been released for a few days with interesting news in various areas … if you still don’t use ACS and you’re stuck with the old…
---
Roberto De Pedrini
Faq400.com
Smarter SQL functions with control statements
1 December 2019
With some SQL special statements we can build a function so that it can perform business logic as in a “real” program written in a structured language. Let’s see how !
Up and down (EN)
30 November 2019
When did our IBM i shut down and last? And how long did it take to go out and turn on?
In this article I suggest a simple API and some ready-to-use SQL statements to extract information about the last shutdown and power-up of IBM from the system
This information is contained in various "angles" of our operating system (system values, system operator messages, history logs, …). With a few SQL statements we display them all together.
Utility XSQL :"Compile" SQL objects into desired library - Part.2
3 November 2019
In the first “episode” of this article we learned how to create into a specified library an object built from an SQL script. Here we present a free tool that allows you to run SQL scripts with embedded variables !
"Compile" SQL objects into desired library - 1
20 October 2019
In SQL scripts for DDL-defined objects (tables, views, indexes, etc.) it is not good to explicitly specify library names. We provide here a small utility command that allows to “compile” all the objects defined with SQL script specifying the destination library.
