Informix Error -23753: Could not replace %r macro in filename entry.
Cause and resolution
Could not replace %r macro in filename entry.
An error occurred when the database server tried to expand the DATAFILES entries in an INSERT or SELECT statement for an external table. The error occurred when the database server tried to expand the %r macro in the filename. Check that the syntax for the %r() macro is correct.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23753 fires when the database server can't expand the %r macro in a DATAFILES
filename entry — per the official guidance.
- Incorrect
%r()macro syntax, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check that the
%r()macro's syntax is correct, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond incorrect %r() syntax.
Diagnostic Checks
- Check the
%r()macro's syntax in the flaggedDATAFILESentry, and correct it.
Related Errors / Related Topics
- -23758 — "Could not parse %r macro in filename entry." The same class of
%rmacro error, on parsing rather than replacement.
The %r macro in a DATAFILES entry couldn't be replaced — check its syntax.