What are Triggers?
Answer Posted / bala
Triggers are special kind of stored procedures that get
executed automatically when an INSERT, UPDATE or DELETE
operation takes place on a table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)
what are the important factors in error message subfile ?
how to toggle between single line and multi - line display of a particular record in a subfile?
Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP
how can u check no of records in a file?
What Is Ddm ?
how you will find an error which is not in the first page of the subfile without using rolldown key?
name few ibm supplied libraries?
how to run other job when one job is active?
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
what is sflinz and sflrna?
what is the sequence when using cursor?
how many maximum spaces could be given in o specs?
what is the difference between normal upddta to pf and updating using dfu program?
how may a cgi control duplicate inputs?