Kbase P50178: Os Escape within trigger causes "4gl action 11 , trigger may
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2003 |
|
Status: Unverified
FACT(s) (Environment):
MERANT 3.70 32-BIT Progress SQL-89
SYMPTOM(s):
Write trigger fired through ODBC fails.
4GL action <type> (<procedure>:<line>) may not be executed by this image. (3170)
4GL action 11 , trigger may not be executed by this image (3170)
Write trigger performs the UNIX touch command.
Trigger can be run through the procedure editor.
CAUSE:
Touch command is a 4GL Operating System escapes.
FIX:
Unix "Touch" command is an invalid 4GL statement for the ESQL client and the prooidv process is an ESQL client.
In order to perform an OS escape from a trigger create an external DLL (shared library) that performs the desired os command and call that DLL from the trigger procedure.
If the desired operation is the output of something, perform a write information in some records and then with another procedure running in the batch mode read these records and output that information to the file.