9.47 DELETE_TRIGGERS
Þ Note: Built-In Function Rules.
Deletes standard DICTIONARY or FILE level triggers from a nominated field for subsequent replacement by the PUT_TRIGGER Built-In Function.
When deleting FILE level triggers from a field, the file involved must have been previously placed into an edit session by the START_FILE_EDIT Built-In Function.
Normal authority and task tracking rules apply to the use of this Built-In Function.
Þ This is a Specialized Built-In Function for use in a Development Environment only.
For use with
|
LANSA for i
|
YES
|
Do not use on IBM i in an RDMLX partition.
|
|
Visual LANSA for Windows
|
YES
|
|
|
Visual LANSA for Linux
|
NO
|
|
|
Arguments
|
No
|
Type
|
Req/ Opt
|
Description
|
Min Len
|
Max Len
|
Min Dec
|
Max Dec
|
|
1
|
A
|
Req
|
Level of triggers that are to be deleted.
D = Dictionary level
F = File level
|
1
|
1
|
|
|
|
2
|
A
|
Req
|
Name of field in dictionary or file from which triggers are to be deleted.
|
1
|
10
|
|
|
|
3 *
|
N
|
Req
|
Sequence number to control deletion. Only triggers with a sequence number greater than or equal to this value are deleted. If this argument is not specified, a value of zero (0) is assumed, so all triggers will match this control value.
|
1
|
3
|
0
|
0
|
|
4 *
|
A
|
Req
|
Generic description of trigger used to control deletion. Only checks which have a description generically matching this value will be deleted. If this value is not specified, a default value of blanks is assumed, so all checks will match this control value.
|
1
|
30
|
|
|
|
* The deletion control sequence number and description are related by an "AND" relationship. So if you pass values of 500 and 'IEW', only triggers that have a sequence number greater than or equal to 500 and a description that starts with 'IEW' will be deleted.
Return Values
|
No
|
Type
|
Req/ Opt
|
Description
|
Min Len
|
Max Len
|
Min Dec
|
Max Dec
|
|
1
|
A
|
Req
|
Return code
OK = validation check defined
ER = fatal error detected
NR = no records found eligible for deletion
In case of "ER" return code error message(s) are issued automatically. When a file edit session is involved it is ended automatically without commitment.
|
2
|
2
|
|
|
|