Messages

There are three types of messages that are displayed when you use Thoroughbred Query-IV:

Syntax Error Messages
Operational Messages
System Error Messages

Syntax Error Messages Syntax error messages are displayed when you execute an invalid query. In most cases, this can occur when you enter an invalid EQL command in the EQL Command Language Window. It can also occur when executing a command in the Query Framer, although this is less likely. These messages indicate that the EQL command cannot be executed and are self-explanatory, so that you can locate the problem and correct it yourself. Check the spelling of keywords, Data Names and Links. If you need more help, refer to the error message in this section for hints and possible causes. An error code precedes the syntax error message to identify it and help you locate the message in this section.

Operational Messages Most operational messages are described in the appropriate sections of this document. This section contains additional messages that may be displayed during the normal processing of your system and which are not explained in the body of the document, because in most cases they appear infrequently.

System Error Messages If a system error occurs, please report it to the support department, along with all pertinent information (the software version, computer hardware, and details on the procedure you were performing when the error occurred).

Refer to the appropriate message section in this section to locate a specific message.

Syntax Error Messages

001 - Duplicate keyword XXXXX encountered.

The indicated keyword appears twice; one occurrence must be removed from the command.

002 - XXXXX is not a keyword.

The indicated word is not a keyword, although it is found in the position of a keyword. The keyword may be missing or you may have missing or extraneous punctuation in the command.

003 - Invalid link XXXXX.

The Link is not found or an error occurred while obtaining the Link. Use Thoroughbred Dictionary-IV to check the Link and fix the problem.

004 - Invalid format XXXXX.

The Format specified in the Link is not found or an error occurred while obtaining the Format. Use Thoroughbred Dictionary-IV to check the Link and Format and fix the problem.

005 - Unpaired parenthesis or quotes.

Starting punctuation was used without any ending punctuation to match. Fix the punctuation.

006 - Alias name XXXXX already defined.

The expression alias name specified by the AS keyword conflicts with an existing Data Name. Use a different name for the alias.

007 - Invalid expression.

The expression used for this column is invalid. The cause could be non-matching data types, incorrect use of arithmetic operators or invalid punctuation.

008 - Cannot find data name XXXXX.

The specified Data Name is not found in the Data Name list. The name is misspelled or the Link is not selected. Only Data Names from the selected links can be used in the query.

009 - Subscript value greater than number of occurrences.

The specified subscript is not a valid occurrence number, or offset number, for this repeating Data Name. Use Thoroughbred Dictionary-IV to check the Format definition for this Data Name and determine the defined number of occurrences.

010 - Substring exceeds data length.

You have specified a substring of an alphanumeric Data Name that exceeds the defined element length. Check the element length displayed in the Data Name list against your substring specification. The substring should specify a starting position and length that falls within the defined length of the Data Name.

011 - Invalid XXXXX.

The indicated item is invalid; usually this results from an invalid column heading or numeric output mask. Check for correct use of spacing, commas and quotes.

012 - ORDER BY not allowed with GROUP BY.

The ORDER BY clause cannot be used when a GROUP BY clause is used; they are mutually exclusive. (If a GROUP BY clause is used, the rows are automatically ordered by the specified group.)

013 - Match value in LIKE exceeds data length.

The match value specified by the LIKE operator exceeds the length of the column definition. Use another match value.

014 - Unable to recognize LIKE XXXXX.

The match value specified by the LIKE operator is invalid or unsupported. Use another match value.

015 - Invalid RANGE specification.

The specified range is invalid for this query. Possible causes include the following: (1) the FROM keyword or value is not found, or the TO keyword or value is not found, (2) the FROM and TO values cause a data type mismatch or do not specify a string value, or (3) the values cannot be used to access the file (the file is not a key-access file or the values do not specify the primary key of the first Link).

016 - Unmatching data types.

The query uses an alphanumeric value where a numeric value is expected, or a numeric value where an alphanumeric value is expected. This can easily occur in an expression, in a condition that compares values, or with the LIKE operator, which requires string values.

017 - No operators for XXXXX phrase.

A keyword appears without the required specifications. The keyword might be followed by the end of the query or by another keyword. Refer to the EQL syntax and add the required items.

018 - Unrecognizable syntax.

The syntax cannot be understood. This is commonly caused by a WHERE clause that is incomplete or invalid.

019 - SELECT and FROM are required for all queries.

The query does not contain a valid SELECT or FROM. You must select at least 1 column and specify at least 1 Link in the query in the Format: SELECT column FROM Link-name.

020 - Data elements must be from the same link.

The GROUP BY or ORDER BY clause specifies Data Names that are from more than 1 Link.

021 - Missing syntax element.

This is commonly caused by a WHERE condition that is incomplete.

999 - Thoroughbred Query-IV internal error.

Please contact product support for help with this problem.

*Syntax error, F1 to display, RETURN to continue.

Please contact product support for help with this problem.

Operational messages

Cannot determine access to file ‘XXXXX’.

This commonly occurs when 2 unrelated Links, or Files, are specified in the query. When more than 1 Link is specified in the query, it must be related to the preceding Link by a common field. It can also be caused by specifying data from Links other than the first Link in an ORDER BY or GROUP BY clause.

Cannot locate file XXXXX.

The data file specified in the Link does not exist or is inaccessible. Check with your system administrator.

Cannot locate Dictionary-IV sort file.

The ORDER BY clause specifies an existing SORTx, but the Sort file cannot be located. Use Thoroughbred Dictionary-IV to check the Sort file name in the Link or to rebuild the Sort file.

Enter password for link ‘XXXXX’:

System security requires that you enter the Link password before the Link can be selected or the query executed.

File XXXXX busy, cannot open.

The specified file is unavailable at the moment. Try your query later or contact the system administrator.

Operator denied access to ‘Link - XXXXX’, RETURN to continue.

The Link contains operator security preventing the operator from accessing the Link. There is no way to bypass this restriction without removing it from the Link definition.

Security doesn’t allow XXXXX to be selected, RETURN to continue.

The specified column (Data Name) contains Format security restricting the display of its contents. The Data Name cannot be selected and the query executed using this Data Name.

Sort key too large for file XXXXX.

The ORDER BY clause specifies a temporary Sort definition that exceeds the maximum length of 72 (on most systems).

Terminal denied access to ‘Link - XXXXX’, RETURN to continue.

The Link contains terminal security preventing the terminal from accessing the Link. There is no way to bypass this restriction without removing it from the Link definition.

XXXXX is not a valid file definition (format).

The Format specified in the Link definition cannot be located. Use Thoroughbred Dictionary-IV to check the Format name in the Link and also the Format definition to fix the problem.

System error messages

System errors are recognized by the display of a message on the top line of the screen:

System Error: Pgm-XXXXXXXX Ln-#### Err-## RETURN=Retry E=End

Pgm: Indicates the BASIC program in which the error occurred.
Ln: Indicates the line number at which the error occurred.
Err: Indicates the BASIC error code.

Depending upon the error code and other factors, it may be possible to recover and continue. To continue, or retry, press Enter.

If the error recurs or cannot be corrected, press E to end the procedure, which takes you out of the process and tries to recover from the error as much as possible.

Common errors

Error 0: Record Busy or File Busy
Error 11: Missing Record
Error 12: Can’t Find File

From the Query-IV Reference, version 8.9.1. Open this page in the PDF