Kbase P147956: DB2/400 native trigger is not firing when ODBC DataServer application insert, update or delete recor
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/08/2009 |
|
Status: Unverified
SYMPTOM(s):
DB2/400 native trigger is not firing when ODBC DataServer application insert, update or delete records on the table
The DRDA server (QRWTSRVR) job log shows the following error:
File <PF file name> in library *LIBL not found or inline data file missing.
FACT(s) (Environment):
The trigger is firing fine but the physical file the trigger writes to not found
Windows
IBM AS/400 (RISC)
OpenEdge 10.x
ODBC DataServer
CAUSE:
The user profile does not have the library in its the library list where the physical file resides that trigger file writes to
FIX:
There are two workarounds to resolves the issue:
1. Add the library on the USRPRF on the AS/400 so the physical file is being found when trigger is fired
Or,
2. Follow the solution P135678 and use RUN STORED-PROC from ABL to submit OS/400 native command (ADDLIBLE <library name>) to add library at the beginning the ABL session so on the same session when the a record is created/updated/deleted, the trigger will fire and the DRDA server job can find the file in the added library on the library list.