Informix Error -23740: CREATE EXTERNAL TABLE: Too many keyword keywords in USING clause.
Cause and resolution
CREATE EXTERNAL TABLE: Too many keyword keywords in USING clause.
The CREATE EXTERNAL table statement (or SELECT...INTO EXTERNAL statement) contains more than one occurrence of a keyword expected in the USING clause.
Review the statement. If you meant to use another keyword, correct the statement before you reissue it.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23740 fires when a CREATE EXTERNAL TABLE (or SELECT...INTO EXTERNAL) statement's
USING clause repeats a keyword more than once — per the official guidance.
- A
USING-clause keyword specified more than once, per the official guidance — the direct, only cause.
Solutions / Resolution
- Review the statement and correct any keyword you meant to be different, per the official guidance, before reissuing it.
Examples
N/A
No specific triggering statement is documented beyond a repeated USING-clause
keyword.
Diagnostic Checks
- Check the
USINGclause for a keyword listed more than once, and remove or correct the duplicate.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -23740 in this set yet.
A USING-clause keyword appeared more than once in a CREATE EXTERNAL TABLE
statement — remove or correct the duplicate.