January 2022

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…

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…
© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain