OS/400 Messages
Description
SQL function not supported on prior release. Function is - &1.
COMMIT(*CHG) requested but not allowed.
Job &3/&2/&1 used for SQL server mode processing.
&1 was created, changed, or dropped, but object not modified.
Trigger &1 created in &2.
Drop of trigger &1 in &2 complete.
Triggered action exception - SQLSTATE &1, SQLCODE &2.
RESIGNAL error occurred - SQLSTATE &1, SQLCODE &2.
HOLD LOCATOR statement complete.
SET CURRENT SCHEMA statement complete.
Access plan for SQL statement has been built.
Reusable ODP deleted. Reason code &1.
Data conversion required on FETCH or embedded SELECT.
Sequence &1 was created in &2.
ALTER completed for sequence &1 in &2.
REFRESH TABLE statement complete.
SET ENCRYPTION PASSWORD statement complete.
SQL package name &1 specified but RDB parameter not specified.
Syntax error - SQLSTATE &1, SQLCODE &2.
Warning - SQLSTATE &1, SQLCODE &2.
No data - SQLSTATE &1, SQLCODE &2.
Cardinality violation - SQLSTATE &1, SQLCODE &2.
Data exception - SQLSTATE &1, SQLCODE &2.
Integrity constraint violation - SQLSTATE &1, SQLCODE &2.
Cursor state not valid - SQLSTATE &1, SQLCODE &2.
Statement name not valid - SQLSTATE &1, SQLCODE &2.
Transaction rollback - SQLSTATE &1, SQLCODE &2.
RESIGNAL statement complete.
SIGNAL statement complete.
GET DIAGNOSTICS statement complete.
ALLOCATE DESCRIPTOR statement complete.
Syntax error or access violation - SQLSTATE &1, SQLCODE &2.
Application error - SQLSTATE &1, SQLCODE &2.
Name not valid - SQLSTATE &1, SQLCODE &2.
Operand not valid - SQLSTATE &1, SQLCODE &2.
Limit exceeded - SQLSTATE &1, SQLCODE &2.
Object not in required state - SQLSTATE &1, SQLCODE &2.
Function restricted - SQLSTATE &1, SQLCODE &2.
Resource error - SQLSTATE &1, SQLCODE &2.
System error - SQLSTATE &1, SQLCODE &2.
Data conversion required on INSERT or UPDATE.
DEALLOCATE DESCRIPTOR statement complete.
GET DESCRIPTOR statement complete.
SET DESCRIPTOR statement complete.
Routine &1 was altered in &2.
MERGE statement complete.
SQLSTATE class unknown - SQLSTATE &1, SQLCODE &2.
Application process not at a commit boundary.
External function call exception - SQLSTATE &1, SQLCODE &2.
SQL function call exception - SQLSTATE &1, SQLCODE &2.
Case not found for CASE statement - SQLSTATE &1, SQLCODE &2.
Token is not valid - SQLSTATE &1, SQLCODE &2.
Path is not valid on SET PATH statement - SQLSTATE &1, SQLCODE &2.
FREE LOCATOR statement complete.
VALUES statement complete.
SET CURRENT DEGREE statement complete.
SET CURRENT DECFLOAT ROUNDING MODE statement complete.
Cursor &1 allocated for result set.
ASSOCIATE RESULT SET LOCATOR statement complete.
Describe of cursor &1 completed.
DESCRIBE PROCEDURE statement completed.
Drop of &1 in &2 complete.
Index &1 created in &3 on table &2 in &6.
&3 rows deleted from &1 in &2.
&3 rows inserted in &1 in &2.
&3 rows updated in &1 in &2.
SET CURRENT IMPLICIT XMLPARSE OPTION statement complete.
&2 rows fetched from cursor &1.
Embedded SELECT completed.
&3 for &1 in &2 completed.
&3 of authority to &1 in &2 completed.
PREPARE of statement &1 completed.
DESCRIBE of prepared statement &1 completed.
CONNECT to relational database &1 completed.
Already connected to relational database &1.
Current connection is to relational database &1.
SQL create package syntax check of &3 is complete.
SQL create package for &3 in &2 has failed.
SQL package &3 in &2 has been created.
EXECUTE IMMEDIATE completed.
DESCRIBE of table &1 completed.
SQL package &2 in &3 at &1 has been created.
SET TRANSACTION complete.
SET CONNECTION to relational database &1 completed.
RELEASE of relational database &1 completed.
DISCONNECT of all connected relational databases completed.
RELEASE of all relational databases completed.
ALTER completed for table &1 in &2.
Procedure &1 was created in &2.
DROP PROCEDURE statement complete.
SET RESULT SETS statement complete.
CONNECT to relational database &1 completed over TCP/IP.
Already connected to relational database &1.
&1 result sets processed by the SET RESULT SETS statement.
Distinct type or array type &1 created in &2.
Function &1 was created in &2.
DROP FUNCTION statement complete.
SET PATH statement complete.
SET SESSION AUTHORIZATION statement complete.
&3 for routine &1 completed, but cannot be saved and restored.
The following special registers have been set: &1
SET CURRENT DEBUG MODE statement complete.
Variable &1 was created in &2.
Unable to open printer file &1 in &2.
Member &3 file &1 in &2 not found.
MBR(*ALL) specified on override of file &1.
Precompile ended. Exception &4 received from module &5.
File &1 in &2 not source file.
MARGINS(*SRCFILE) was specified and right margin is &1. Right margin cannot exceed 80.
SQL sent record type &1 to Application Development Manager, message ID &2 returned.
Internal failure: message &1, &2.
Debug view creation failed: message &1, &2.
DB2 for i5/OS Query Manager and SQL Development Kit not available.
Unable to open printer file &1 in &2.
PRTSQLINF ended. Exception &4 received from module &5.
Events file information creation failed: message &1.
DBGVIEW(*SOURCE) not supported when more than one statement on a source record.
TOSRCFILE and SRCFILE must be different files.
Source member &1 is too large.
Value in parameter DECRESULT not valid.
CCSID &1 not supported by SQL.
Parameter SRCMBR not allowed with parameter SRCSTMF.
Parameter INCDIR not allowed with parameter INCFILE.
Source stream file could not be opened.
Parameter SRCMBR required.
Parameter SRCFILE not allowed with parameter SRCSTMF.
Source stream file margins exceeded.
Parameter SRCFILE or SRCSTMF required.
Parameter INCDIR not allowed with parameter SRCFILE.
Parameter INCFILE not allowed with parameter SRCSTMF.
Parameter DBGENCKEY requires parameter DBGVIEW(*SOURCE).
Conflict in TGTRLS and DBGENCKEY parameters.
Conflict in TGTRLS parameters for SQL precompile and &7 compile.
&7 Compile at wrong level for SQL source.
Create of SQL package failed.
COMMIT or ROLLBACK failed on remote database.
DB2 Query Mgr and SQL DevKit not at same install level as the operating system.
Damage to SQL package &1 prevents operation on SQL package.
Library &2 not correct for restore of SQL package &1.
Member &2 file &1 in &3 changed since precompile.
RUNSQLSTM command failed.
Print of SQL information failed.
IBM DB2 Query Manager and SQL Development Kit for i not available.
IBM DB2 Query Manager and SQL Development Kit for i license not released.
Program or service program &1 restored but not created as SQL object &3 in &2.
SQL user-defined type &1 in library &2 not saved or restored.
User-defined type &1 in &2 cannot be deleted.
Access plans not saved for program &1 in &2.
&1 in &2 type *DTAARA is not an SQL Sequence.
SQLXSR object &1 in library &2 not restored.
PASSWORD parameter required when USER specified.
RDB parameter required when PASSWORD specified.
RDB parameter required when USER specified.
RDB parameter required when SQLPKG specified.
DFTRDBCOL parameter required when DYNDFTCOL(*YES) specified.
TERASPACE(*YES) parameter required when STGMDL specified.
OBJTYPE not allowed when OBJ(*JOB) specified.
Conflicting values specified for the DECRESULT parameter.
Conflicting values specified for the INCFILE parameter.
Source type...............&1
Program name..............&1
Source file...............&1
Member....................&1
Options...................&1
Commit....................&1
Generation level..........&1
Margins...................&1
Printer file..............&1
Text......................&1
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
* * * * * E N D O F S O U R C E * * * * *
* * * * * E N D O F L I S T I N G * * * * *
Source member changed on &1
INCLUDE file..............&1
Total Info Warning Error Severe Terminal
No errors found in source
&1 level severity errors found in source
&1 Source records processed
Data Names Define Reference
Target release............&1
Relational database.......&1
Replace...................&1
Default collection........&1
Date format...............&1
Time format...............&1
IBM SQL flagging..........&1
ANS flagging..............&1
Package name..............&1
Allow copy of data........&1
Close SQL cursor..........&1
Date separator............&1
Time separator ...........&1
Source file CCSID.........&1
Job CCSID.................&1
Allow blocking............&1
Delay PREPARE.............&1
User .....................&1
Password .................&1
Created object type.......&1
Debugging view............&1
Module list...............&1
Dynamic user profile......&1
Sort sequence.............&1
Language ID...............&1
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change Comments
Listing option............&1
Object name...............&1
Object type...............&1
Naming....................&1
Decimal point.............&1
RDB connect method........&1
Create SQL ILE COBOL Object
Create SQL FORTRAN Program
Create SQL ILE RPG Object
User profile .............&1
Statement processing......&1
Create SQL ILE C++ Source
To source file............&1
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0 SEQNBR Last change
COLLECTION - created by SQL
collection..............&1
Path......................&1
Maximum precision.......&1
Maximum scale...........&1
Minimum divide scale....&1
SQL rules.................&1
RPG preprocessor options..&1
Compiler options..........&1
DECFLOAT rounding mode....&1
Source stream file........&1
SQL INCLUDE directory.....&1
Right margin..............&1
resolution..............&1
Debugging encryption key..&1
Relational Database: &1&2
Statement names . . . . . . . . .
Table . . . . . . . . . . .
File . . . . . . . . . . .
Help index for DB2 SQL for i5/OS
User . . . . . . . . . . .
Package . . . . . . . . . .
Partitioning Keys . . . .
Specify BEGIN DECLARE SECTION Statement
Specify END DECLARE SECTION Statement
Specify CREATE COLLECTION Statement
Specify DROP COLLECTION Statement
Specify INCLUDE Statement
Specify EXECUTE IMMEDIATE Statement
Specify DROP TABLE Statement
Specify DROP VIEW Statement
Specify DROP INDEX Statement
Specify ROLLBACK Statement
Specify PREPARE Statement
Specify WHENEVER Statement
Specify LOCK TABLE Statement
Specify DROP ALIAS Statement
Specify CREATE ALIAS Statement
Specify CREATE INDEX Statement
Specify CREATE TABLE Statement
Specify DECLARE CURSOR Statement
Specify DECLARE STATEMENT Statement
Specify DECLARE TABLE Statement
Specify DESCRIBE Statement
Specify EXECUTE Statement
Specify GRANT TABLE Statement
Specify REVOKE TABLE Statement
Specify DESCRIBE TABLE Statement
Specify CONNECT Statement
Specify DECLARE VARIABLE Statement
Specify GRANT PACKAGE Statement
Specify REVOKE PACKAGE Statement
Specify DROP PACKAGE Statement
Change Session Attributes
FROM files . . . . . . . . .
FROM tables . . . . . . . .
SELECT fields . . . . . . .
SELECT columns . . . . . . .
WHERE conditions . . . . . .
WHERE conditions . . . . . .
GROUP BY fields . . . . . .
GROUP BY columns . . . . . .
HAVING conditions . . . . .
HAVING conditions . . . . .
ORDER BY fields . . . . . .
ORDER BY columns . . . . . .
FOR UPDATE OF fields . . . .
FOR UPDATE OF columns . . .
INTO variables . . . . . . .
INTO variables . . . . . . .
INSERT into field . . . . .
INSERT into column . . . . .
View field . . . . . . . . .
View column . . . . . . . .
Specify SELECT INTO Statement
Specify CREATE VIEW Statement
Specify COMMENT ON Statement
Specify LABEL ON Statement
/* Interactive SQL request processor is active */
Column, Table and Collection Names
Field, File, and Library Names
Type information, press Enter.
Nulls: 1=NULL, 2=NOT NULL, 3=NOT NULL WITH DEFAULT
Data: 1=BIT, 2=SBCS, 3=MIXED, 4=CCSID
Specify SET TRANSACTION Statement
Specify DECLARE PROCEDURE Statement
Default . . . . . . . . .
Specify SET CONNECTION Statement
Specify RELEASE Statement
Specify DISCONNECT Statement
Specify ALTER TABLE Statement
Type CHECK conditions for this column, press Enter.
Type CHECK conditions for this field, press Enter.
Type one REFERENCES choice per line, press Enter.
Type one SELECT choice per line, press Enter.
Type one UPDATE choice per line, press Enter.
Type options to select REFERENCES choices, press Enter.
Type options to select SELECT choices, press Enter.
Type options to select UPDATE choices, press Enter.
Specify CREATE PROCEDURE Statement
?CPY ?*OBJ('&1') TOOBJ('&1')
?REN ?*OBJ('&1') NEWOBJ(' ')
Message &1 not found in message file.
System configuration list printout was created.
Additional data required to process request.
Main card enclosure must exist in system configuration.
Frame &1 does not exist in system configuration.
No card enclosure at location &1 of frame &2.
Space reserved in system configuration.
Frame identifier value not correct.
EIA location value not correct.
Card position value not allowed.
Device position value not allowed.
Frame ID &1 already exists in system configuration.
Port value &1 not correct.
Replace option must be either Y or N.
System configuration copied to file &1 in &2.
Specified file not a physical file.
File record length not 100 bytes.
File could not be created.
File &1 not found in library &2.
System configuration does not contain main card enclosure.
No system configuration data exists for device &1.
No system configuration data exists for card &1.
No system configuration data exists for &1 card enclosure.
Bus extension cable missing.
Bus extension cable not connected.
New system configuration information stored by system.
Duplicated relative location.
Device position value already used in the enclosure.
Option for frame relative location not correct.
Specified frame type or model not supported.
Resource &1 cannot be removed.
Port same as port selected for automatic call.
Work with Hardware Products command cannot be run at this time.
Port &1 of frame &2 being used for another cable.
Additional data required to process FROM end.
Additional data required to process TO end.
Additional data required to process second TO end.
Cable not added because of incorrect input.
Port &1 of device &2 at location &3 being used.
Two ends of same cable cannot connect to same device.
Two ends of same cable cannot connect to same frame.
New cable added to system configuration.
Port &1 not correct for power source.
No value was typed in system number field.
Two ends of same cable cannot connect to same device.
&1 not storage device controller.
&1 not IPI-3 cabled device.
System cannot find card &1 at specified location.
Port &1 of card &2 being used.
Card feature &1 not work station controller card.
FROM end not disk controller.
EIA location not in valid range for frame &1.
EIA location exceeds top of frame.
EIA location &1 already occupied.
New filler panel added to system configuration.
Only one entry can be selected.
Format of serial number not correct.
System unit information changed.
Expansion unit information changed.
System configuration list printout was created.
No empty positions in card enclosure
Change function not allowed.
Remove function not allowed.
Model number of main card enclosure not recognized.
Neither cable end defined.
Work station cable end not defined.
Card type not correct for cable type.
Type number &1 not correct for cable type.
Change and remove functions not allowed for ports.
Bus extension card &1 cannot be removed.
No value was typed in system type field.
System type value not valid.
No value specified for required field.
Cable data should be checked.
Tape I/O adapter value must be alphabetic character.
No cables of this type in system configuration
One entry must be selected.
Internal objects not usable.
Internal failure in WRKHDWPRD command.
System configuration information missing.
Selected function cannot be performed.
System configuration was not replaced.
Serial number of resource &1 cannot be changed.
No disk units in enclosure.
Type number must be either 5030 or 5040.
Change and remove functions not allowed for power regulators.
Card type &1 not correct.
Port &1 of frame &2 not correct.
System unit models are not the same.
Remove function not allowed.
Frame identifier already exists.
Value for power control of frame not correct.
Value for cabling option not correct.
The enclosure is not supported on this frame.
The device is not supported on this type of frame.
Identified frame type conflicts with cards and devices contained on this bus/board
Requested function is not supported on this frame type
Enter Y if device is in a frame, N if device is stand-alone
Enter 'Y' if the card in position 1 is a double-wide, enter 'N' if the card is not a double-wide.
Value for IBM product question not correct.
Value for number of device frames not correct.
Value for number of storage frames not correct.
Value for device in tape library question not correct.
An incorrect response has been entered to the 'Move cards' question.
The target frame id must be entered.
Tape library already exists
Number of device frames with tape units not correct
Change function not allowed for Tape Library Storage Frame
Number of device frames not correct.
Value for number of tape devices not correct.
Value for library frame not correct.
Value for device position not correct.
No empty device frames to delete.
Tape library cannot be removed
Device frame not removed.
Not authorized to Work with Hardware Products command.
Count: 626 sap01-206 ( 675 ms )
This documentation is copyright by IBM.