Answer / johnson m

Trigger is an action.It automatically invoked when specified
operation(delete,update,insert) takes place specified
time(before or after) in the physical file(database file).

Answer / vishal rajput

trigger is nothing but a event.

Answer / aditya

Triggers are the programs need not to be run explicitly.
The functionality should be embeded in driver program and
as the driver program runs the trigger gets executed
automatically.

Answer / pankaj

SMALL PROGRAMM TO AVOID THE ERROR .

what is the command to know how many lf are related to a pf?

1 Answers   IBM,

---

what is the difference between udate and the system date?

1 Answers   IBM,

---

What is Data Area?

1 Answers  

---

I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.

0 Answers   HSBC,

---

what are two types of record are used in subfile?

1 Answers   IBM,

---

What are the functions of Remote Job Entry (RJE) ?

1 Answers  

---

How to add 99 menu (page down) option in menu creation..

0 Answers  

---

what is *iso date format?

0 Answers   IBM,

---

How can we find from which source the program has been compiled for a given RPGLE program object?

5 Answers  

---

what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why should we use SHARE(*YES)

2 Answers   IBM,

---

when would you use or not use this approach?

1 Answers   IBM,

---

Why do you use Keep and Assume Keywords.

2 Answers   Four soft,

---