OS/400 Messages

Are you looking for the description of OS/400 (System i) messages e.g. CPF9801? Then you have come to the right place. Below you can see a (hoefully) complete list of of all OS/400 messages with all “second level texts”.

Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43


Complete OS/400 Messages Documentation From SQL7906 up to SYS1566

Complete OS/400 Messages Documentation From SQL7906 up to SYS1566

This documentation is copyright by IBM.
Count: 626 Skipped: 0
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.
SQL cursors closed.
ODP reused.
ODP created.
ODP deleted.
ODP not deleted.
Access plan for SQL statement has been built.
Blocking used for query.
Access plan not updated.
Reusable ODP deleted. Reason code &1.
Data conversion required on FETCH or embedded SELECT.
Savepoint &1 set.
Savepoint &1 released.
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.
Schema &1 not created.
Schema &1 not dropped.
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.
SET 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.
Table &1 created in &2.
View &1 created in &2.
Schema &1 created.
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.
Table &1 in &2 locked.
Cursor &1 was closed.
SET CURRENT IMPLICIT XMLPARSE OPTION statement complete.
Commit completed.
Rollback completed.
Cursor &1 opened.
&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 completed.
EXECUTE IMMEDIATE completed.
&1 statement completed.
DESCRIBE of table &1 completed.
CONNECT 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 completed.
CALL statement complete.
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.
Alias &1 created in &2.
&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.
SQL precompile failed.
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.
Remote Connection Active
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.
SQL precompile failed.
&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 * * * * *
DIAGNOSTIC MESSAGES
CROSS REFERENCE
Source member changed on &1
Position
MSG ID SEV RECORD TEXT
INCLUDE file..............&1
Message Summary
Total Info Warning Error Severe Terminal
&1 &2 &3 &4 &5 &6
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
Severity
Record
Message . . . . :
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
SQL Root Source View
SQL Include View
SQL Output View
RDB connect method........&1
Print SQL information
Program
SQL package
Service program
Create SQL ILE C Object
Create SQL C Program
Create SQL ILE COBOL Object
Create SQL COBOL Program
Create SQL FORTRAN Program
Create SQL PL/I Program
Create SQL ILE RPG Object
Create SQL RPG Program
Run SQL Statements
User profile .............&1
Statement processing......&1
Create SQL ILE C++ Source
To source file............&1
Convert SQL C++ Source
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 ...+... 9 ...+... 0 SEQNBR Last change
COLLECTION - created by SQL
SQL catalog view
<END-OF-STATEMENT>
Dynamic default
collection..............&1
Path......................&1
Page
Decimal result options:
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
&1
Concurrent access
resolution..............&1
Debugging encryption key..&1
Generate SQL
Version: &1&2 &3
Generated on: &1&2
Relational Database: &1&2
Standards Option: &1&2
*NONE
*CHG
*ALL
*SYS
*SQL
*RUN
*VLD
*SYN
DISPLAY
PRINTER
OUTFILE
*USRLIBL
*LIBL
*ALLUSR
*ALL
*CURLIB
*ALL
*SQL
Interactive SQL Session
Page
*ALWAYS
*FORWARD
*NONE
*C
*COBOL
*PLI
*RPG
*SYSVAL
*PERIOD
*COMMA
Enter SQL Statements
Confirm Statement
*APOSTSQL
*QUOTESQL
*FTN
Statement names . . . . . . . . .
Table . . . . . . . . . . .
File . . . . . . . . . . .
Help index for DB2 SQL for i5/OS
Name, F4 for list
Name, PUBLIC
Name
User . . . . . . . . . . .
*CS
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 CLOSE Statement
Specify COMMIT 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 DELETE Statement
Specify DESCRIBE Statement
Specify EXECUTE Statement
Specify FETCH Statement
Specify GRANT TABLE Statement
Specify OPEN 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 . . . . .
Name
View field . . . . . . . . .
View column . . . . . . . .
Specify SELECT Statement
Specify SELECT INTO Statement
Specify INSERT Statement
Specify CREATE VIEW Statement
Specify UPDATE Statement
Specify COMMENT ON Statement
Specify LABEL ON Statement
/* Interactive SQL request processor is active */
*YES
*OPTIMIZE
*NO
*USA
*ISO
*EUR
*JIS
*MDY
*DMY
*YMD
*JUL
*HMS
*BLANK
*JOB
*JOBRUN
*LANGIDUNQ
*LANGIDSHR
*HEX
*JOB
*JOBRUN
Column, Table and Collection Names
Field, File, and Library Names
Column Names
Field Names
CREATE VIEW Names
Press Enter.
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
Specify CALL Statement
Default . . . . . . . . .
Columns . . . . . .
Name, F4 for list
1=Add 2=Change 4=Drop
Table Name
File Name
View Name
Index Name
Correlation Name
Constraint Name
Procedure Name
Parameter Name
Specify SET CONNECTION Statement
Specify RELEASE Statement
Specify DISCONNECT Statement
Fields . . . . . . .
Specify ALTER TABLE Statement
*RR
*NC
*UR
*RS
Type CHECK conditions for this column, press Enter.
Type CHECK conditions for this field, press Enter.
Columns . . . . . . .
Fields . . . . . . . .
Alias Name
Data Type Name
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.
(column)
(field)
Specify RENAME Statement
Specify CREATE PROCEDURE Statement
EDTF STMF('&1')
?CPY ?*OBJ('&1') TOOBJ('&1')
?DEL OBJLNK('&1')
DSPF STMF('&1')
PRTSTMF STMF('&1')
?REN ?*OBJ('&1') NEWOBJ(' ')
WRKAUT OBJ('&1')
WRKIFSLCK STMF('&1')
?MOV ?*OBJ('&1')
WRKLNK OBJ('&1*')
0.75M Ext. Tower
Lotus Notes Adapter
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.
Data not valid.
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.
File already exists.
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.
Option not valid.
Option not valid.
Option not valid.
Option not valid.
Option not valid.
Option not valid.
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.
TO end not disk unit.
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
Printer &1 not found.
Change function not allowed.
Remove function not allowed.
Model number of main card enclosure not recognized.
Blank field not allowed.
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.
Record not found.
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.
EIA information ignored.
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.

Length: 114720 Date: 20200923 Time: 200121

Count: 626     sap01-206 ( 922 ms ) This documentation is copyright by IBM.