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 QMR0335 up to QRY1686

Complete OS/400 Messages Documentation From QMR0335 up to QRY1686

This documentation is copyright by IBM.
Count: 645 Skipped: 0
OS/400 Messages
Description
Cannot add a blank row.
Cannot create a blank table definition.
Table copied with warnings. Press F19 to add rows.
Length is not valid.
Enter a maximum of &1 decimal places.
Too many columns.
Not a valid number.
Value is too large for column type.
Value is too small for column type.
Value has too many decimal places for this column type.
String is too long for this column.
Date not valid.
Time not valid.
Search grouping not valid.
Search column not valid.
Number of parentheses do not match.
Enter a test and value with the column name.
Statement exceeds maximum length for batch.
Columns and types do not match. Data not copied.
Table exists and replace = N. Table not created.
Table exists and replace = N. Data not copied.
Duplicate column name.
You must specify length before you enter decimal places.
Internal error. Your request was not completed.
Warning. You may not be able to add all of your data.
The value you entered is not valid graphic data.
The value you entered is not valid DBCS data.
The value you entered is not valid data.
Creation of non system table name in QTEMP not allowed.
A table containing Unicode data cannot be copied.
The table contains data that cannot be changed.
Data cannot be added to the table.
The table contains data that cannot be displayed.
A search cannot be done with Unicode data.
Rename of a long table name not allowed.
Table &1 in library &2 was deleted.
DRAW statement allowed only from the Edit Query display.
Full report data does not exist.
Query Manager statement not valid.
Too many parameters specified.
Display not authorized.
Missing or mismatched quotes in statement.
No query name specified.
Statement not valid from DB2 for i5/OS Query Manager.
Library or Collection name cannot exceed 10 characters.
Table or File name cannot exceed 10 characters.
STRQM in progress. Starting DB2 for i5/OS Query Manager...
Connection failed. Press Enter to connect locally.
User ID cannot be blank.
Value for user ID exceeds maximum length.
Password value required.
User ID cannot contain a period.
Communications error trying to CONNECT.
&1 not in the relational database directory.
CONNECT to relational database &1 successful.
&1 &2 operation completed successfully.
Form exists. Rename, or press Enter to replace.
Query exists. Rename, or press Enter to replace.
Form and Query exist. Rename, or press Enter to replace.
Column &1 does not exist in table.
Expression &1 is not valid.
&1 cannot be selected for column &2.
Summary functions not valid for &1.
Summary functions not valid for expression &1.
Column &1 already defined.
&1 cannot be used as an expression name.
&1 is not a correct expression name.
A named expression cannot be blank.
Cannot prompt with cursor in this location.
Field value is not a correct table name.
You cannot display a new list with options pending.
You cannot change the list while pressing a page key.
You cannot copy &1 to itself.
Object &1 selected more than once.
You cannot change list while pressing a function key.
No tables selected. Query cannot be displayed or run.
Prompted query definition contains errors.
&1 is not an SQL collection name.
From column or field is missing.
From column does not exist in selected tables.
Join test required.
Unknown join test.
To column or field is missing.
To column does not exist in selected tables.
Correlation name &1 is undefined.
Column or Field data type is not allowed on a join.
Join columns must be from different tables.
Only one column or field can be selected.
You must specify tables before selecting other options.
*LIBL is not supported on a remote connection.
Column or Field data types are incompatible.
All tables or files must be joined together.
Circular relationship detected.
Select one of the tests displayed in the list.
Type AND or OR to join this test to the previous one(s).
Type IS or ISNOT to complete the test.
Type a comparison value(s) to complete the test.
Enter two values to complete the BT comparison test.
Enter a Test operator to complete the comparison test.
Column, field, or expression not valid.
Do not specify values when the Test operator is NL.
You need to specify only two values for BT (Between).
Specify the Test operator before the Value(s).
Move cursor to a Previous Comparison Test, press Enter.
All options selected, press Enter to continue.
Length of sort columns exceeds maximum allowed length.
Specified sort sequence is not valid.
You need to specify a column or field sort priority.
Number of sort columns specified exceeds maximum allowed.
An operand is too big for the requested function.
An expression result exceeds the maximum allowed size.
Value is too big or small for the requested function.
Query is blank or contains errors.
Specify join tests before pressing &1.
Correct errors before exiting, or press F12 to cancel.
Prompting not supported on remote connection.
Prompted query supported for DB2 for i5/OS connection only.
Specify table/file selection(s) before pressing &1.
Type a table/file name, or press F4 (Prompt) for list.
You need to select one column or field.
Two or more operands have incompatible CCSIDs.
Value not valid for DATE, TIME, or TIMESTAMP function.
Values or operator not compatible for operation.
Comparison values are both NULL-type variable fields.
Comparison values are not compatible.
Value not valid for comparison. (Conversion required.)
Table or file specified more than once.
You do not have authority to use the SELECT statement.
Remove sort priority from column or expression in error.
Numeric value &1 not valid.
String constant beginning &1 not delimited.
Specified function cannot be used on remote database.
Test condition &1 not valid for this comparison.
Correct errors before exiting, or press F12 to cancel.
Cursor position not valid.
Press Enter to confirm.
Type a Test condition, or press F4 for list.
Enter "+" to select more tables, or blank to exit.
No SQL statements allowed. You cannot use SQL queries.
Prompted query will be deleted. Press Enter to confirm.
Column(s) not found. Press Enter to remove references.
Value is not compatible with &1.
From column or field name must be qualified.
To column or field name must be qualified.
Remote system does not support named expressions.
Field value must be in the range 1 to 4.
Field value must be in the range 0 to 99.
Field value must be in the range 0 to 999.
Field value must be in the range 0 to 15.
Field value must be 1 or 2.
Field value must be 1, 2, or 3.
Field value must be 1, 2, 3, or 4.
Field value must be 1, 2, 3, 4, or 5.
Field value must be in the range 1 to 255.
Field value must be in the range 22 to 378.
Field value must be Y or N.
Field value must be *SYS or *SQL.
No SQL statement is available.
List information is not available.
No expressions have been defined.
No comparison tests have been defined.
No join conditions have been defined.
No SQL statements are allowed.
No report headings have been defined.
No break levels specified. Press Enter to continue.
List cannot be displayed.
Field value must be *RUW or *DUW.
Warnings issued on &1 &2 statement.
&1 &2 statement was ended.
&1 &2 statement failed with SQL return code &3.
Summary line value &1 not valid.
Blank lines before value &1 not valid.
&1 is not a valid column usage.
Edit code not supported. Press F4 for supported codes.
Edit code for column &2 not valid.
Edit code precision is not valid.
Edit code precision is not valid.
Default break attribute &1 not valid.
Break summary separator attribute &1 not valid.
No text specified.
Line number &1 not valid.
Align value &1 is not valid.
Query object &2 in library &1 not found.
Form object &2 in library &1 not found.
Incorrect data type found.
More than 255 columns selected by query.
Form does not match query.
Query contains unmatched quotation marks.
Statement &4 in procedure &3 in error.
SAVE DATA AS operation completed successfully.
Query data is not compatible with specified output table.
File &2 in library &1 not valid for operation.
Value &1 not valid for ACTION.
SAVE DATA AS supported only for local database connections.
Operation &1 not valid on object &2.
Operation "&1" not valid.
Object type "&1" not valid.
Text "&1" not valid for connector.
Expression is not named.
Parameter &1 value truncated.
CONFIRM = YES not valid for batch processing.
Incorrect connector used in command.
Object name not valid for command.
Object name required for command.
Second object name required.
Database name required for &1 statement.
No query data to &1.
************************** Beginning of Data *********************************
***************************** End of Data ************************************
-- ALL
And and Or or If
¬
Select Report Format Display Report Format
Edit Column Formatting Display Column Formatting
Edit Page Heading Display Page Heading
Edit Page Footing Display Page Footing
Edit Final Text Display Final Text
Edit Break Text Display Break Text
Edit Break Heading Display Break Heading
Edit Break Footing Display Break Footing
Specify Report Formatting Options Display Report Formatting Options
(C) COPYRIGHT IBM CORP.
Select Relational Database Name
Select Member
Select Collection
LEFT
RIGHT
CENTER
Select Library
Select Form
Select Table
Select File
Select Query
Select Printer
Select Job Description
Interactive
Batch
All
Basic
None
Change
Cursor stability
All
Display
Printer
Table
Yes
No
Created by DB2 for i5/OS Query Manager
Edit column formatting Display column formatting
Edit page heading Display page heading
Edit page footing Display page footing
Edit final text Display final text
Edit break text Display break text
Specify formatting options Display formatting options
Specify Query
There is no active Query
Type Query name, press Enter.
Specify Form
There is no active Form
Type Form name, press Enter.
Define Prompted Query
Display Prompted Query
Define Report Format
Display Report Format
1=Select
Columns
Tables
Row Selection
Summary Columns
Join Conditions
Sort Columns
Repeatable Read
Specify tables Specify Tables
Define expressions Define Expressions
Select and sequence columns Select And Sequence Columns
Select rows Select Rows
Select sort columns Select Sort Columns
Select summary functions Select Summary Functions
Specify duplicate rows Specify Duplicate Rows
Specify report formatting Specify Report Formatting
Specify join conditions Specify Join Conditions
Type information up to (&1), press Enter.
PROMPT
SQL
Equal to
Greater than
Greater than or equal to
Less than
Less than or equal to
Between
Starting with
Ending with
Contains
Null
&1 &2 is equal to &3
&1 &2 is less than &3
&1 &2 is less than or equal to &3
&1 &2 is greater than &3
&1 &2 is greater than or equal to &3
&1 &2 is between &3
&1 &2 starts with &3
&1 &2 ends with &3
&1 &2 contains &3
&1 &2 is null &3
&1 &2 is not equal to &3
&1 &2 is not less than &3
&1 &2 is not less than or equal to &3
&1 &2 is not greater than &3
&1 &2 is not greater than or equal to &3
&1 &2 is not between &3
&1 &2 does not start with &3
&1 &2 does not end with &3
&1 &2 does not contain &3
&1 &2 is not null &3
Type a sequence number (0-9999) for the name of each column to appear in the
report, press Enter.
Type expression using column names, constants, and operators, press Enter.
For full name and expression, press F4.
Type a sort priority (0-9999) and A (Ascending) or D (Descending) for the
names of up to 32 columns, press Enter.
Type comparison to show how table selections are related, press Enter.
Type a sequence number (0-9999) for the name of each field to appear in the
report, press Enter.
Type expression using field names, constants, and operators, press Enter.
For full name and expression, press F4.
Type a sort priority (0-9999) and A (Ascending) or D (Descending) for the
names of up to 32 fields, press Enter.
Type comparison to show how file selections are related, press Enter.
Test
Opt
Seq
Column Field
Data Type
Width Description
Table File
Column Field
Sum Avg Min Max Cnt
Sort Prty A/D
Select Column for Row Conditions Select Field for Record Conditions
Select Column Select Field
Type the value, expression, or column for comparison, press Enter.
Type the value, expression, or field for comparison, press Enter.
Display tables Display Tables
Display expressions Display Expressions
Display column sequence Display Column Sequence
Display rows Display Rows
Display sort columns Display Sort Columns
Display summary functions Display Summary Functions
Display duplicate rows Display Duplicate Rows
Display report formatting Display Report Formatting
Display join conditions Display Join Conditions
Specify files Specify Files
Select and sequence fields Select And Sequence Fields
Select sort fields Select Sort Fields
Display files Display Files
Display field sequence Display Field Sequence
Display sort fields Display Sort Fields
Select records Select Records
Display records Display Records
Type information, press Enter.
For Usage and Edit, press F4 for list.
For Heading, press F4 for prompt.
Type choices, press Enter.
Specify duplicate records Specify Duplicate Records
Display duplicate records Display Duplicate Records
Press Enter to continue.
Dec
Specify sort sequence Specify Sort Sequence
Display sort sequence Display Sort Sequence
Select Sort Sequence Table
Column names
System column names
Work With Queries
IBM Query for i5/OS Information
******** End of report layout ********
******** End of report ********
* * * E N D O F R E P O R T * * *
******** End of data ********
FINAL TOTALS
*FIRST *LAST *FILE
EQ NE LT GT LE GE LIST RANGE LIKE IS ISNOT NLIKE NLIST
A D OR AND . , O E F J *ALL *NONE Y N L T Z V G 1 2 3 5 L F
PAGE
QUERY NAME . . . . . .
LIBRARY NAME . . . . .
FILE LIBRARY MEMBER FORMAT
DATE . . . . . . . . .
TIME . . . . . . . . .
More... Bottom More... Bottom
BREAK LEVEL
BREAK LEVEL
OVERFLOW FLAG
OVERFLOW FLAG
TOTAL AVG MIN MAX COUNT
0010
CREATE DISPLAY CHANGE RUN
F1 F2 F3 F4 F5 F6 F7 F8 F9 F10
F11 F12 F13 F14 F15 F16 F17 F18 F19 F20
F21 F22 F23 F24
QRY cannot be run from the job queue.
QRY cannot be evoked.
Query must be called from QRY or QRYRUN.
Job queue or evoked job requires display device.
Can specify only one file if no query name specified.
Query name must be 1-10 characters.
Library name must be 1-10 characters.
Query report output type *OUTFILE not allowed.
Input file &3 in &4 not found.
Query name or file name must be specified.
Output file must exist when member is *ALL.
Output file must be partitioned table when member is *ALL.
Data in file option not valid when member is *ALL.
Output device must be DISPLAY, PRINTER, or DISK.
Form width must be from 1-378.
Line spacing must be 1, 2, or 3.
Number of copies must be from 1-255.
Printer ID must be 2 characters long or SYSTEM.
Forms number must be 1-4 characters long.
Input file name must be 1-10 characters.
Output file name does not follow rules for naming (D H).
File disposition must be NEW or REPLACE.
Error in QRYRUN procedure, see job log.
Output file cannot be same as input file.
Output file member cannot be same as input file member.
Not allowed to use file &3 in &4.
No query data will fit within text margins.
Cannot show this data at the display station.
Query &1 in &2 has errors.
File &3 in &4 cannot be queried.
Query &1 in &2 has errors.
Dependent value used, cannot run query &1 in &2.
Field &7 not found in file &3 in &4.
Field &7 not found in query &1 in &2.
Member &5 of file &3 in &4 in use, cannot be shared.
No fields will fit in the report width.
Multicopy instruction refers to dependent query &1 in &2.
Multicopy instruction needed before query &1 in &2 is used.
Dependent query &1 in &2 must match multicopy instruction.
Level for file &3 in &4 does not match query (I C).
Query for i5/OS exit program API not functional.
File or query name required for print request.
No record selected from file &3 in &4.
No records from query &1 in &2.
Cursor is in wrong place to use &11.
No long comment for field &7.
Field selected for &11 is a result field.
Unexpected error &9 processing request.
No long comment for file &3 in &4.
To use &11, cursor must be on prompt showing '&11 for list'.
No long comment for record format &6.
Error checking not complete.
Query run may fail - press F13 to show message.
Error &9&8 in query definition.
Query has errors, cannot show report.
Query has errors, cannot show layout.
Query must be defined to show report.
Query must be defined to show layout.
Dependent value used, cannot show report.
&11 not allowed when fields protected from change.
Fields protected from change while query has errors.
Cursor must be in input area when &11 pressed.
No room to insert.
&11 not allowed in Display mode.
Beginning of library list.
End of library list.
Beginning of query list.
End of query list.
Library &4 not in list, position not changed.
Option selected is not available.
&10 too many selections have been made.
Create option not allowed for existing query.
Type query name and option, or select from list.
Press Enter to use library &2, or press &11.
Library must be &4 to use list options or to reposition list.
Cannot list queries for library &2.
List of queries for library &2 may be incomplete.
No queries to list for library &2.
Data text merge options cannot be used with other options.
Only one data text merge option can be used.
Cannot list libraries for library list type or subset &19.
List of libraries for list type or subset &19 is incomplete.
No libraries to list for library list type or subset.
Select only one name from list.
Opt value must be 1 to select name, or blank.
Select only one name from list.
Function key not allowed.
Query definition has errors.
Choice must be 1 or blank.
Select options from list or press &11.
Query definition template rebuilt - reason &8.
Specify field selections to make query run faster.
Omit bad or useless data to make query run faster.
Field &7 not used for report formatting.
Run in debug mode for performance information.
Not all mapping error details logged.
Data mapping error &9 running query.
Mapping error in sort field &7.
Mapping error in other than report column.
Mapping error types information may be incomplete.
Fields after field &9 ignored.
End of file list.
Beginning of record format list.
End of record format list.
Select file(s), or press Enter to confirm.
File selection(s) changed, press Enter to update definition.
&10 too many files selected.
Format &6 not found in file &3 in &4.
Opt must be 1 to select, or blank.
Specify file selection(s) before pressing Enter.
Select only one record format from list.
End of result fields.
Beginning of result fields.
Field not defined for this query.
Field name does not follow rules for naming.
Field name needed for result definition.
Field &7 already defined.
Decimal positions specified without length.
Length specified without decimal positions.
Len must be blank or 1-63 for numeric; blank for all others.
Dec must be number from 0-63.
Decimal positions must not exceed length.
Numeric value must contain only digits 0-9.
Beginning of field list.
End of field list.
Sequence must be number from 0-9999, or blank.
&10 too many fields selected.
First 500 fields selected, press Enter to confirm.
Total length of selected fields exceeds maximum length.
Select dependent value qualifiers before using &11.
Qualifier type must be 1 or 2.
Query name is required.
Type a file name, or press &11 for list.
Member name must be blank when qualifier type is query.
File and library names required to list members.
File and library names required to list formats.
Expression not correct, cursor is positioned at error.
Field must have a file ID.
Field not in file selection with this ID
Numeric value must contain only digits 0-9.
File ID not used in this query.
Field used to test field &7 must be bracketed DBCS.
Field name must be name from list of fields.
Field name needed on line for comparison.
Test must be one listed in instructions.
AND/OR must be AND, OR, or blank.
Missing quotation mark or apostrophe.
Field used to test field &7 is not compatible.
Value used to test field &7 must be numeric.
Value used to test &7 is not compatible.
Value used to test field &7 must be date.
Value used to test &7 must be time.
Value used to test field &7 must be timestamp.
Value used to test field &7 must be DBCS-graphic.
Value used to test field &7 must be binary, varbinary or BLOB.
Value used to test field &7 must be SBCS or bracketed DBCS.
SUBSTR offset or length too large for value.
Data used to test field &7 must be bracketed DBCS.
Test field &7 using all bracketed DBCS or all SBCS data.
To run: remove dependent values, then press Enter.
Sort Prty must be 0-999, or blank.
A/D must be A (ascending), D (descending), or blank.
&10 too many sort fields selected.
Total storage length of sort fields exceeds maximum.
Beginning of record selection tests.
End of record selection tests.
Date, time, or timestamp syntax not correct.
Date, time, or timestamp constant not correct.
Date, time, or timestamp expression not correct.
Arguments in VALUE function must be compatible.
VALUE format must be VALUE(x,y).
Labeled duration not used correctly.
Format specified for CHAR function not correct.
First argument of CHAR function not date, time, or timestamp.
Wrong number of arguments for function.
Argument for TIMESTAMP function must be timestamp.
The first argument of TIMESTAMP function must be date.
Second argument of TIMESTAMP function must be time.
Field or constant used for function is not allowed.
Argument for CURRENT function is not correct.
Cannot convert concatenation symbol.
Format specified for the VARCHAR function not correct.
Format specified for the VARGRAPHIC function not correct.
CCSIDs used in expression for field &7 not compatible.
Len for character field must be 0 through 32,766.
Options must be 1, 2, 3, 4, 5, or blank.
Column Spacing must be 0-99, or blank.
Average allowed only for numeric field.
Beginning of report fields.
End of report fields.
Dec value must be blank for character field.
Total allowed only for numeric field.
Len value must be 0-63 for numeric field.
Dec value for &7 must not be changed from &12.
Len value for field &7 must be &22 or 0.
Len value must be 0-17 for double-precision floating-point field.
Len value must be 0-9 for single-precision floating-point field.
Length of result field exceeds the maximum allowed.
Break Level must be number from 1-6, or blank.
No members in file &3 in &4.
Specify file selections before pressing &11.
File ID &8 already used.
File name &3 cannot be selected until overrides removed.
Too many files involved in file selections.
File &3 in &4 is not a data base file, cannot query.
Query &1 not found in &2.
Library &4 not found.
Member &5 not in file &3 in &4.
Input file &3 in &4 must be partitioned table when member is *ALL.
Table &24 in &25 not found.
File &3 not found in &4.
Printer device &17 not found.
Authorization list &17 not found in library &18.
Query &20 already exists in library &21.
Error opening printer file &17 in &18.
Specified override of Query printer file not allowed.
Not allowed to use query &1 in &2.
Not allowed to use library &4.
Error opening display file &17 in &18.
Not allowed to use table &24 in library &25.
Not allowed to use file &3 in &4.
Not allowed to use printer device &17.
Not allowed to use authorization list &17 in &18.
Format specified for the BINARY or VARBINARY function not correct.
Not allowed to use XML type.
Output type value must be 1, 2, or 3.
Print definition value must be Y or N.
Output form value must be 1 or 2.
Line wrapping value must be Y or N.
Line wrapping width must be 1-378, or blank.
Record on one page value must be Y or N.
Data in file value must be 1, 2, 3, 4, or 5.
Specify a data base file to receive output, or press &11.
Form width must be 1-378, or blank.
Line spacing must be 1, 2, or 3.
Number of copies must be from 1-255 or blank.
Form type must be form name, *STD, or blank.
Printer device &17 not found.
Specify printer device name or *PRINT.

Length: 122959 Date: 20200921 Time: 121430

Count: 645     sap01-206 ( 708 ms ) This documentation is copyright by IBM.