DB2- SQL messages

Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Select the number of the message you require details about:

DB2-1001-00-E Not a valid column name
The named column does not belong to the table.
DB2-1002-00-W Cursor not declared
DB2-1003-00-E Not WHERE or NOWHERE or NULL keyword
Invalid call keyword.
DB2-1004-00-W This statement will modify an entire table
DB-MODIFY call updates the entire table.
DB2-1005-00-E No record name defined
You did not specify the record name in the call.
DB2-1006-00-E COLUMN not inserted and declared not null
The specified column name is not inserted but declared not null.
DB2-1007-00-E WHERE not allowed on STORE
AMB does not allow the WHERE keyword in a DB-STORE call.
DB2-1008-00-W This statement will erase an entire table
AMB will delete all rows in the table.
DB2-1009-00-W Cursor not declared
You did not declare the cursor name.
DB2-1010-00-E No column names allowed on ERASE
It is Invalid to delete a column.
DB2-1011-00-W OBTAIN needs a WHERE clause or it can retrieve multiple rows
The coded call may retrieve multiple rows.
DB2-1012-00-E CANNOT OBTAIN WHERE CURRENT NEED CURSOR AND FETCH
Keyword WHERE CURRENT invalid in DB-OBTAIN call.
DB2-1013-00-E Declare cursor more than once
The named cursor already used.
DB2-1014-00-E Command cannot have WHERE CURRENT OF
Do not use WHERE CURRENT OF with this call.
DB2-1015-00-E No cursor name defined
Code cursor name for this call.
DB2-1016-00-E Keyword not allowed as record name
Keyword is already used as record name. Code a record name instead of a keyword in the call.
DB2-1017-00-E UPDATE specified but no column name follows keyword
Enter column name after keyword UPDATE or remove empty UPDATE from the call.
DB2-1018-00-E Parameter not WHERE or NULL or NOWHERE or UPDATE or ORDER
Invalid parameter.
DB2-1019-00-E Invalid column name after UPDATE
The named column in UPDATE clause does not belong to the table.
DB2-1020-00-F Name not found in DDISYMB
The specified record name not found in DDISYMB.
DB2-1021-00-E WHERE search condition not found
Enter a search condition in the WHERE clause, or remove the empty WHERE.
DB2-1022-00-E FROM not allowed with
Do not use the FROM keyword with this call.
DB2-1023-00-E INTO not allowed with
Do not use the INTO keyword with this call.
DB2-1024-00-E DB-PROCESS-ID is valid only with the DB-PROCESS call
DB2-1025-00-E ORDER specified but no column name follows keyword
DB2-1026-00-E Invalid column name after ORDER
AMB could not find the named column in ORDER clause in the result table.
DB2-1027-00-E Cannot have UPDATE and ORDER in same cursor declaration
Code UPDATE or ORDER in a single cursor declaration.
DB2-1028-00-I Column name specified in the UPDATE clause will be updated
AMB will update the named column in UPDATE clause.
DB2-1029-00-E INTO or FROM keyword has no structure name
Code the structure name after FROM or INTO.
DB2-1030-00-E DB-PROCESS-ID keyword has no ID name following it
DB2-1031-00-E Found more than once in command
Remove the extra keyword.
DB2-1032-00-E END or ENDWHERE specified and had no WHERE clause
DB2-1033-00-E Keyword only valid for DB-PROCESS and DB-DECLARE
DB2-1034-00-E WHERE clause found after END or ENDWHERE
Check for a valid WHERE clause.
DB2-1035-00-E NOWHERE clause specified and there is a WHERE clause
Cannot use NOWHERE or WHERE in the same call.
DB2-1036-00-E NOWHERE clause specified and there is an END or ENDWHERE
END or ENDWHERE are invalid for NOWHERE.
DB2-1037-00-E When WHERE clause is present UPDATE or ORDER must follow after
Found WHERE after UPDATE or ORDER.
DB2-1038-00-E Cannot have CURRENT keyword with a NOWHERE clause
CURRENT is invalid in a NOWHERE clause.
DB2-1039-00-E Found CURRENT keyword before finding WHERE clause
CURRENT valid only with WHERE (WHERE CURRENT OF).
DB2-1040-00-E Invalid use of WHERESQL with CURRENT
You used WHERESQL CURRENT OF instead of WHERE CURRENT OF.
DB2-1042-00-E CURSOR longer than 12 characters
The named cursor is longer than the maximum length of 12 characters.
DB2-1043-00-E -ID name longer than 10 characters
DB2-1045-00-E Individual cols and builtin functions should not be mixed
Do not select individual columns in a query if also using a built-in function.
DB2-1046-00-E Syntax invalid for SELECT DISTINCT
You either used the keyword DISTINCT more than once in a subselect, or it you did not place it directly before the column select list.
DB2-1047-00-E Not a valid built-in function
You coded a built-in function other than MAX, MIN, AVG, SUM or COUNT.
DB2-1048-00-E DISTINCT modifier required for COUNT
Syntax for the built-in function COUNT requires the keyword DISTINCT.
DB2-1049-00-E Invalid function argument -
The argument given in a function is not a valid data type for that function.
DB2-1050-00-E Cannot return result -
AMB cannot determine the result field for a function.
DB2-1051-00-E Cannot create function result -
Something other than Y or N specified for the CREATE RESULT field indicator.
DB2-1052-00-E Invalid use of DB-LOOP-MAX keyword
DB-LOOP-MAX is valid for DB-PROCESS calls only. You included DB-LOOP-MAX included in a call other than a DB-PROCESS.
DB2-1053-00-E Invalid use of UNION keyword
The following conditions can cause this message:
DB2-1054-00-E UNION select list incompatible
The select lists of each query in a UNION are not the same length.
DB2-1055-00-E Data type of column in function cannot be found - regen subschema
To process SQL functions, AMB SQL needs data type information for each column. The current data view does not contain data type information for all columns.
DB2-1056-00-E Indicator structure not found for CURSOR
A fatal error occurred as a DB-MODIFY call processed either the cursor or the indicator structure for the cursor.
DB2-1057-00-E Indicator structure not found for TABLE
A fatal error occurred in processing the indicator structure for the named table.
DB2-1058-00-E INSERT table cannot be the same as SUBSELECT table
You named the table or view into which data is being inserted by a DB-STORE as the source from where a subselect is drawing that data. The object of an insert cannot be the same as the object of the subselect.
DB2-1059-00-E Columns in SUBSELECT result table do not match insert column list
Select lists for insert and subselect are not the same length.
DB2-1060-00-E GROUP BY specified but no column name follows keyword
No column name given after the GROUP keyword.
DB2-1061-00-E Invalid column name after GROUP
AMB could not find a column named in the GROUP BY clause in the SELECT list.
DB2-1062-00-E Different location names seen in UNION
You cannot execute a UNION of tables from two or more different locations. Refer only to tables in the same location.
DB2-1063-00-E Different location names seen in Join
You cannot Join tables from two or more different locations. Refer only to tables in the same location.
DB2-1064-00-E Cannot INSERT DELETE or UPDATE from remote location if using CICS or IMS
When accessing remote tables or views via the CICS or IMS/VS attachment facility, you cannot use INSERT, DELETE, or UPDATE statements.
DB2-1065-00-E DISTINCT invalid or used more than once in a statement
Either the DISTINCT keyword is invalid as used, or it appears more than once in a statement.
DB2-1066-00-E COMMIT-ROLLBACK not supported in non-ISPF environment
You attempted to use the DB-COMMIT call in a CICS or IMS program.
DB2-1067-00-E COMMIT with HOLD parameter not supported unless using SQL-400
When coding a DB-COMMIT, do not code the HOLD parameter unless the SQL target is SQL/400.
DB2-1068-00-E Invalid parameter specified for command
DB2-1069-00-E WITH HOLD expected Found An unexpected keyword found following WITH
DB2-1070-00-E Number of row expected
An unexpected keyword was found following OPTIMIZE.
DB2-1071-00-I FETCH ONLY assumed
An unexpected keyword was found following FETCH. The only valid keyword to immediately follow FETCH is ONLY. .
DB2-1072-00-E In EXPR arithmetic operator applied to CHAR
When evaluating the arithmetic expression indicated, a column with a CHARACTER data type encountered.
DB2-1073-00-E Mixed data types - creation of result field not supported
While evaluating a function in which you specified Y to allow AMB to create the result field, AMB encountered columns with more than one data type. AMB cannot correctly create a result field for the function under these circumstances.
DB2-1074-00-E Command supported for SQLSVR only
The database call is supported for SQL SERVER (SQLSVR) only.
DB2-1075-00-E Keyword supported for SQLSVR only
The keyword is only supported for SQL SERVER (SQLSVR).
DB2-1076-00-E UPDATE keyword is invalid for SQLSVR
In a DB-PROCESS or DB-DECLARE, the UPDATE keyword is invalid if your SQL target is SQL SERVER.
DB2-1077-00-E Cannot have BROWSE and HOLDLOCK in same cursor declaration
The HOLDLOCK keyword restricts a shared lock on a specific table by holding it until completion of a transaction. The HOLDLOCK and BROWSE keywords are mutually exclusive.
DB2-1078-00-E AUTO keyword is only valid for DC targets PM and WIN
Current DC currentdc. AMB only allows the AUTO keyword for DB-CONNECT under PM and WIN.
DB2-1079-00-E DB2-AUTO-COMMIT disabled for SQLSVR
AMB does not support the DB2-AUTO-COMMIT option, which automatically generates a commit after a DB-MODIFY, DB-STORE, DB-ERASE or DB-CLOSE, for SQL SERVER targets.
DB2-1080-00-I DB-COMMIT used without DB-BEGIN-TRAN
AMB found a DB-COMMIT that is not preceded by a DB-BEGIN-TRAN.
DB2-1081-00-E DB-BEGIN-TRAN used without DB-COMMIT
DB2-1082-00-E Keyword supported for ORACLE only
This keyword is only supported for ORACLE.
DB2-1083-00-E Command - cannot have AT-DBNAME clause
The AT-DBNAME clause is only valid for DB-PROCESS, DB-DECLARE, DB-STORE, DB-OBTAIN, DB-ERASE, and DB-MODIFY database calls.
DB2-1084-00-E Command supported for ORACLE only
This database call is supported for ORACLE only.
DB2-1086-00-E Expression not valid for command
AMB SQL supports expressions for DB-DECLARE, DB-OBTAIN, and DB-PROCESS calls. Expressions in all other AMB SQL calls are invalid.

Parent topic: Error Messages