KFAA30129-E

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

1. 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.

2. Delete the viewed table.

   Delete the target viewed table by using the DROP VIEW statement.

3. Correct the information specified in the CREATE VIEW statement.

   Correct the information specified in the CREATE VIEW statement you checked in step 1.

4. 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.