SQL stored procedure in IBM i
SQL Stored Procedure in IBM i What is SQL stored procedure in IBM i? The stored procedure in IBM i is the type of program which is written to perf…
January 2022
Compiler Directive in RPGLE AS400
Compiler Directive in RPGLE AS400 Compiler Directive The compiler directive statements /TITLE, /EJECT, /SPACE, /COPY, and /INCLUDE allow us to…
QSQGNDDL API - IBM to convert DDS file into DDL table
QSQGNDDL API - IBM to convert DDS file into DDL table In the previous articles, on DDS to DDL conversion, it is explained how we can convert a DDS …
Identity column in DDL table
Identity column in DDL table Identity Column The identity column in the DDL table is a column that can be auto-populated by the system. In most cas…
SQL Triggers concept in IBM i DB2
SQL Triggers concept in IBM i DB2 Introduction Triggers provide the way to monitor, alter, and manage the tables when any insert, delete or add ope…
Syntax for Create Trigger in IBM i AS400
The syntax for Create Trigger in IBM i AS400 This article will have the syntax for creating SQL triggers using CREATE TRIGGER statement. Syntax F…
Multiple Event Execution Through SQL Trigger
Multiple Event Execution Through SQL Trigger Introduction This article contains the SQL trigger that will be executed on multiple actions on the t…