Answer Posted / sujanindian

Triggers is a self contained set of transact executable
statements which can be invoked during the operations such as
insert,update,delete can be performed in a database file.
We can able to add trigger in a physical file :
ADDPFTRG
to remove a trigger : RMVPFTRG

In the case of SQL/400 we can create trigger by ....

>>STRSQL
>>CREATE TRIGGER TRG_Name
after INSERT/DELETE/UPDATE On PF1
Insert Into PF2 Values ('RECORDS DELETED IN PF1')
>>Delete FROM PF1 Where Recordno = 10
>>SElect * FROM PF2.

In the above code, the records in the PF1 is deleted , at
once the trigger trg_name is fired and the given insert
statement is activated in pf2.

What is file access opcodes?

1357

---

What are the types of data structure in as400?

1035

---

how to write *pssr ?

1071

---

when should I use method get, and when should I use method post in my cgis?

1136

---

what are indicators?

1045

---

what does check opcode do ?

1862

---

where can you specify an indicator in lokup operation?

1811

---

what is message subfile?

1738

---

how many files can be defined in f specs?

2365

---

how do you specify page overflow indicator for printer files in rpg?

2280

---

what are the different types of data areas?

1740

---

what is service program?

1034

---

how does union file maintains record formats?

1102

---

is it there an easy way to determine if an html section is available to issue a wrtsection upon?

976

---

What Does Lokup Does In Tables & Arrays?

1271

---