Eloquence Query Manual
For example:
OUTPUT PRINTER
^
EXPECTED 'TO'
The different error messages that Query might issue are listed alphabetically on the following pages, along with descriptions of the error messages. Where possible, the error message description includes suggestions for corrective actions. A QUERY FILE IS MISSING FROM THE DIRECTORY
One of the programs or data files that Query uses is not in the /opt/eloquence/share/prog directory.
ABNORMAL QUERY TERMINATION
You have caused Query to abort operation. This may have caused the database to be destroyed. Consult your System Administrator for assistance.
ARITHMETIC OPERATOR IN STRING EXPRESSION
In the FIND search expression a string type data item is being evaluated to a numeric expression (e.g., NAME="1" + "1") or a string is being used in numeric expression (e.g., "ABC" + "3" = PRICE).
ATTEMPTED DIVISION BY ZERO
The divisor in an equation is zero. Check all the values for the data items used in the search expression.
ARRAY ITEM NOT ALLOWED HERE
The data item in the FIND search expression and sort list, as well as the data item in the item list of a BREAK ON or TOTAL command must be a simple item. The INFO command lists all the data items and their types.
CANNOT MODIFY KEY ITEM
A key item value cannot be changed with the REPLACE or DELETE command. You must delete the entire entry and then add it with the change.
CLOSING PARENTHESIS MISSING
You have omitted a closing parenthesis.
CLOSING QUOTE MISSING
You have omitted a closing quotation mark.
DATABASE CORRUPT
The database is not stored correctly. Do not attempt further use of the database. The database needs attention. Consult your system administrator or the Eloquence DBMS Manual.
DATABASE NOT CREATED
The database has not been prepared for use. The dbcreate utility must be run (refer to the Eloquence DBMS Manual).
DATABASE NOT FOUND OR IN USE
Query cannot open the database, either because it could not find it on the disk or because it is open to another user. Using the CATalogue command, check the disk directory to see if the database is on the disk. Also check that there is no other user.
DATABASE ROOT FILE NOT FOUND
Query cannot find the root (main) file of the database. Check the disk file directory with a CATalog command.
DATA SET IN USE
Someone or some program is using the data set you specified. Query must have exclusive use of the data set.
DISK DIRECTORY OVERFLOW
The file system on the disk is full.
'DO' COMMAND NOT ALLOWED IN A 'DO' FILE
The DO file has a DO command in it. The DO command cannot be stacked.
DUPLICATE KEY ITEM IN MANUAL MASTER
You are attempting to add a key item value which already exists in the manual data set.
EXCEEDS ITEM LIMIT OF 16
Only 16 items can be totaled. Enter the command again limiting the number of items.
EXCEEDS ITEM LIMIT OF 1024
The total number of data items in the FIND item list and search expression cannot exceed 1024.
EXPECTED A COMMA
Check the syntax of the command and then re-enter it correctly.
EXPECTED A DETAIL SET
The THREAD command links detail sets to master sets. Two master sets cannot be directly linked together.
EXPECTED A LOGIC OPERATOR
A logic operator (AND, OR) must be used between expressions in the FIND search expression.
EXPECTED A MASTER SET
The THREAD command links detail sets to master sets. Two detail sets cannot be directly linked together.
EXPECTED A RELATIONAL OPERATOR
A relational operator (>, %<, =, #), is required in each expression of the FIND search expression.
EXPECTED A SET OR ITEM NAME
The value entered for the name of the set or data item is not a valid set or item name.
EXPECTED 'BASE'
The word BASE was omitted from the DATABASE command.
EXPECTED 'BY'
The word BY was omitted from SORT BY command.
EXPECTED END OF LINE
The end of the command was read, but more characters followed. Check the syntax of the command.
EXPECTED 'FOR'
The word FOR was omitted from the FIND command.
EXPECTED 'LIST'
The word LIST was omitted from the LINEAR LIST command.
EXPECTED 'ON'
The word ON was omitted from the BREAK ON command.
EXPECTED 'TO'
The word TO was omitted from the OUTPUT TO command.
EXPECTED 'TOTAL'
Something other than the word TOTAL follows the break item in the BREAK ON command.
EXPRESSION MUST CONTAIN AN ITEM OR 'POS'
The search expression in the FIND command must contain a data item or a POS function.
FATAL COMMAND xxx ENCOUNTERED
An error was found during the execution of the command. The number -xxx- following the message is the error code. Consult your system administrator or - if no cause for the error can be detected - contact Marxmeier support.
FILE NOT FOUND, WRONG TYPE, OR BUSY
The DO file, workfile, RUN program file or FORM file cannot be found or the type is wrong, or some one else is using it. Using the CATalogue command, check the disk directory for file names and file types.
FIND COMMAND TOO LONG
There are too many characters in the command.
INCOMPATIBLE DATABASE VERSION
The database was created on another version of Eloquence and cannot be used on this version.
INPUT EXCEEDS 512 CHARACTERS
A command can consist of at most 512 characters.
INSUFFICIENT DISK SPACE FOR FILES
Query cannot create a workfile, scratch file or spool file because of insufficient room on the specified file system.
INSUFFICIENT MEMORY FOR DATA SET LOCK
The Common Block of memory is full and another data set cannot be locked at this time.
INSUFFICIENT NUMBER OF FIELDS IN FORM
There are not enough fields in the form to enter values for all the data items.
INTERMEDIATE RESULT OVERFLOW
While the search expression was being evaluated, an overflow occurred. The expression must be modified and the FIND command entered again.
INVALID COMMAND
You entered a command unknown to Query. Check that the command is spelled correctly.
INVALID DATABASE NAME
The name you entered cannot be a database name. Check that you have entered it correctly.
INVALID DATA IN 'DO' FILE
The entry in the file is not a valid Query command. This file may not be the DO file. Check the contents of the file.
INVALID DATE
The date must be entered in the format MM/DD/YY for the U.S. or DD/MM/YY for the U.K. The date may be from Jan 1, 1978 to Dec 31, 1999.
INVALID DEVICE SPECIFICATION
The printer number in the OUTPUT TO command has been specified incorrectly, or is not PRINTER, DISPLAY, STDOUT, STDERR or CONSOLE.
INVALID EXPRESSION
The expression in the FIND search expression cannot be used by Query. Refer to page 41 for more information.
INVALID FILE NAME
The name you specified for a file is not a valid disk file name.
INVALID INTEGER PRECISION NUMBER
The data item is integer precision and the value you entered for the data item is not an integer precision number. Integer precision is described in page 97 .
INVALID LENGTH SPECIFICATION
The page length specified in the OUTPUT TO command is not valid. Check that it is numeric and between 20 and 30000.
INVALID LONG PRECISION NUMBER
The data item is long precision and the value you entered for the data item is not a long precision number. Long precision is described in page 97 .
INVALID PASSWORD
The password you specified is not recognized by Query.
INVALID REPORT SUBPROGRAM
The subprogram has a name other then REPORT, the parameters are incorrect, the subprogram is binary, or there is no subprogram in the file specified.
INVALID SHORT PRECISION NUMBER
The data item is short precision and the value entered for the data item is not a short precision number.
INVALID WIDTH SPECIFICATION
The page width specified in the OUTPUT TO command cannot be used. Check that the value is an integer between 20 and 264.
ITEM NOT IN SPECIFIED SET
The data item specified is not in the specified data set.
KEY ITEM POINTS TO DETAIL ENTRY
You are attempting to delete an entry from a manual master which still points to an entry in a detail set.
LIST TITLE EXCEEDS 80 CHARACTERS
The optional heading cannot be more than 80 characters in length.
MORE THAN ONE PATH BETWEEN THESE SETS
You must specify the key data items to show which path to use.
MORE THAN ONE SET NOT ALLOWED HERE
You can only add, delete or replace items in one data set at a time.
NAME EXCEEDS 15 CHARACTERS
The data set or data item name exceeds 15 characters. Use the INFO command to check the schema for the correct name and then re-enter it.
NO ENTRIES HAVE BEEN FOUND
There are no data entries in the workfile.
NO MATCHING KEY ITEM IN MANUAL MASTER
You cannot add a new key item value to a detail data set unless the value already exists in the manual master set which points to it.
NO WRITE ACCESS WITH CURRENT PASSWORD
You cannot add, replace or delete entries in this data set with your password.
NOT A VALID PATH
The only paths are those connecting a detail set and a master set together. The key item must be in both sets.
NUMBER NOT IN QUOTES OR INVALID CHARACTER
You entered a character which Query cannot use (e.g., lowercase or line drawing characters) or there are no quotes around a number. Re-enter the command using only the standard character set (in upper-case).
NUMERIC ITEM OR CONSTANT REQUIRED
A numeric data item is being tested for a string value, or you are adding a string value to a numeric data item.
NUMERIC ITEM REQUIRED
Only numeric data items may be totaled.
OUTPUT DEVICE IS IN USE
Someone else is using the output device. Choose another printer, or use a spooled printer or a spool file for output.
OUTPUT DEVICE NOT AVAILABLE
The device specified is not currently ready for output.
QUERY DISK DIRECTORY OVERFLOW
The file directory is full. Include a different volume specifier with the WORKFILE command.
REPORT BREAK PREVIOUSLY SET ON THIS ITEM
The data item in the current BREAK ON command was used in a previous BREAK ON command.
SET NAME ONLY NOT ALLOWED HERE
A set name cannot be used alone in the FIND search expression, the BREAK ON list, the TOTAL list, or the SORT BY list.
SET OR ITEM NOT FOUND
Query cannot find the data set or data item name in this database.
SET OR ITEM NOT IN PREVIOUS FIND
The set or item specified in the command is not in the workfile.
SPOOL FILE CANNOT BE EXPANDED
The spool file is full and there is no room on the disk to expand it. Use another for further output.
STRING ITEM OR STRING REQUIRED
A numeric data item or constant is being used where a string is required.
STRING TOO LONG
The string entered is too long for the data item.
THIS SET NOT IN THE SPECIFIED THREAD
One or more of the sets in the FIND command were not in the previous THREAD command.
VOLUME NOT FOUND OR WRITE PROTECTED
The specified volume could not be found or is write protected. Check that the volume is correctly specified.
WORKFILE OR SCRATCH FILE NAME CONFLICT
Query cannot create the workfile or scratch the file because the name it uses has already been used on another file.
WORK RECORD EXCEEDS 256 BYTES
A maximum of 16 data items may be sorted. Further, the total length of the data items plus 2 bytes times the length of the thread must be less than or equal to 256 bytes. How to calculate the length of data items (variables) is described in the section titled "Memory Usage", in the Eloquence Manual.
WRITE TO AUTOMATIC MASTER NOT ALLOWED
You cannot use ADD, DELETE or REPLACE commands on data items in the automatic master.
WRITE TO THIS SET OR ITEM NOT ALLOWED
You cannot use the ADD, DELETE, or REPLACE commands on the item or set specified because the control number is set to write inhibit.
Chapter contents: