user-defined functions (UDFs) on IBM DB2 for i SQL- Introduction to UDFs

Work with Global Variables in DB2 for i SQL (AS400 to IBM i)

Db2 for i Temporal Tables

Creating Table using LIKE in IBM i SQL DB2 (AS400)

LOCATE and POSITION in IBM i SQL DB2 AS400 | Locate and position in SQL

Obfuscating an SQL routine or SQL trigger

multiple event trigger in IBM i DB2 AS400 (INSERT, DELETE, UPDATE)

SYSROUTINE – SYSPROCS – SYSFUNCS in IBm i DB2 AS400

DB2 SQL UDTF – Create SQL UDTF to Retrieve Column details of a table in IBM i AS400

Using DB2 SQL UDF with RPGLE – Different ways to call UDF from RPGLE in AS400

Using Cursor in SQL Stored Procedure in IBM i DB2 AS400-DECLARE CURSOR,PREPARE,OPEN

SYSFUNCS catalog on IBM DB2 for i SQL

Creating a IBM i DB2 Web Report from a Query/400 Definition

Error Handling in SQL UDF in DB2 for i SQL

Creating and using sequences in IBM i SQL DB2(AS400)

SQL Stored Procedure in IBM i DB2 AS400 – Conditional statement (CASE, IF THEN ELSEIF ELSE ENDIF)

Declaring a global temporary table in IBM i SQL DB2(AS400)

How to fetch nth row in a file in SQL|DB2|SQL Tips

IBM DB2 Joins – (Inner, Left,Right, Full outer join)

Create SQL Table in IBM DB2 AS400|SQL Tips

How to check object lock information in DB2 Catalog | Object lock in AS400

SYSTABLES in DB2 | Catalog table SYSTABLES in DB2 AS400

How to install,configure and use MariaDB on the IBM i

Error Handling in SQL Stored procedure in IBM i DB2 AS400 – Using SQLCODE and SQLSTATE in SQL DB2

DB2 Interview questions and answers

Recursive CTE in IBM DB2 with Example-Recursive SQL

User-defined scalar functions (UDFs) on IBM DB2 for i SQL

IBM DB2 CTE basic introduction and Examples

SQL Trigger update compare old and new values in DB2 IBM i AS400