Messages 14001 - 14200
EDA14001 - EDA14006 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14007 SQL SYNTAX ERROR AFTER '%1'
An SQL syntax error was detected after the token listed above. Please check your SQL statement for errors. Note that the SQL translator supports ANSI standard SQL.
EDA14008 SQL SYNTAX ERROR AT '%1'
An SQL syntax error was detected at the start of a line. Please check your SQL statement for errors. Note that the SQL translator supports ANSI standard SQL.
EDA14009 TABLE %1 IS NOT FOUND
The table name given in the SQL statement is not the name of a table or view. Please verify that this table or view exists.
EDA14010 %1 IS NOT A VALID COLUMN NAME
The column name given in the SQL statement is not the name of a column in the table(s) or view(s) referenced in that statement. Please verify that this column exists in the referenced table(s) or view(s).
EDA14011 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14012 THE COLUMN NAMED %1 IS AN AMBIGUOUS REFERENCE
The SQL translator cannot determine the meaning of the indicated column name. Please ensure that columns with the same name are qualified in your SQL statement.
EDA14013 %1 %2 IS NOT SUPPORTED
The SQL syntax indicated is not supported in the current release of the SQL translator.
EDA14014 OPERATOR %1 INCOMPATIBLE WITH OPERANDS %2
The operator is not compatible with its operands in an SQL expression or condition.
EDA14015 MULTIPLE COLUMNS REQUESTED IN SINGLE VALUED SELECT
A SELECT or sub SELECT was used in a context that requires a single value, and multiple values were selected.
EDA14016 LIST CONTAINS WRONG NUMBER OF VALUES FOR %1
A list of values used in the SQL statement is incorrect. Please ensure that the list has the correct number of values.
EDA14017 VALUE %2 INCOMPATIBLE WITH OPERATOR %1
The value given in the list of values is incompatible with the operator for that list. Please ensure that the values in the list are of the appropriate data types.
EDA14018 %1 OPERATOR REQUIRES ALPHANUMERIC OPERANDS %2
The operator requires alphanumeric operands. Please ensure that the operands in the expression are alphanumeric columns or literals.
EDA14019 SQL TRANSLATOR GENERAL ERROR %1 %2
The SQL translator detected an error during the translation process. Please ensure that your SQL statement is correct.
EDA14020 INSUFFICIENT MEMORY AVAILABLE FOR SQL TRANSLATOR
There is not enough memory for SQL translator operations.
EDA14021 COLUMN ATTRIBUTES ARE NOT COMPATIBLE FOR 'UNION'
Corresponding columns of tables belonging to the union are not compatible. Please ensure that these columns are of compatible data types and lengths.
EDA14022 DUPLICATE PREPARE FOR STATEMENT %1
The SQL statement to be prepared is a duplicate of a previously prepared SQL statement.
EDA14023 STATEMENT %1 HAS NOT BEEN PREPARED
The statement to be executed has not been prepared.
EDA14024 COLUMN %1 IS OF AN UNKNOWN OR UNSUPPORTED DATA TYPE
The data type of the column is not known to the SQL translator, or is not currently supported by the SQL translator.
EDA14025 COLUMN LISTS IN %1 ARE UNEQUAL
Either the tables belonging to a union do not have the same number of columns, or the column list and values list of an INSERT statement have an unequal number of members.
EDA14026 COLUMN NUMBER %1 IN %2 CONTAINS INCOMPATIBLE FIELDS
The columns in the select lists of the SQL statements of a set operation (UNION, INTERSECT, or EXCEPT) are not compatible with each other.
EDA14027 UNRECOGNIZED MINIPARSER COMMAND '%1'
Text following the SQL statement is not a valid MiniParser command. Valid MiniParser commands are FILE, ECHO and TABLE.
EDA14028 INVALID COLUMN NUMBER %1 USED IN ORDER BY CLAUSE
The column number used in the order by clause is invalid.
EDA14029 INVALID COLUMN NAME %1 IN ORDER BY CLAUSE
The column name given in the order by clause is incorrect, or of a data type that cannot be sorted.
EDA14030 TABLE OR VIEW %1 ALREADY EXISTS
The table or view mentioned already exists; therefore a new table or view of that name may not be created.
EDA14031 INVALID JOIN OPERATION REQUESTED
The join requested in the SQL statement is not currently supported by the SQL translator.
EDA14032 - EDA14040 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14041 USING CLAUSE HAS FEWER VALUES THAN PARAMETERS IN QUERY
The using clause of the execute or bind statement has fewer values than parameters in the SQL statement. The SQL statement cannot be executed unless all parameters have been resolved.
EDA14042 EXTRA VALUE %1 IN USING CLAUSE
The using clause contains more values than parameter markers in the SQL statement.
EDA14043 COLUMN %1 APPEARS TWICE IN CREATE STATEMENT
The create table or create view statement attempts to define two columns with the same name. Column names must be unique within a table or view.
EDA14044 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14045 VIEW NAME %1 IS A DUPLICATE NAME
The view name given is a duplicate name. A view may not have the same name as an existing view or table.
EDA14046 VIEW NAMED %1 DOES NOT EXIST
The view referenced in an SQL statement or operation does not exist.
EDA14047 UNABLE TO DROP OBJECT %1
DROP is not supported for tables in this release. Only view objects may be dropped.
EDA14048 CREATE VIEW COLUMN LIST HAS WRONG NUMBER OF COLUMNS
The column list in the create view statement does not agree with the column list in the select statement that defines the view.
EDA14049 EXPLICIT COLUMN LIST REQUIRED FOR UNNAMED COLUMNS
The view cannot be created without providing an explicit column list, because the view contains unnamed columns. Please provide an explicit column list in your view definition.
EDA14050 GROUP BY CLAUSE REQUIRED
SELECT statements that contain both aggregate and non-aggregate columns in the select list must have a GROUP BY clause that refers to those non-aggregate columns. Please change your SQL statement to reflect the appropriate grouping.
EDA14051 = ALL FUNCTION NOT SUPPORTED IN THIS RELEASE
The = ALL comparison operator is not supported in the release of the SQL translation services installed at your site.
EDA14052 <> ANY AND <> SOME FUNCTION NOT SUPPORTED IN THIS RELEASE
The <> ANY and <> SOME comparison operators are not supported in the release of the SQL translation services installed at your site.
EDA14053 SELECT LIST NON-AGGREGATE %1 NOT IN GROUP BY CLAUSE
If a select list contains both aggregate and non-aggregate values, the non-aggregate values must appear in a GROUP BY clause.
EDA14054 VALUE SUBQUERY MUST RETURN A SINGLE VALUE
A subquery defining an answer set was used in place of a single valued expression. A subquery used in this manner must define an answer set containing at most one value.
EDA14055 GROUP COLUMN %1 NOT FOUND IN SELECT LIST
Columns referenced in the GROUP BY clause must also appear in the select list.
EDA14056 MIXED AGGREGATE AND NON_AGGREGATE WITH NO GROUP BY
A non-aggregate column was used in the select list in conjunction with an aggregate column, and there is no GROUP BY clause in the statement. Non-aggregate columns in the select list must also appear in the GROUP BY clause if aggregates are also present.
EDA14057 UNION STATEMENT EXCEEDS 6 SELECT LIMIT
The UNION operator currently supports at most 6 SELECT clauses in a single statement.
EDA14058 ONLY ONE DISTINCT ALLOWED PER SELECT STATEMENT
The DISTINCT keyword may be used only once in a given select list.
EDA14059 TOO MANY TABLES IN THE SQL STATEMENT
The maximum number of tables that may be referenced in an SQL statement is 16.
EDA14060 COLUMN %1 IN HAVING CLAUSE IS NOT INCLUDED IN A GROUP BY LIST
Expressions or columns referenced in a predicate in the HAVING clause must be contained in a GROUP BY clause.
EDA14061 PARAMETER MARKER FOUND IN NON-PREPARED STATEMENT
A parameter marker '?' was found in an SQL statement that has not been prepared. To use parameterized SQL you must PREPARE the SQL statement.
EDA14062 IDENTIFIER %1 TOO LONG - LIMIT IS 64 CHARACTERS
SQL identifiers must be 64 characters or less. Check your SQL statement to make sure the identifier names are of the proper length.
EDA14063 TABLE NAME CONTAINS AN ILLEGAL CHARACTER
The table name specified in the SQL statement contains an illegal character. Please check your table names to make sure they are correct.
EDA14064 NESTING OF AGGREGATE FUNCTIONS NOT PERMITTED
The aggregate functions AVE, SUM, COUNT, MIN and MAX may not be nested in an expression.
EDA14065 AGGREGATE FUNCTION FOUND IN WHERE CLAUSE
Predicates containing aggregate functions are permitted only in the HAVING clause of a SELECT statement. If this is your intention, please reformulate the query accordingly.
EDA14066 MORE THAN 16 TABLES FOUND IN FROM CLAUSE
There is a limit of 16 tables in the from clause.
EDA14067 STATEMENT CONTAINS UNKNOWN SCALAR FUNCTION '%1'
Scalar function is unknown.
EDA14068 ERROR IN SCALAR FUNCTION '%1' %2
The scalar function named has incorrect parameters (number, type, or value).
EDA14069 SYNTAX ERROR %1 %2
There is a syntax error in the source. The first argument indicates where the error is discovered. The second argument describes the error.
EDA14070 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14071 DATA OBJECT '%1' IS A VIEW WHICH CANNOT BE UPDATED
The named object is a view which cannot be updated by an INSERT, UPDATE or DELETE statement.
EDA14072 - EDA14078 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14079 NOT ALL KEYS ARE SPECIFIED IN EQUALITY CONDITION
All keys must be specified in an equality condition in an UPDATE or DELETE statement.
EDA14080 INCORRECT NULL USAGE
NULL can be used only in a SELECT-list, an INSERT value-list, an UPDATE SET-clause, or in EXECUTE or OPEN when a prepared statement allowed NULLs. Correct usage in the WHERE clause is "IS NULL".
EDA14081 IN CLAUSE HAS AN EMPTY LIST
The IN clause cannot have an empty list.
EDA14082 INVALID QUANTIFIED SUBQUERY
Quantified subquery is incorrect.
EDA14083 FIELD '%1' DOES NOT PERMIT NULLS
The field may not contain a null value.
EDA14084 NON-EQUALITIES ARE NOT SUPPORTED IN UPDATE AND DELETE
UPDATE and DELETE support only equality conditions in FOCUS.
EDA14085 NOT ALL KEYS ARE SPECIFIED
All keys must be specified in an INSERT statement.
EDA14086 ERROR IN %1 MASTER FILE DESCRIPTION
Error in MFD.
EDA14087 MASTER FILE PARSER INTERNAL ERROR
MASPAR internal error.
EDA14088 ALL UPDATE FIELDS MUST BE IN THE LOWEST REFERENCED SEGMENT
All update fields from set clause must be from the lowest reference segment.
EDA14089 MULTIPATH INSERT, UPDATE, DELETE IS NOT SUPPORTED
Multipath insert, update, delete is not supported.
EDA14090 INSERT FROM SELECT NOT SUPPORTED FOR NON-RELATIONAL DATA
Insert from select not supported for non-relational data.
EDA14091 INSERT VALUE FOR '%1' IS NOT COMPATIBLE WITH COLUMN FORMAT
The value being inserted is not consistent with the field type.
EDA14092 CAN'T ESTABLISH CONNECTION TO REMOTE SERVER OR LOCAL RDBMS
Cannot establish connection to the remote server or local RDBMS.
EDA14093 GROUP FIELD SKIPPED BY SELECT STAR EXPANSION: %1
Group fields are skipped during select star expansion.
EDA14094 FIELD OF UNSUPPORTED TYPE %1 OMITTED FROM SELECT *.
The field's type is not supported.
EDA14095 CODE GENERATION FOR %1 NOT SUPPORTED
FOCUS code generation is not supported for this feature.
EDA14096 TABLE CONTAINS NO KEY FOR MATCH LOGIC
INSERT and UPDATE is impossible because table contains no key fields for match logic.
EDA14097 INVALID DURATION SPECIFIER '%1' USED IN LABELED DURATION
The valid durations are: YEAR (S), MONTH (S), DAY (S), HOUR (S), MINUTE (S), SECOND (S), MILLISECOND (S), MICROSECOND (S).
EDA14098 INVALID NUMBER SPECIFIED IN LABELED DURATION
Only integers may be used in labeled durations.
EDA14099 CANNOT UPDATE, DELETE STATEMENT CONTAINING %1
XMOD special limitations: no OR's permitted in the WHERE clause, not equal ('<>') operator is not supported, LIKE literal may have trailing wildcard(s) only, not embedded ones.
EDA14100 MAXIMUM WIDTH OF TYPE IS EXCEEDED FOR THE FIELD %1
The maximum length of the data type has been exceeded.
EDA14101 SCALE EXCEEDS PRECISION FOR THE FIELD %1
Scale cannot exceed precision.
EDA14102 ATTEMPT TO UPDATE KEY FIELD '%1'
SQL does not permit updating the named field, which is declared to be a key.
EDA14103 ATTEMPT TO UPDATE OR INSERT TO READ ONLY FIELD '%1'
A read-only field may not be the target of an update or insert operation.
EDA14104 STATEMENT IS NOT EXECUTABLE VIA AUTOMATIC PASSTHROUGH
Statement is APT-ONLY. Query is not processed if it can't go APT.
EDA14105 TABLE NAME %1 WAS MAPPED TO %2
The MASPAR errors following this message should be interpreted using the stated name mapping.
EDA14106 PARAMETER NUMBER %1 MUST BE A NUMERIC LITERAL
Prepared statement requires numeric parameter.
EDA14107 PARAMETER NUMBER %1 MUST BE AN ALPHANUMERIC LITERAL
Prepared statement requires an alphanumeric parameter.
EDA14108 PARAMETER NUMBER %1 MUST BE A DATE LITERAL
Prepared statement requires date parameter.
EDA14109 PARAMETER NUMBER %1 MAY NOT BE NULL
This parameter may not be NULL.
EDA14110 ONLY PREDICATES LIKE 'FLD=VAL' ARE ALLOWED IN UPDATE AND DELETE
Only simple predicates like COLUMN = <literal> are allowed in the WHERE clause of UPDATE and DELETE statements.
EDA14111 UNSUPPORTED DATA TYPE FOUND IN BIND STATEMENT
The data type is unsupported.
EDA14112 STATEMENT WAS NOT BOUND
Statement needs to be bound.
EDA14113 ATTEMPT TO INSERT INTO BLOB/CLOB FIELD
Master File contains blob or clob fields. Specify insert fields explicitly.
EDA14114 TABLE %1 CONTAINING BLOB OR CLOB FIELDS SUPPORTED ONLY FOR APT
Current limitations in the data retrieval engine do not allow use of tables containing BLOB or CLOB fields in a nonautomatic Passthrough SQL statement.
EDA14115 SQL LINE IS TOO LONG
SQL line is longer than 133 bytes.
EDA14116 UNSUPPORTED DATATYPE IN CREATE TABLE STATEMENT
One or more data types specified in a CREATE TABLE statement are unsupported or unrecognized.
EDA14117 WRONG NUMBER OF PARAMETERS IN EXECUTE STATEMENT
The number of parameters in the EXECUTE statement does not agree with the number in the prepared statement.
EDA14118 WRONG LOCATION IS SPECIFIED IN SET STATEMENT
Location specified in set statement cannot be found.
EDA14119 PARAMETER NUMBER %1 MUST BE CHAR(16)
Prepared statement requires char (16) in "bind" for blob/clob.
EDA14120 SET VARIABLE %1 IS NOT SUPPORTED
Incorrect set variable is specified.
EDA14121 CURRENT SETTING FOR %1 %2
Prints current SQL translator's settings.
EDA14122 DELETE ENTIRE TABLE IS NOT SUPPORTED FOR NON-FOCUS FILES
Can't delete entire table for non-FOCUS.
EDA14123 %1 IS NOT A VALID ESCAPED LITERALS TYPE
D, T, TS, FN are supported types for ODBC escaped literals.
EDA14124 %1 IS EXPECTED AFTER THIS TYPE OF ESCAPED LITERAL
D for dates, T for time, TS for timestamps, FN for functions.
EDA14125 ESCAPE LITERAL MUST BE A SINGLE CHARACTER
Escape literal for LIKE must be a single quoted character, for example '/'.
EDA14126 INVALID UPDATE VALUE FOR COLUMN %1
In an UPDATE, the value cannot be stored in the column.
EDA14127 SET OPERATION CANNOT BE PERFORMED
FOCUS cannot execute INTERSECT ALL or EXCEPT ALL, nor UNION ALL in combination with INTERSECT or EXCEPT.
EDA14128 PARAMETER NUMBER %1 MUST BE A TIME LITERAL
Prepared statement requires a time string as a parameter.
EDA14129 PARAMETER NUMBER %1 MUST BE A TIMESTAMP LITERAL
Prepared statement requires a timestamp string as a parameter.
EDA14130 SCALAR FUNCTION %1 REQUIRES DATE OR TIME ARGUMENT
This function must have a date, time, or timestamp parameter.
EDA14131 FILE %1 CANNOT BE OPENED
The file in a PREPARE FROM file request could not be opened.
EDA14132 STATEMENT IN FILE %1 IS NOT PREPARABLE
The SQL statement in a PREPARE FROM file request cannot be prepared.
EDA14133 FILE NAME NOT SPECIFIED IN PREPARE FROM
In a PREPARE from file statement, no file was supplied.
EDA14134 INVALID CAST EXPRESSION
The object of the CAST expression cannot be converted to the requested type.
EDA14135 DUPLICATE COLUMN NAME %1 IN TABLE %2
In a UNION CORRESPONDING or NATURAL JOIN, one of the tables contains a duplicate column name.
EDA14136 NO MATCHING COLUMNS IN %1 CORRESPONDING
In a UNION, INTERSECT, or EXCEPT CORRESPONDING, the tables do not have any columns with the same name.
EDA14137 MISSING COLUMN %1 IN %1 CORRESPONDING
A column specified in a UNION, INTERSECT, or EXCEPT CORRESPONDING clause is not present in every member.
EDA14138 MISSING COLUMN %1 OF TABLE %2 IN JOIN USING
A column specified in a JOIN USING clause is not present in one of the tables in the join.
EDA14139 INVALID GRAPHIC LITERAL
A literal of the form G'xxx' cannot be processed by FOCUS.
EDA14140 UNBALANCED QUOTATION MARKS
A character literal or delimited identifier is missing a closing single- or double-quotation mark.
EDA14141 INVALID INSERT VALUE %1
The INSERT statement contains an invalid value.
EDA14142 BAD LABEL WITH DATE EDIT
The label for numeric arguments is outside of the precision for the mathedit of the date/time/ts argument.
EDA14143 RHS OF UPDATE MUST BE LITERAL
The right hand side of an update statement must be a literal in FOCUS generation.
EDA14142 - EDA14199 SQL TRANSLATOR ERROR %1 %2
SQL Translator internal error.
EDA14200 PARAMETER INFORMATION '%1' SENT
If PARMINFO flag is set, this message is generated to pass information to ODBC. It is not really an "error" message.