QDBRTVFD API changes
Retrieve Database File Description (QDBRTVFD) API might return 0 offsets and lengths for a CREATE TRIGGER statement.
IBM® i 7.2 provides support
for obfuscated SQL statements, where the details of the CREATE TRIGGER
statement that defines an SQL Trigger are not available. The Retrieve
Database File Description (QDBRTVFD) API provides
offsets into a CREATE TRIGGER statement. If the trigger was created
with obfuscation, then field Qdb_Qdbftrg_Stmt_Crt_Trg is unreadable
and these offsets and lengths within Qdb_Qdbftrg_Stmt_Area contain
a value of 0:
- Qdb_Qdbftrg_Stmt_Onfile_Off
- Qdb_Qdbftrg_Stmt_Onfile_Len
- Qdb_Qdbftrg_Stmt_When_Len
- Qdb_Qdbftrg_Stmt_When_Off
- Qdb_Qdbftrg_Stmt_Body_Len
- Qdb_Qdbftrg_Stmt_Body_Off