HP 3000 Manuals HP 3000 Manuals
Messages 23000 - 23999 (continued)
--------------------------------------------------------------------------------------
AC23461 ERROR-Too many items in item list
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23462 ERROR-Found characters instead of JOIN
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23463 ERROR-Number of items wrong
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23464 ERROR-Join item cannot be an array
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23465 ERROR-Incompatible join expressions
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23466 ERROR-No common items to join
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23467 ERROR-Too many items to join
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23468 ERROR-Found characters instead of ',' or ')'
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23469 ERROR-Found characters instead of ',' or '>'
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23470 ERROR-Expected the reserved word IS after DEFAULT item
Generated by: HDSP or Administrator Utility
The IS keyword was not found after "DEFAULT item_name." The syntax
for defining a DEFAULT item for a Left Outer JOIN is DEFAULT
item_name IS constant.
Specify the correct syntax.
--------------------------------------------------------------------------------------
AC23471 ERROR-The value following the IS must be a constant
Generated by: HDSP or Administrator Utility
A constant or constant expression (such as "2 * 10") was not found
after "DEFAULT item_name IS." The syntax for defining a DEFAULT
item for a Left Outer JOIN is DEFAULT item_name IS
constant_expression.
Specify the correct syntax.
--------------------------------------------------------------------------------------
AC23473 ERROR-The DEFAULT constant is not compatible with this item
Generated by: HDSP or Administrator Utility
The constant expression that is specified as the DEFAULT for an
item involved in a Left Outer JOIN must have the same type as the
item. The default constant for a numeric item cannot be a
character string and the default constant for a character string
cannot be a numeric value.
Specify the correct constant for the item.
--------------------------------------------------------------------------------------
AC23474 ERROR-The DEFAULT constant is too long for this item
Generated by: HDSP or Administrator Utility
When you specify a DEFAULT string value for a character field, the
constant must be equal to or shorter than the item.
Specify a constant that is equal to or shorter than the character
item.
--------------------------------------------------------------------------------------
AC23475 ERROR-Table name does not exist
Generated by: HDSP or Administrator Utility
The table name, specified in the FROM clause of an SQL statement
or in the Using Clause of a view table, is not defined in the
HDPDIC database.
Specify a valid table name.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23476 INTERNAL ERROR-FOPEN of saved table file failed, FSERR number
Generated by: HDSP or Administrator Utility
When processing the SQL command in the Host Batch Facility or in
PC batch, an error occurred when attempting to FOPEN a table file
for processing. This should never occur unless the saved table
was accidentally purged (FSERR 52).
Look up the FSERR in the MPE File System Reference Manual to
determine the cause of the problem.
--------------------------------------------------------------------------------------
AC23477 ERROR-Table name is not a configured or a saved table
Generated by: HDSP or Administrator Utility
When processing the SQL command in the Host Batch Facility or in
PC batch, a table name was specified in the FROM clause of an SQL
statement that is not defined in the HDPDIC database and is also
not a saved table owned by the current user.
Specify a valid table name.
--------------------------------------------------------------------------------------
AC23478 ERROR-Saved table name does not exist
Generated by: HDSP or Administrator Utility
When processing the SQL command in the Host Batch Facility or in
PCbatch, a saved table name has been specified in the FROM clause
of an SQL statement via the "&" prefix and this table is not owned
by the current user.
Specify a valid saved table name.
--------------------------------------------------------------------------------------
AC23479 ERROR-View tables cannot reference saved tables
Generated by: HDSP or Administrator Utility
A saved table in the form "&savedtable" was included in the Using
Clause of a view table definition. Saved tables cannot be
specified in Administrator Utility view tables. Saved tables are
only supported within the FROM clause of an SQL command.
Specify only configured tables (not saved tables) in the Using
Clause of a view table definition.
--------------------------------------------------------------------------------------
AC23480 ERROR-Found characters instead of type designator
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23481 ERROR-Invalid length of integer type
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23482 ERROR-Invalid length of real type
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23483 ERROR-Character length too long
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23484 ERROR-Packed type not allowed as parameter
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23485 ERROR-Zoned type not allowed as parameter
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23486 ERROR-Length not allowed
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23487 ERROR-Found characters instead of parameter ID
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23489 ERROR-Found characters instead of ',' or the end of the clause
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23490 ERROR-Found characters instead of an identifier
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23491 ERROR-Aggregate items are not allowed in the GROUP BY clause
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23493 ERROR-Too many items
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23497 ERROR-Where clause must be logical expression
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23498 ERROR-Where clause must be scalar
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23499 ERROR-Where clause can't be aggregate
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23500 ERROR-Default constant for item name has already been specified
Generated by: HDSP or Administrator Utility
There are two or more default statements referring to the same
item, either in an SQL SELECT statement or in a view table
definition in the Administrator Utility.
Remove the duplicate default statement.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23501 ERROR-SELECT * disallowed with the GROUP BY clause
Generated by: HDSP or Administrator Utility
When specifying an SQL command in the Host Batch Facility or PC
batch, you entered a "*" (asterisk) in the SELECT clause while
performing a summary operation.
Include only aggregate expressions or GROUP BY items in the
SELECT clause when summarizing.
--------------------------------------------------------------------------------------
AC23503 ERROR-Aggregate items cannot be mixed with regular items
Generated by: HDSP or Administrator Utility
An SQL SELECT clause contained both aggregate items (SUM, AVG,
COUNT, MIN, MAX) and regular items. When performing a summarize
and aggregate items are included, regular items are not allowed in
the SELECT statement.
Remove either the aggregate items or the regular items.
--------------------------------------------------------------------------------------
AC23504 ERROR-Only one SELECT clause is allowed
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC batch.
--------------------------------------------------------------------------------------
AC23505 ERROR-Only one FROM clause is allowed
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC batch.
--------------------------------------------------------------------------------------
AC23506 ERROR-Only one WHERE clause is allowed.
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC batch.
--------------------------------------------------------------------------------------
AC23507 ERROR-Only one GROUP BY clause is allowed
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC batch.
--------------------------------------------------------------------------------------
AC23508 ERROR-Only one ORDER BY clause is allowed
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC batch.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23509 ERROR-The name clause is too large, maximumsize is number bytes
Generated by: HDSP or Administrator Utility
When specifying an SQL statement in the Host Batch Facility or in
PC batch, the maximum size of the specified clause was exceeded.
Reissue the SQL statement and stay within the following limits
for each clause:
SELECT 2048
FROM 640
WHERE 640
GROUP BY 160
ORDER BY 160
HAVING 640
--------------------------------------------------------------------------------------
AC23511 ERROR-Select specification must be logical
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23512 ERROR-Select specification must be scalar
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23513 ERROR-Select specification can't be aggregate
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23525 ERROR-Only one HAVING clause is allowed
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC Batch.
--------------------------------------------------------------------------------------
AC23526 ERROR-A SELECT clause containing item information is required
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC Batch.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23527 ERROR-A FROM clause containing table information is required
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC Batch.
--------------------------------------------------------------------------------------
AC23528 ERROR-A HAVING clause requires a GROUP BY clause
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC Batch.
--------------------------------------------------------------------------------------
AC23529 ERROR-Expected clause name to start SQL stmnt, found name
Generated by: HDSP or Administrator Utility
This error occurs when processing an SQL command in the Host Batch
Facility or PC Batch.
--------------------------------------------------------------------------------------
AC23543 ERROR-Too many GROUP items, the maximum is 10
Generated by: HDSP or Administrator Utility
When processing view tables, either from the Administrator Utility
or with the SQL command in the Host Batch Facility or in PC batch,
the maximum number of GROUP items has been increased to 10.
--------------------------------------------------------------------------------------
AC23544 ERROR-Found characters instead of ',' or the end of the clause
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23545 ERROR-Found characters instead of an item name
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23546 ERROR-Found characters instead of '='
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
Table 1-0. (cont.)
--------------------------------------------------------------------------------------
AC23547 ERROR-Needs aggregate expression
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23548 ERROR-Too many items
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23549 ERROR-Found characters instead of ',' or the end of the clause
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23550 ERROR-Group specification missing
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23566 ERROR-Items name and name can't be joined
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23567 ERROR-Item name must be scalar to be joined
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23571 ERROR-Array item name can't be sort key
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.
--------------------------------------------------------------------------------------
AC23572 ERROR-Too many sort keys. Maximum is 8
Generated by: HDSP or Administrator Utility
See cause and action for AC23001.