AS400 and SQL Tricks

Handling NULL values in DB2 for i SQL NULL value means that there is no value present for the column in a row in table. It is an unknown value. We…

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…

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 Introduction This article contains the SQL trigger that will be executed on multiple actions on the t…

OF Clause in SQL Trigger Introduction This article will explain the working of OF clause in the SQL trigger and how to execute the trigger dependi…

Conditional SQL Trigger Example Introduction This article will explain a conditional SQL trigger example. Below are the table structures that will…

Simple SQL Trigger Example Introduction This article will explain a simple SQL trigger example. Below are the table structures that will be used i…

Stored Procedure calling in SQL Trigger Introduction This article will explain the execution of stored procedures through SQL Trigger. Below are t…

Change Row Before Inserting In Table (Before SQL Trigger) Introduction This article will cover the changing of the columns in the current row befor…

Trigger Limitations and Program Attributes This article has some basic information related to triggers and trigger programs.  Trigger Program Attri…

INSTEAD OF SQL Trigger (Adding/Deleting/Inserting record in the table through SQL View) Introduction This article will explain the use of INSTEAD O…

Self Referencing SQL trigger Introduction This article will explain the self-referencing SQL Trigger Below are the table structures that will be us…

Error Handling in SQL Trigger Using Signalling Introduction This article will explain the error handling in SQL trigger using Signalling. Below a…

Transition Tables in SQL Triggers Introduction This article will explain the transition table created during the execution of triggers and one can…