KFAA30129-E
The specified number aa....aa exceeds the maximum of bb....bb. (M+J+O)
A specification has exceeded its maximum number.
- aa....aa:
-
Specification that exceeded its maximum number
Value of aa....aa
Meaning
SQLSTATE
parameters
Dynamic parameters
425A0
parameters of COALESCE function
Target data specified in the COALESCE scalar function
425A0
parameters of DECODE function
Arguments specified in the DECODE scalar function
425A0
parameters of GREATEST function
Target data specified in the GREATEST scalar function
425A0
parameters of LEAST function
Target data specified in the LEAST scalar function
425A0
parameters of LTDECODE function
Arguments specified in the LTDECODE scalar function
425A0
when
WHEN
425A4
row value constructor elements
Row value constructor elements in a row value constructor
425A6
row value constructors
Row value constructors in a table value constructor
425A7
parameters of system-defined function
Arguments specified in a system definition function
425A8
multiset elements
Number of multiset elements
425A9
query specifications
Query specifications and table value constructors
425AA
columns in table function column list
Column name in a table function column list
425AI
select tables
Tables specified in the FROM clause of a query specification (including those in view definitions)
425B0
tables
Tables specified in an SQL statement
425B0
select columns
Columns to be derived by a query specification
425B1
insert values
Insertion values specified in an INSERT statement
425B5
insert columns
Insertion columns specified in an INSERT statement
425B6
update columns
Update columns specified in an UPDATE statement
425B7
derived columns
Columns specified in a derived columns list
425BB
with columns
Columns in WITH clauses
425BC
DISTINCT set functions
DISTINCT set function specified in a query specification as a set function
425BJ
view columns
Columns in view definitions
425C1
foreign keys
Foreign keys
425C2
authorization identifier
Authorization identifier specified in the SQL statement
425CA
value expression
Value expressions
425CF
nests of value expression
Levels of nested value expressions
425CG
nests of subquery
Nested subqueries
425CH
- bb....bb:
-
Maximum that can be specified
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the number of aa....aa to bb....bb or less.
-
If you specify viewed tables or query names, apply the internal derived table corresponding to each specification, and then calculate the maximum number of specifications.
-
If you specify archivable multi-chunk tables, calculate the maximum number of specifications based on the SQL statement that has been converted to a derived table by equivalent exchange.
For details about equivalent exchange of archivable multi-chunk tables, see Equivalent exchange of SQL statements that search archivable multi-chunk tables in the HADB Application Development Guide.
If this message is output in either of the following cases, take the corrective action described under Procedure.
-
The ALTER VIEW statement is executed.
-
A viewed table is re-created during version upgrading of the HADB server.
For details, see Re-creation of viewed tables in the event of a version upgrade in Notes on version upgrading in the HADB Setup and Operation Guide.
Procedure
-
Check viewed table definition information.
Check the CREATE VIEW statement that was used when the target viewed table was defined. You can acquire viewed table definition information by searching a dictionary table. For details about examples of searching the dictionary table, see Finding out viewed table definition information in Searching a dictionary table in the HADB Setup and Operation Guide.
-
Delete the viewed table.
Delete the target viewed table by using the DROP VIEW statement.
-
Correct the information specified in the CREATE VIEW statement.
Correct the information specified in the CREATE VIEW statement you checked in step 1.
-
Redefine the viewed table by using the CREATE VIEW statement.
Use the CREATE VIEW statement you corrected in step 3 to redefine the viewed table deleted in step 2.
If this message is output because an asterisk (*) is specified in the selection expression for the query specification in the CREATE VIEW statement, do not specify the asterisk (*). Correct the information specified in the CREATE VIEW statement to explicitly specify the column name in the selection expression for the query specification.
-