Informix Error -23741: CREATE EXTERNAL TABLE: Invalid value for keyword.
Cause and resolution
CREATE EXTERNAL TABLE: Invalid value for keyword.
The CREATE EXTERNAL TABLE statement (or SELECT...INTO EXTERNAL statement) contains an invalid value for one of the USING clause keywords.
Review the statement to see if the value of the keyword is misspelled. For the MAXERRORS keyword, make sure the value is a valid number.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23741 fires when a USING-clause keyword is given an invalid value — per the official
guidance.
- A misspelled or otherwise invalid keyword value, per the official
guidance — the direct, only cause; e.g.
MAXERRORSmust be a valid number.
Solutions / Resolution
- Review the statement for a misspelled keyword value, per the official guidance.
- For
MAXERRORS, confirm the value is a valid number, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an invalid keyword value.
Diagnostic Checks
- Check each
USING-clause keyword's value for validity, and correct any misspelling or type mismatch.
Related Errors / Related Topics
- -23740 — "CREATE EXTERNAL TABLE: Too many keyword keywords in USING clause." A
related
USING-clause error, on a duplicated keyword rather than an invalid value.
A USING-clause keyword had an invalid value — check for misspellings, and confirm
MAXERRORS is a valid number.