|
|
ISQL Messages - ARI7001-ARI7970
User Response: Correct the cause of the error as
ARI7066I
Your input is being held.
indicated by previous error messages, and rerun the
Explanation: You entered a HOLD command or
routine.
pressed the PF9 key. Your command is being held and
may be continued.
ARI7071I
Routine or EXEC processing stopped.
System Action: The system waits for you to enter the
The error indicated by a previous
rest of the command, unless the command was
message cancelled the processing of
complete. If the command was complete, the HOLD
your routine or EXEC, as you requested
command will be processed.
with the SET RUNMODE command.
User Response: Press ENTER if the command is
Explanation: While a routine was running, an error
complete. If the command is not complete, you may
was detected by ISQL. ISQL stopped the routine
enter the rest of the command, or IGNORE, or
processing because you requested routines be stopped
CANCEL.
when errors are detected. See the SET RUNMODE
command for additional information.
ARI7068I
Your input is continued. Enter more
System Action: The routine processing ends.
input or press Enter.
ROLLBACK WORK is not issued. The system waits for
you to enter the next statement.
Explanation: You entered an input line with a
continuation character or used PF9. Continue the input
User Response: Correct the cause of the error as
and press enter.
indicated by previous error messages, and rerun the
routine.
System Action: The system waits for you to enter
additional input lines.
ARI7079I
ISQL initialization complete.
User Response: Enter additional input lines, IGNORE
to have the input ignored, CANCEL to have the
Explanation: ISQL initialization has completed.
command cancelled, or press the ENTER key to have
System Action: System waits for you to enter an ISQL
the command processed.
or SQL command.
User Response: Enter an ISQL or SQL command.
ARI7069I
Your input has been held. Use the
START command to process your input.
ARI7080A Please enter an ISQL command or an
Explanation: You requested that an SQL statement be
SQL statement.
held by pressing the PF9 key or by entering the HOLD
command. The SQL statement is held in the current
Explanation: You must enter a command. A null line
command buffer. The SQL statement will be processed
will not be accepted.
if you enter a START command or press the PF2 key.
System Action: The system waits for you to enter a
System Action: The system waits for you to enter the
command.
next statement.
User Response: Enter an ISQL or SQL command.
User Response: Enter another command: START - to
start the held statement, CHANGE - to change the held
ARI7081A Invalid user ID. Please reenter your user
statement, or another command.
ID. Your user ID must start with a letter
and must contain only letters and
ARI7070I
Routine or EXEC processing cancelled.
numbers.
The error indicated by a previous
Explanation: Your user ID must start with a letter and
message cancelled the processing of
must contain only letters and numbers.
your routine or EXEC, as you requested
with the SET RUNMODE command.
System Action: You are given two tries to correct the
user ID and then this signon will end.
Explanation: While a routine was running, an error
was detected by ISQL. ISQL cancelled the routine
User Response: Enter a valid user ID.
processing because you requested routines be cancelled
when errors are detected. See the SET RUNMODE
ARI7082A User ID is not authorized to use the
command for additional information.
application server. Enter an authorized
System Action: ISQL issues a ROLLBACK WORK to
user ID.
undo all the work done since the last COMMIT WORK.
Explanation: You have entered a user ID that is not
The routine processing will be terminated. The system
authorized to use the database manager. Users must be
waits for you to enter the next statement.
defined to the DB2 Server for VSE system by the
150
Messages and Codes
ISQL Messages - ARI7001-ARI7970
system programmer before they can use the DB2 Server
ARI7086E The connection between ISQL and the
for VSE system. You may have typed your user ID
application server is not operational.
incorrectly.
[Notify your system programmer. This
System Action: You are given two tries to enter a
sign-on ended.]
valid user ID and then this signon will end.
Explanation: The link between ISQL and the database
User Response: Enter a valid user ID. If you do not
manager has not been enabled. Your signon cannot
have a valid user ID, notify your system programmer.
continue until the link has been enabled.
System Programmer Response: Define the user to the
System Action: Your signon ends.
database manager if not already defined.
User Response: Try again later. If you can still not
signon, notify your system programmer.
ARI7083A Invalid password. Please reenter your
System Programmer Response: Enable the link
password.
between ISQL and the database manager.
Explanation: The password that you entered does not
match the DB2 Server for VSE password for the user ID
ARI7087E ISQL has abnormally terminated with
that you entered.
CICS Abend Code code.
System Action: You are given two tries to enter a
Explanation: ISQL has abended with the CICS abend
valid password and then this signon will end.
code shown in the message.
User Response: Enter your correct password.
System Action: Your signon ends.
System Programmer Response: Verify that the
User Response: Notify your system programmer.
password entered by the user matches the DB2 Server
for VSE password for the user ID.
System Programmer Response: Perform problem
determination. If a database system error occurred,
make a record of what went wrong and contact the
ARI7084I
SIGNON unsuccessful. User ID or
designated support group for your installation.
password or target database are invalid.
This SIGNON ended.
ARI7101E Internal processing error. Invalid call to
Explanation: You have not supplied a valid user ID
ARIITIO.
and/or password and/or target database.
Explanation: An internal processing error occurred in
System Action: This signon ends if a valid user ID,
ISQL. Module ARIITIO was called to display data, but
password, and target database are not supplied.
the length of the data was zero.
User Response: Notify your system programmer if
System Action: Control is returned to the module that
you do not have a valid user ID, password, or target
called module ARIITIO. Processing continues.
database. When you have a valid user ID and
password you may signon to ISQL.
ARI7120E ISQL could not process your command
System Programmer Response: Define the user to
because of a system problem. Your
ISQL if not already defined. Give the user the correct
command is too large. Report this
password if an incorrect password was used. Give the
problem to your system programmer.
user the correct target database if an incorrect target
database was used.
Explanation: One of the following conditions
occurred:
v The length of the current SQL command was greater
ARI7085E There is not enough system storage
than 2048 characters.
available. [This SIGNON ended.] Try
again later.
v The length of the formatting information may be
calculated as follows:
Explanation: There is not enough system storage
FORMAT BLOCK SIZE = x + (n * y)
available to support another ISQL user. More storage
will become available as other users signoff.
where x is the size of the format block header (504
System Action: Your signon ends.
bytes), n is the number of columns in the select-list
for the stored query (not to exceed 45 columns), and
User Response: Try again later. If you still can not
y is the size of the format information stored for each
signon, notify your system programmer.
column (44 bytes).
System Programmer Response: If this condition
System Action: No substitutions were performed. The
persists, increase the SIZE parameter on the EXEC CICS
system waits for you to enter the next statement.
job control statement and the CICS partition size.
151
Chapter 12. ARI7001-ARI7970 ISQL Messages
ISQL Messages - ARI7001-ARI7970
User Response: Notify your system programmer.
System Action: Parameter substitutions are done until
the invalid number was found. The system waits for
System Programmer Response: Determine which
you to enter the next statement.
length was exceeded and why. If a database system
error occurred, make a record of what went wrong and
User Response: Change invalid number to a number
contact the designated support group for your
between 1 and 9999.
installation.
ARI7126E Command failed. The command line
ARI7121E Command failed. ISQL could not
was null after ISQL made substitutions.
process your SQL statement because it
Change your command or routine and
is too large. Substitutions would make
try again.
the command line longer than 2048
Explanation: When substitutions made for the
characters.
placeholders (&1., &2., etc.), your command was null.
Explanation: When substitutions made for the
System Action: No action is taken. The system waits
placeholders (&1., &2., etc.), your command was longer
for you to enter the next statement.
than 2048 characters.
User Response: Change your command or routine
System Action: The system waits for you to enter the
and try again.
next statement.
User Response: Change the SQL command so that its
ARI7127I
Your command contains unpaired
total length, including substitutions, is less than 2048
quotation marks.
characters.
Explanation: The command you entered contained
either an unpaired single quote (’) or an unpaired
ARI7123E Command failed. You entered an invalid
double quote (").
character after the &. Reenter the
command with a number between 1 and
System Action: The system finishes processing the
9999 following the &.
command with the unpaired quotation mark. The
system waits for you to enter the next statement.
Explanation: A nonnumeric character was found after
&.
User Response: Check the results of the command. If
they are not what you wanted, reenter the command.
System Action: Parameter substitutions were
performed until the invalid character was found. The
system waits for you to enter the next statement.
ARI7128E Run command failed. A command line
or data line in your routine is too large.
User Response: Replace the invalid character after &,
Substitutions would make the line more
to a number between 1 and 9999 and reenter the
than 254 characters long.
command.
Explanation: Substitutions made for the placeholders
(&1., &2., etc.) would cause a line in your routine to
ARI7124E Command failed. You entered a 0 after
exceed 254 characters. The line is displayed after the
the &. Reenter the command with a
message.
number between 1 and 9999 following
the &.
System Action: Substitutions were performed until the
line would have exceeded 254 characters with the next
Explanation: The first number after the & is a zero,
substitution. The system waits for you to enter the next
which is not valid.
statement.
System Action: Parameter substitutions were
User Response: Change the routine so that each line,
performed until the zero was found.
including substitutions, has fewer than 254 characters.
User Response: Change the SQL command so that it
no longer has a 0 after the &. The system waits for you
ARI7180E Command failed. The ISQLTRACE
to enter the next statement.
command has a missing or invalid
parameter. Reenter the command
ARI7125E Command failed. You entered a number
specifying DUMP, DISPLAY, or N,
greater than 9999 after the &. Reenter
where N is the desired number of
the command with a number between 1
entries in the trace table. N must be
and 9999 following the &.
between 50 and 1000.
Explanation: The only valid numbers which can be
Explanation: You entered an incorrect option on the
substituted for a parameter are between 1 and 9999. A
ISQLTRACE command.
number greater than 9999 was found after an &.
152
Messages and Codes
ISQL Messages - ARI7001-ARI7970
System Action: The command is ignored. The system
ARI7184I
ISQLTRACE processing complete.
waits for you to enter the next statement.
Explanation: The ISQLTRACE command processing
User Response: Reenter the command, specifying the
you requested is complete.
option you want.
System Action: The system waits for you to enter the
next statement.
ARI7181I
ISQL trace table display
First entry: address1
ARI7185I
There is not enough storage available to
Current entry: address2
change the number of trace entries in
Last entry: address3
the trace table. The number of entries is
unchanged.
Explanation: You entered an ISQLTRACE DISPLAY
command.
Explanation: There was not enough storage available
to obtain a new trace table. The size of the trace table
address1 is the address of the start of the trace table.
remains unchanged.
address2 is the address of the current entry in the table.
System Action: The system waits for you to enter the
address3 is the address of the last entry in the table (not
next statement.
necessarily the last entry used in the table).
User Response: Retry the command later.
System Action: Trace table entries will be displayed
following the heading. They will be displayed in
ARI7186I
The trace table can now hold number
reverse order, starting with the latest entry placed in
entries.
the table.
Explanation: The size of the trace table has been
changed to hold the number of entries you specified on
ARI7182E Command failed. The number you
the ISQLTRACE command.
specified on the ISQLTRACE command
is not between 50 and 1000. Reenter the
number is the number of entries you specified.
command specifying a number between
System Action: The system waits for you to enter the
50 and 1000.
next statement.
Explanation: You did not enter a number between 50
and 1000. When changing the number of entries in the
ARI7300E Command ended. The input command
trace table, only the numbers between 50 and 1000 are
could not be processed because of
accepted.
system problems. You may enter another
System Action: The command is ignored. The system
command.
waits for you to enter the next statement.
Explanation: INPUT could not get the storage it
User Response: Reenter the command with a number
needed for processing. INPUT processing ends.
from 50 to 1000.
System Action: The INPUT command ended. The
system waits for you to enter the next statement.
ARI7183E Command failed. The number you
User Response: You are free to enter another
specified on the ISQLTRACE command
command or INPUT can be tried again. If you enter the
has more than 4 digits. Reenter the
INPUT command again and continue to receive this
command specifying a number between
message, notify your system programmer.
50 and 1000.
System Programmer Response: If this condition
Explanation: You entered a number that has more
persists, increase the SIZE parameter on the CICS EXEC
than four digits. When changing the number of entries
job control statement and the CICS partition size.
in the trace table, only the numbers between 50 and
1000 are accepted.
ARI7301E Command failed. Specify the table
System Action: The command is ignored. The system
name on the input command.
waits for you to enter the next statement.
Explanation: No table name was specified after
User Response: Reenter the command with a number
INPUT.
from 50 to 1000.
System Action: The INPUT command has ended. The
system waits for you to enter the next statement. No
SQL COMMIT WORK or ROLLBACK WORK has been
issued.
Chapter 12. ARI7001-ARI7970 ISQL Messages
153
ISQL Messages - ARI7001-ARI7970
User Response: Reenter the INPUT command
SQL COMMIT WORK or ROLLBACK WORK has been
specifying table name and optionally (column names).
issued.
User Response: Reenter the INPUT command. Make
ARI7302E Command failed. Table name is
sure that any column names specified begin with a left
incorrect. You must use double
parenthesis "(" and end with a right parenthesis ")" as
quotation marks in pairs.
required.
Explanation: During the checking of the table name a
double quote was encountered. However, another
ARI7306E The input command is ending. Read the
double quote was not found. They must be specified in
previous SQL error message and its
pairs.
action for the reason.
System Action: The INPUT command has ended. The
Explanation: INPUT cannot continue processing for
system waits for you to enter the next statement. No
reasons described by the SQL error message printed
SQL COMMIT WORK or ROLLBACK WORK has been
prior to this one.
issued.
System Action: INPUT is ending. A ROLLBACK
User Response: Reenter the INPUT command making
WORK will be issued for a user-entered or
sure that the double quotes around the table name are
system-entered CANCEL, or if SET AUTOCOMMIT is
specified in pairs.
ON. If SET AUTOCOMMIT is OFF and INPUT is not
being ended because of a CANCEL, a ROLLBACK
WORK will not be performed. INPUT ends. The system
ARI7303E Command failed. Table name is
waits for you to enter the next statement.
incorrect. You must specify the table
name after the creator name.
User Response: Read the SQL error message and its
action. If the problem is still unclear, notify your
Explanation: During checking of the {owner.}table
system programmer. Otherwise, take action to correct
name, no table name was found after owner.
the problem and enter the INPUT command again.
System Action: The INPUT command has ended. The
System Programmer Response: Perform problem
system waits for you to enter the next statement. No
determination. If a database system error occurred,
SQL COMMIT WORK or ROLLBACK WORK has been
make a record of what went wrong and contact the
issued.
designated support group for your installation.
User Response: Reenter the INPUT command
specifying table name after owner.
ARI7307A Enter data values, separated by commas,
for the following columns. Enclose
ARI7304E Command failed. Column names are
character data in single quotation marks.
specified incorrectly. A left parenthesis
Explanation: Enter data for the columns specified after
must come before column names.
this message. The character data must be enclosed in
Explanation: During checking of the INPUT
single quotes.
command, it was discovered that the column names
System Action: Immediately following this message
did not start with a left parenthesis.
the system writes the names of the columns for which
System Action: The INPUT command has ended. The
you are to enter data, the data type, and whether null
system waits for you to enter the next statement. No
values are allowed in this field. The keyboard is then
SQL COMMIT WORK or ROLLBACK WORK has been
unlocked and you are requested to enter data or an
issued.
INPUT command.
User Response: Reenter the INPUT command. Make
User Response: You should note this carefully. You
sure that any column names specified begin with a left
will be asked to enter data soon. Data must be entered
parenthesis “(” and end with a right parenthesis ")" as
in the order specified and must be separated by
required.
commas.
ARI7305E Command failed. Column names are
ARI7308A Data not accepted. Reenter data row.
specified incorrectly. A right parenthesis
Explanation: INPUT encountered a problem as
must follow column names.
described by the SQL error message printed prior to
Explanation: During checking of the INPUT command
this one. The data could not be processed.
it was discovered that the column names did not end
System Action: The data just entered was not
with a right parenthesis.
accepted. No other data has been lost. You are asked to
System Action: The INPUT command has ended. The
enter data or another INPUT command.
system waits for you to enter the next statement. No
154
Messages and Codes
ISQL Messages - ARI7001-ARI7970
User Response: Read the SQL error message and its
ARI7312I
Since AUTOCOMMIT is OFF, SAVE
action. If the problem is still unclear, notify your
was ignored. To commit data, enter an
system programmer. Otherwise, if you want this data
END command and then a COMMIT
entered into the table, correct the problem and enter it
statement.
again.
Explanation: Normally, INPUT will commit the data
System Programmer Response: Perform problem
you entered into the table when you enter SAVE.
determination. If a database system error occurred,
Because you entered SET AUTOCOMMIT OFF before
make a record of what went wrong and contact the
you entered INPUT, you will have to commit data into
designated support group for your installation.
the table yourself with the COMMIT statement.
System Action: No action is taken. The system asks
ARI7309E Command failed. At least one space
you to enter more data or an INPUT command.
must separate table name and column
names.
User Response: If you want to commit your data now,
leave INPUT by entering the END command. To
Explanation: During checking of the INPUT
commit your data, enter a COMMIT statement.
command, a left parenthesis "(" was found as the next
Otherwise, enter either more data or an INPUT
character after table name. There must be at least one
command.
blank between the table name and the start of the
column names.
ARI7313I
Command processing continuing. Excess
System Action: The INPUT command has ended. The
parameters on command are ignored.
system waits for you to enter the next statement. No
SQL COMMIT WORK or ROLLBACK WORK has been
Explanation: During checking of the command (where
issued.
command is SAVE, BACKOUT, or END) a parameter
was discovered. Parameters are not valid.
User Response: Reenter the INPUT command. Put at
least one blank between table name and the left
System Action: The parameter is ignored. Processing
parenthesis “(” which starts the specification of column
of the command continues.
names.
ARI7314I
SAVE processing is complete.
ARI7310E Command ignored. Input cannot process
Explanation: The data which you had previously
this ISQL command. Reenter this
entered was committed to a DB2 Server for VSE table.
command after you finish using the
INPUT command.
System Action: The system waits for you to enter data
or another INPUT command.
Explanation: The ISQL command entered was not
valid at this time.
ARI7315E SAVE command failed. No data was
System Action: The command is ignored. You are
committed to the table. The INPUT
asked to enter more data or an INPUT command.
command has ended. Notify your
User Response: If you want the command to be
system programmer.
processed, bypass the INPUT command by typing END
Explanation: ISQL tried to save your input data by
or CANCEL. Otherwise, enter more data or an INPUT
issuing a COMMIT WORK command. An error
command.
occurred as described in the SQL error message above.
System Action: The system will issue a ROLLBACK
ARI7311E Command ignored. You entered neither
WORK. INPUT processing has ended.
data nor a valid input command. Try
again.
User Response: Read the SQL error message and its
action. Notify your system programmer. You are free to
Explanation: You entered neither data nor a valid
enter another ISQL command. You will not be able to
INPUT command.
enter another SQL command during this session.
System Action: The command is ignored. The system
System Programmer Response: Perform problem
waits for you to enter either data or an INPUT
determination. If a database system error occurred,
command.
make a record of what went wrong and contact the
User Response: Enter either data or an INPUT
designated support group for your installation.
command.
Chapter 12. ARI7001-ARI7970 ISQL Messages
155
ISQL Messages - ARI7001-ARI7970
command has ended. The system waits for you to enter
ARI7316E Since AUTOCOMMIT is OFF,
the next statement.
BACKOUT was ignored. To ROLLBACK
data, enter an END command and then
User Response: If you want to commit data now,
a ROLLBACK statement.
enter a COMMIT statement. Otherwise, you are free to
enter another command.
Explanation: Normally, INPUT will roll back the data
you entered into the table when you enter BACKOUT.
Because you entered SET AUTOCOMMIT OFF before
ARI7320I
END committed data to the table.
you entered INPUT, you will have to roll back data
Explanation: The data which you had previously
yourself with the ROLLBACK statement.
entered was committed to the DB2 Server for VSE
System Action: No action is taken. The system asks
table.
you to enter more data or an INPUT command.
System Action: INPUT is ending. The system waits
User Response: If you want to roll back your data
for you to enter the next statement.
now, leave INPUT mode by entering the END
command. To roll back your data, enter a ROLLBACK
ARI7321E An error occurred during END
statement. Otherwise, enter either more data or an
command processing. Read the previous
INPUT command.
SQL error message and its action. The
database manager issued a ROLLBACK
ARI7317I
BACKOUT processing is complete.
statement.
Explanation: The data which you had previously
Explanation: ISQL tried to save the input data by
entered was rolled back from the table.
issuing a COMMIT statement. This statement
encountered an error specified by the SQL error
System Action: The system waits for you to enter the
message above.
next statement.
System Action: The system issued a ROLLBACK
statement. Input will end. The system waits for you to
ARI7318E BACKOUT command failed. The
enter the next statement.
INPUT command has ended. Notify
your system programmer.
User Response: Read the SQL error message and its
action. Notify your system programmer. You are free to
Explanation: ISQL tried to backout the data by issuing
enter another ISQL command. You cannot enter another
an SQL ROLLBACK WORK command. This command
SQL statement during this session.
encountered an error specified by the SQL error
message above.
System Programmer Response: Perform problem
determination. If a database system error occurred,
System Action: The database manager will roll back
make a record of what went wrong and contact the
your input during error processing. INPUT processing
designated support group for your installation.
has ended. The system waits for you to enter the next
statement.
ARI7322I
The INPUT command completed.
User Response: Read the SQL error message and its
action and notify your system programmer. You are
Explanation: INPUT processing has completed.
free to enter another ISQL command. You cannot enter
System Action: The system waits for you to enter the
another SQL command during this session.
next statement.
System Programmer Response: Perform problem
determination. If a database system error occurred,
ARI7323I
You ended the INPUT command by
make a record of what went wrong and contact the
entering a CANCEL command.
designated support group for your installation.
Explanation: INPUT processing has completed as a
result of entering the CANCEL command.
ARI7319I
Since AUTOCOMMIT is OFF, END
does not commit data into the table.
System Action: The system waits for you to enter the
Enter a COMMIT statement to save your
next statement.
data.
Explanation: Normally, INPUT will commit the data
ARI7324E The INPUT command rolled back all
you entered into the table when you enter END.
your data.
Because you entered SET AUTOCOMMIT OFF before
Explanation: ISQL tried to insert data into the table
you entered INPUT, you will have to commit data into
you specified. An error occurred as described in the
the table yourself with the COMMIT statement.
SQL error message above.
System Action: No action is taken. The INPUT
156
Messages and Codes
ISQL Messages - ARI7001-ARI7970
System Action: INPUT processing cannot continue.
inserted where you want the INPUT command to end.
ISQL has issued a ROLLBACK WORK command.
You are also free to enter another command.
INPUT processing has ended. The system waits for you
to enter the next statement.
ARI7328E Command failed. You specified the
User Response: Read the SQL error message and its
column names incorrectly. Column
action. If the problem is still unclear, notify your
names must be specified between
system programmer. Otherwise, you are free to enter
parentheses.
another command.
Explanation: During checking of the INPUT
System Programmer Response: Perform problem
command, it was discovered that parentheses were
determination. If a database system error occurred,
coded after the table name. However, no column names
make a record of what went wrong and contact the
were written between the parentheses.
designated support group for your installation.
System Action: The INPUT command has ended. The
system waits for you to enter the next statement.
ARI7325I
The system completed the INPUT
User Response: Resubmit the INPUT command. If
command.
you want all columns, type just the table name. If you
Explanation: INPUT processing completed as a result
want specific columns, type them between the
of system problems encountered during INPUT
parentheses.
command processing.
System Action: The system waits for you to enter the
ARI7329E Command failed. You specified the
next statement.
column names incorrectly. They must
begin with a letter, $, #, or @ unless they
User Response: Read the SQL error message and its
are enclosed in double quotation marks.
action. If the problem is still unclear, notify your
system programmer. Otherwise, you are free to enter
Explanation: During checking of the INPUT
another command.
command, it was discovered that one or more of the
column names began with a character other than a
System Programmer Response: Perform problem
letter, $, #, or @. This is not valid.
determination. If a database system error occurred,
make a record of what went wrong and contact the
System Action: The INPUT command has ended. The
designated support group for your installation.
system waits for you to enter the next statement.
User Response: Resubmit the INPUT command. If all
ARI7326A No data was entered. Enter data or an
column name or names in error begin with a character
INPUT command.
other than a letter, $, #, or @, you must enclose the
name in double quotes ("). Otherwise, find the correct
Explanation: You pressed the ENTER key with
column name or names. The column name or names in
nothing or a line of blanks on the input line.
error do not exist.
System Action: No action is taken. The system waits
for you to enter data or another INPUT command.
ARI7330E The INPUT command failed. A routine
User Response: Enter either data or an INPUT
or an EXEC issued an incomplete
command.
INPUT command. Insert an END
command after the last DATA or INPUT
command.
ARI7327E The INPUT command failed. INPUT
was entered from a routine, but was not
Explanation: Since input was initiated from a routine,
complete. Insert an END command after
all data or INPUT commands must also be entered
the last DATA or INPUT command.
from the routine. Input is trying to process more data
or an INPUT command, but there were no more
Explanation: Because INPUT was started from a
records in the routine.
routine, all data or INPUT commands must be entered
from the routine also. INPUT is trying to process more
System Action: The system has issued a CANCEL
data or an INPUT command, but there were no more
command and a ROLLBACK WORK RELEASE
records in the routine.
command. INPUT processing has ended. The system
waits for you to enter the next statement.
System Action: The system has issued a CANCEL
command and a ROLLBACK WORK command. INPUT
User Response: Examine the routine just executed. For
processing has ended. The system waits for you to
input to finish properly, an END command should be
enter the next statement.
inserted where you want the INPUT command to end.
You are also free to enter another command.
User Response: Examine the routine just executed. For
INPUT to finish properly, an END command should be
Chapter 12. ARI7001-ARI7970 ISQL Messages
157
ISQL Messages - ARI7001-ARI7970
ARI7350E RUN processing cancelled. You have a
ARI7357E RUN command failed. The RUN
RUN command in your routine. Remove
command cannot finish because of a
the RUN command from the routine.
system error. Notify your system
programmer.
Explanation: RUN is not a valid command in a
routine.
Explanation: While the system was trying to process
the routine an internal error occurred. The messages
System Action: An internal cancel is issued. The
preceding this message describe the internal error.
system waits for you to enter the next statement.
System Action: The RUN command failed. The
User Response: Take the RUN command out of the
system waits for you to enter the next statement.
routine.
User Response: Save the associated error messages
and notify your system programmer. Enter another
ARI7351E RUN command failed. You did not
command.
specify a routine name. Reenter the
RUN command with a routine name.
System Programmer Response: Use the SQL error
code specified in the previously issued error message to
Explanation: You must specify the name of the routine
determine the proper course of action. If a database
to be executed on the RUN command. The format is:
system error occurred, make a record of what went
RUN userid.routine name parameters.
wrong and contact the designated support group for
System Action: Command processing failed. The
your installation.
system waits for you to enter the next statement.
User Response: Reenter the RUN command with a
ARI7358E RUN command failed. The
routine name.
{userid|name} must be 8 characters or
less. Reenter the RUN command.
ARI7354E RUN command failed. The RUN
Explanation: The user ID or name specified on the
command cannot find the
RUN command was larger than 8 characters. The
userid.ROUTINE table. Reenter the
maximum size of the user ID or name field is 8.
RUN command using a valid user ID or
System Action: RUN processing failed. The system
create the routine table.
waits for you to enter the next statement.
Explanation: The specified ROUTINE table does not
User Response: Reenter the RUN command specifying
exist.
a user ID or name of not more than 8 characters.
System Action: The RUN command failed. The
system waits for you to enter the next statement.
ARI7359E RUN command failed. Rebuild the
User Response: Reenter the RUN command specifying
routine table with the SEQNO column
the proper user ID; or, if the ROUTINE table does not
defined as SMALLINT or INTEGER,
exist, it must be created using the CREATE TABLE
and NOT NULL.
command. See the DB2 Server for VSE & VM Interactive
Explanation: The ROUTINE table must be created
SQL Guide and Reference manual for information on
with a SEQNO column defined with a data type of
creating and using routines.
SMALLINT or INTEGER, and NOT NULL.
System Action: The system waits for you to enter the
ARI7355E RUN command failed. The RUN
next statement.
command cannot find the named
routine. Reenter the RUN command
User Response: Enter a DROP TABLE command for
with a valid routine name.
the ROUTINE table, and a CREATE TABLE command
to rebuild it. Specify SMALLINT or INTEGER as the
Explanation: The named routine could not be found.
data type for the SEQNO column. See the DB2 Server
System Action: The RUN command failed. The
for VSE & VM Interactive SQL Guide and Reference
system waits for you to enter the next statement.
manual for information on creating and using routines.
User Response: Reenter the RUN command using a
valid routine name.
ARI7360E RUN command failed. You cannot use
the userid.ROUTINE table again in this
session. Enter another command.
Explanation: The system was not successful in closing
the cursor for this table.
System Action: RUN processing failed. The system
158
Messages and Codes
ISQL Messages - ARI7001-ARI7970
waits for you to enter the next statement.
ARI7364E RUN processing cancelled. You have a
User Response: Save the associated error messages
RUN command in your routine or
and notify your system programmer.
EXEC. Remove the RUN command from
the routine or EXEC.
System Programmer Response: Use the SQL error
code specified in the previously issued error message to
Explanation: RUN is not a valid command in a
determine the proper course of action. If a database
routine.
system error occurred, make a record of what went
System Action: An internal CANCEL is issued.
wrong and contact the designated support group for
your installation.
User Response: Take the RUN command out of the
routine.
ARI7361I
RUN command is processing normally.
However, an empty command line was
ARI7398I
Profile processing is starting.
encountered in the routine. The empty
Explanation: ISQL initialization found either a master,
line is ignored.
user, or signon PROFILE routine and is processing it.
Explanation: While the system was processing the
System Action: The appropriate routines are run.
commands in the specified routine a null line was
encountered.
ARI7399I
The ISQL default profile values are in
System Action: The line is ignored and normal
effect.
processing continues.
Explanation: A PROFILE routine did not exist in the
User Response: Remove the null line from the routine
SQLDBA.ROUTINE table or in the userid.ROUTINE
if you do not want to get this message.
table. A routine was not specified as a parameter on the
signon.
ARI7362E RUN command ended abnormally
System Action: ISQL signon processing continues
because of a parameter substitution
using system values.
error. Correct the error and reenter the
RUN command.
User Response: If you want to know what values are
in effect, enter the LIST SET command.
Explanation: During RUN command parameter
substitution, an error occurred which caused
substitution to end. The message which precedes this
ARI7500E Command failed. You can only issue a
message states the cause of the error.
FORMAT command during a query
result. Enter an SQL SELECT before
System Action: The RUN command failed. The
issuing a FORMAT command.
system waits for you to enter the next statement.
Explanation: You tried to format the screen when
User Response: Use the message which precedes this
there was no SELECT command active.
message to correct the parameter substitution error.
Reenter the RUN command.
System Action: The command is ignored. The system
waits for you to enter the next statement.
ARI7363E RUN command failed. Rebuild the
User Response: Enter a SELECT command or start a
routine table with the command column
SELECT command before you enter the FORMAT
defined as VARCHAR.
command.
Explanation: The ROUTINE table must be created
with the COMMAND column as VARCHAR.
ARI7501E Command processing stopped. You
entered an incorrect keyword token on
System Action: The system waits for you to enter the
the FORMAT command. Reenter the
next statement.
FORMAT command with one or more of
User Response: Enter a DROP TABLE command to
the following keywords: ON, OFF,
delete the ROUTINE table and a CREATE TABLE
SUBTOTAL, TOTAL, GROUP,
command to rebuild it. See the DB2 Server for VSE &
OUTLINE, SEPARATOR, VARCHAR,
VM Interactive SQL Guide and Reference manual for
NULL, TTITLE, BTITLE, COLUMN,
information on creating and using routines.
EXCLUDE, or INCLUDE.
Explanation: You entered an incorrect keyword on the
FORMAT command. One or more of the following
keywords must be specified after the FORMAT
command: ON, OFF, SUBTOTAL, TOTAL, GROUP,
OUTLINE, SEPARATOR, VARCHAR, NULL, TTITLE,
Chapter 12. ARI7001-ARI7970 ISQL Messages
159
ISQL Messages - ARI7001-ARI7970
BTITLE, COLUMN, EXCLUDE, or INCLUDE.
ARI7505E Command processing stopped. The
token is the incorrect keyword you entered.
number after the keyword keyword
cannot be more than 8 digits long. Try
System Action: Command processing has been
again.
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
Explanation: A number you entered was too large.
other keywords are ignored.
The field allows 8 digits, including leading zeros.
User Response: Enter FORMAT with one or more of
keyword is the keyword you entered.
the correct keywords.
System Action: The command is ignored. The system
waits for you to enter the next statement.
ARI7502I
The keyword indicator was previously
User Response: Reenter the command with a number
old setting. It is now new setting.
from 1 to 254.
Explanation: This message shows the setting of the
FORMAT keyword that you have just changed.
ARI7506I
The width you specified for column
keyword is the keyword you entered on the FORMAT
column id is too large. WIDTH has been
command.
changed to 254 bytes.
old setting is the previous setting of the FORMAT
Explanation: You entered a width greater than 254.
keyword.
The system has set the width of the column to the
maximum of 254.
new setting is the new setting of the FORMAT keyword.
column id is the column id you entered.
System Action: The system sets the indicator as
specified by the command.
System Action: The command is processed as if the
command FORMAT COLUMN column id WIDTH 254
had been entered.
ARI7503I
ISQL erased the bottom title for this
query.
User Response: If you do not want a width of 254,
reenter the command with a width less than 254.
Explanation: The bottom title for this query has been
erased.
ARI7507E Command processing stopped. Enter a
System Action: The keyword is processed. Command
number after the keyword keyword. Try
processing continues if there are more keywords on the
again.
command. Otherwise, the system waits for you to enter
the next command.
Explanation: A nonnumeric value was specified for a
numeric option.
ARI7504E Command processing stopped. You
keyword is the keyword you entered on the FORMAT
entered an incorrect option token for the
command.
FORMAT keyword command. Reenter
System Action: Command processing has been
FORMAT keyword command with ON
stopped at the keyword indicated in the message. Any
or OFF.
keywords before this keyword have been processed; all
Explanation: You entered an incorrect option on the
other keywords are ignored.
FORMAT command.
User Response: Reenter the command using a number
token is the incorrect option you entered.
as the option.
keyword is the keyword you entered after the FORMAT
command.
ARI7508E Command processing stopped. You must
enter an option after the keyword
System Action: Command processing has been
keyword. Try again.
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
Explanation: You did not enter any option for the
other keywords are ignored.
keyword specified in the message. No default action is
taken.
User Response: Reenter the command with a valid
option. The valid options are ON and OFF.
keyword is the keyword you entered.
System Action: Command processing has been
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
other keywords are ignored.
160
Messages and Codes
ISQL Messages - ARI7001-ARI7970
User Response: Reenter the command, specifying the
ARI7513E Command processing stopped. You
desired option.
entered an incorrect column ID token
after the FORMAT keyword command.
ARI7509I
You entered a null string longer than 20
Reenter the command with a correct
characters. Only the first 20 characters
column ID. Only the first 45 columns
were used.
can be formatted.
Explanation: You entered a null string specification
Explanation: You entered an incorrect column id after
that is too long. The first 20 characters are accepted as
the FORMAT command.
the string; the rest are ignored.
token is the column id you entered.
System Action: The command is processed with first
keyword is the keyword you entered on the FORMAT
20 characters.
command.
User Response: If you do not want the shortened
System Action: Command processing has been
string as your null string, reenter the command with a
stopped at the keyword indicated in the message. Any
new string. The new string must not be longer than 20
keywords before this keyword have been processed; all
characters.
other keywords are ignored.
User Response: Reenter the FORMAT command with
ARI7510I
You have not defined a bottom title.
one or more column ids. Column id must be either a
Explanation: No bottom title (BTITLE) is defined now.
column name or a column number. If you enter more
than one column id, they must be enclosed in
System Action: The keyword is processed. Command
parentheses.
processing continues if there are more keywords on the
command. Otherwise, the system waits for you to enter
the next command.
ARI7514E Command processing stopped. You can
only enter a FORMAT SUBTOTAL
User Response: If you want a bottom title, use the
command after you enter a FORMAT
FORMAT BTITLE command to define one.
GROUP command.
Explanation: To enter a subtotal command, a
ARI7511I
keyword value is greater than the page
FORMAT GROUP command must have been
width. Information will be truncated if
previously entered. The command is ignored.
printed.
System Action: Command processing has been
Explanation: WARNING: Because the keyword value
stopped at the keyword indicated in the message. Any
is greater than the page width, it will be truncated
keywords before this keyword have been processed; all
when printed.
other keywords are ignored.
keyword value is the keyword value you entered.
User Response: Enter FORMAT GROUP; then reenter
System Action: The keyword is processed. Command
the FORMAT SUBTOTAL command.
processing continues if there are more keywords on the
command. Otherwise, the system waits for you to enter
ARI7515E Command processing stopped. Column
the next command.
column id is not a numeric column.
User Response: To avoid truncating the data, specify a
Reenter the FORMAT keyword
number smaller than the page size.
command using a numeric column.
Explanation: You tried to enter a FORMAT DECIMAL
ARI7512I
You entered a top or bottom title longer
or FORMAT ZEROS command on a nonnumeric
than 100 characters. Only the first 100
column.
characters will be used.
column id is the column id you entered.
Explanation: A top or bottom title can be at most 100
keyword is the keyword you entered on the FORMAT
characters. The first 100 characters are accepted; the rest
command.
are ignored.
System Action: Command processing has been
System Action: Title is set to the first 100 characters
stopped at the keyword indicated in the message. Any
you entered.
keywords before this keyword have been processed; all
User Response: If you do not want the shortened title,
other keywords are ignored.
reenter the FORMAT TTITLE or FORMAT BTITLE
User Response: Reenter the FORMAT command using
command with a different title. The new title must not
a numeric column.
be longer than 100 characters.
Chapter 12. ARI7001-ARI7970 ISQL Messages
161
ISQL Messages - ARI7001-ARI7970
ARI7516I
You entered a column name longer than
ARI7519E Command processing stopped. Specify a
30 characters on the FORMAT keyword
number for the number of decimal
command. Only the first 30 characters
places. Try again.
were used.
Explanation: The FORMAT COLUMN column id
Explanation: A column name can be at most 30
DPLACES command must be followed by a number.
characters. The first 30 characters are accepted; the rest
The number of decimal places must also be less than
are ignored.
the width of the column.
keyword is the keyword you entered on the FORMAT
System Action: Command processing has been
command.
stopped at the DPLACES keyword in error. Any
keywords before this keyword have been processed; all
System Action: The column name is set to or used as
other keywords are ignored.
the first 30 characters you entered.
User Response: Reenter the FORMAT COLUMN
User Response: If you do not want the shortened
column id DPLACES command with a valid number.
name, reenter the FORMAT command with a new
name. The new name must not be longer than 30
characters.
ARI7520E
Command processing stopped. You
entered an incorrect option token on the
FORMAT COLUMN column id
ARI7517E Command processing stopped. You
command. Reenter the command with
entered an incorrect column width for
one or more of the following options:
column column id. Reenter the
WIDTH, ZEROS, DPLACES, or NAME.
FORMAT command with a column
width from 1 to 254 characters.
Explanation: You entered an incorrect option on the
FORMAT COLUMN command.
Explanation: The column width must be a number
from 1 to 254.
token is the incorrect option you entered.
column id is the column id you entered.
column id is the column id you entered.
System Action: Command processing has been
System Action: Command processing has been
stopped at the column id indicated in the message. Any
stopped at the keyword indicated in the message. Any
keywords before the keyword associated with this
keywords before this keyword have been processed; all
column id have been processed; all other keywords are
other keywords are ignored.
ignored.
User Response: Reenter the FORMAT command with
User Response: Reenter the FORMAT command with
one or more of the options listed in the message.
a column width from 1 to 254.
ARI7521I
All columns are included.
ARI7518E Command processing stopped. The
Explanation: If the FORMAT INCLUDE command is
DPLACES value for column column id
entered without any column ids being specified, all
is too large. The number of decimal
columns are included.
places must be less than the column
width. Try again.
System Action: All columns are included in the
display.
Explanation: The width of a column must be at least
one larger than the number of decimal places specified
User Response: None if this is the desired result.
for that column.
Otherwise, exclude the columns you do not want
included.
column id is the column id you entered.
System Action: The command is ignored. Command
ARI7522I
Because you did not specify any column
processing has been stopped at the keyword indicated
IDs, all columns will be displayed.
in the message. Any keywords before this keyword
have been processed; all other keywords are ignored.
Explanation: You entered a FORMAT EXCLUDE ALL
BUT or FORMAT INCLUDE ONLY command without
User Response: You can either increase the column
any column ids. Therefore, all columns are included in
width so that it is larger than the number of decimal
the display.
places, or decrease the number of decimal places so
that a smaller column size can be specified.
System Action: All columns are included in the
display. Command processing continues if there are
more keywords on the command. Otherwise, the
system waits for you to enter the next command.
162
Messages and Codes
ISQL Messages - ARI7001-ARI7970
User Response: You can enter a FORMAT INCLUDE
ARI7527I
{Top|Bottom} title is too long to print
command for the columns you want included.
on one line. When you print your
report, part of the title may not appear.
ARI7523E Command processing stopped. Column
Explanation: The title will not fit on one line. The last
ID column id is not one of the first 45
part of the title may be cut off when your report is
columns. ISQL can only format the first
printed.
45 columns.
System Action: The keyword is processed. Command
Explanation: You tried to format a column that is not
processing continues if there are more keywords on the
one of the first 45 columns.
command. Otherwise, the system waits for you to enter
column id is the column id you entered.
the next command.
System Action: Command processing has been
User Response: None, if you don’t mind the
stopped at the column id indicated in the message. Any
shortened title. Otherwise, enter a shorter title, using
keywords before the keyword associated with this
the FORMAT command.
column id have been processed; all other keywords are
ignored.
ARI7528I
You did not enter the keyword BLANKS
User Response: Enter a new SELECT command that
on your FORMAT SEPARATOR
will make this column one of the first 45 columns.
command. The number itself is used as
Then reenter the FORMAT command.
your column separator.
Explanation: The number you entered will be used as
ARI7524I
Bottom title is btitle.
the column separator, not as the number of blanks
between your columns.
Explanation: The bottom title is now the value btitle.
System Action: The keyword is processed. Command
btitle is the current bottom title.
processing continues if there are more keywords on the
System Action: The keyword is processed. Command
command. Otherwise, the system waits for you to enter
processing continues if there are more keywords on the
the next command.
command. Otherwise, the system waits for you to enter
User Response: None, unless you want blanks
the next command.
between your columns. In that case, you must reenter
the FORMAT SEPARATOR command with the keyword
ARI7525I
Top title is ttitle.
BLANKS.
Explanation: The top title is now the value ttitle.
ARI7529I
The top title has been erased. The first
ttitle is the current top title.
100 characters of the SQL SELECT
statement will be used as the top title.
System Action: The keyword is processed. Command
processing continues if there are more keywords on the
Explanation: Your top title has been erased. The first
command. Otherwise, the system waits for you to enter
100 characters of the SELECT command will be used as
the next command.
the top title on your report.
System Action: The keyword is processed. Command
ARI7526E Command processing stopped. Zero is
processing continues if there are more keywords on the
not a valid value for keyword. Reenter
command. Otherwise, the system waits for you to enter
the command with a value greater than
the next command.
zero.
Explanation: You entered 0. Zero is not an acceptable
ARI7530E Command processing stopped. A right
value for this keyword.
parenthesis is missing on the FORMAT
keyword command. Reenter the
keyword is the keyword you entered on the FORMAT
command with matching parentheses.
command.
Explanation: You entered a left parenthesis without a
System Action: Command processing has been
matching right parenthesis.
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
keyword is the keyword you entered on the FORMAT
other keywords are ignored.
command.
User Response: Reenter the FORMAT command with
System Action: Command processing has been
a value greater than zero.
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
other keywords are ignored.
Chapter 12. ARI7001-ARI7970 ISQL Messages
163
ISQL Messages - ARI7001-ARI7970
User Response: Reenter the FORMAT command with
ARI7534E Command processing stopped. You
matching parentheses.
entered an incorrect column ID token on
the FORMAT keyword command. All
ARI7531I
The separator you entered was too long.
columns will be displayed. Reenter the
The separator length has been shortened
command with a correct column ID.
to 254 bytes.
Explanation: You entered either FORMAT EXCLUDE
Explanation: The length of the separator cannot be
ALL BUT or FORMAT INCLUDE ONLY with an
greater than 254.
incorrect column id. All columns will be included in
the display.
System Action: The keyword is processed. Command
processing continues if there are more keywords on the
token is the incorrect column id you entered.
command. Otherwise, the system waits for you to enter
keyword is the keyword you entered on the FORMAT
the next command.
command.
User Response: None, if you do not mind the
System Action: Command processing has been
shortened separator. Otherwise, enter a shorter
stopped at the keyword indicated in the message. Any
separator, using the FORMAT command.
keywords before this keyword have been processed; all
other keywords are ignored.
ARI7532I
You cannot do the GROUP and
User Response: Reenter the FORMAT command with
SUBTOTAL on the same column.
one or more column ids. Column id must be either a
Column column id has been ignored in
column name or a column number. If you enter more
the FORMAT keyword command, but
than one column id, they must be enclosed in
processing continues.
parentheses.
Explanation: You tried to group and subtotal on the
same column. Only one will be done. The message
ARI7535E Command processing stopped. You did
states which keyword will not be processed.
not enter any column IDs between the
column id is the column id you entered.
parentheses on the FORMAT keyword
command. All columns will be included
keyword is the keyword you entered on the FORMAT
in the display. Reenter the FORMAT
command.
keyword command with a list of column
System Action: The keyword is processed. Command
IDs.
processing continues if there are more keywords on the
Explanation: You did not enter any column ids
command. Otherwise, the system waits for you to enter
between the parentheses on your FORMAT command.
the next command.
keyword is the keyword you entered on the FORMAT
User Response: If you don’t want this result, reformat
command.
your display. See the DB2 Server for VSE & VM
Interactive SQL Guide and Reference manual.
System Action: Command processing has been
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
ARI7533I
Because there are no columns to group,
other keywords are ignored.
subtotaling will no longer be done.
User Response: Reenter the FORMAT command with
Explanation: You entered a FORMAT GROUP ERASE
a list of column ids between the parentheses.
command, so there are no more columns to group by.
Therefore, subtotaling can no longer be done.
ARI7537E Command processing stopped. You did
System Action: All subtotals are erased. Command
not enter any column IDs between the
processing continues if there are more keywords on the
parentheses on the FORMAT keyword
command. Otherwise, the system waits for you to enter
command. Reenter the FORMAT
the next command.
keyword command with a list of column
User Response: If you want subtotals, enter a
IDs.
FORMAT GROUP command followed by a FORMAT
Explanation: You did not enter any column ids
SUBTOTAL command.
between the parentheses on the FORMAT command.
keyword is the keyword you entered on the FORMAT
command.
System Action: Command processing has been
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed; all
164
Messages and Codes
ISQL Messages - ARI7001-ARI7970
other keywords are ignored.
EXCLUDE, or INCLUDE.
User Response: Reenter the FORMAT command with
Explanation: You entered a FORMAT command
a list of column ids between the parentheses.
without any keywords.
System Action: The command is ignored. The system
ARI7539I
The VARCHAR value you entered was
waits for you to enter the next statement.
too large. The VARCHAR size has been
User Response: Enter the command with one or more
changed to 254 bytes.
valid keywords.
Explanation: You entered a FORMAT VARCHAR
command with a value greater than 254.
ARI7546E Command processing stopped. Your
System Action: The command was processed with a
FORMAT keyword command needs an
VARCHAR size of 254.
option. Reenter the FORMAT keyword
command with ON or OFF.
ARI7543I
Your display data exceeds 45 columns.
Explanation: You entered an incomplete FORMAT
When using ISQL, no more than 45
command. The keyword must be followed by a value
columns can be displayed or formatted.
of ON or OFF.
Only the first 45 columns you selected
keyword is the keyword you entered on the FORMAT
will be displayed.
command.
Explanation: ISQL allows a maximum of 45 columns
System Action: Command processing has been
to be displayed or formatted. Any additional columns
stopped at the keyword indicated in the message. Any
will not be displayed.
keywords before this keyword have been processed; all
System Action: The command is processed normally.
other keywords are ignored.
Only the first 45 columns will be displayed.
User Response: Enter the command with a valid
User Response: If you want to display columns
option, either ON or OFF.
beyond the first 45, enter a SELECT command
specifically requesting those columns.
ARI7547E Command processing stopped. Your
FORMAT keyword command needs a
ARI7544I
More than one data row was affected by
column ID. Reenter FORMAT keyword
the previous statement. If you do not
command with a column ID. Only the
want the work committed, issue
first 45 columns can be formatted.
CANCEL or ROLLBACK. If you want
Explanation: You entered an incomplete FORMAT
the work committed, enter any other
command. The keyword must be followed with a
statement.
column id.
Explanation: An INSERT, DELETE, or UPDATE
keyword is the keyword you entered on the FORMAT
command affected more than one row and the
command.
AUTOCOMMIT is delayed.
System Action: Command processing has been
If referential constraints exist with a rule of SET NULL
stopped at the keyword indicated in the message. Any
or CASCADE then some of the affected rows may be in
keywords before this keyword have been processed; all
dependent tables.
other keywords are ignored.
System Action: The keyword is processed. Command
User Response: Enter the command with a column id.
processing continues if there are more keywords on the
command. Otherwise, the system waits for you to enter
the next command.
ARI7550D Warning: A logical unit of work is in
progress. If an SQL error occurs, a
User Response: You can either continue with work
ROLLBACK may result that will undo
(thereby committing the previous work), or enter
all the work you have done since the
CANCEL or ROLLBACK.
start of the logical unit of work. Do you
want to process the statement anyway?
ARI7545E Command processing stopped. Your
Enter 0(No) or 1(Yes).
FORMAT command needs a keyword.
Explanation: AUTOCOMMIT is OFF. Therefore, if an
Enter FORMAT with one or more of the
SQL error occurs while processing your statement,
following keywords: ON, OFF,
everything in this logical unit of work will be rolled
SUBTOTAL, TOTAL, GROUP,
back.
OUTLINE, SEPARATOR, VARCHAR,
NULL, TTITLE, BTITLE, COLUMN,
Chapter 12. ARI7001-ARI7970 ISQL Messages
165
ISQL Messages - ARI7001-ARI7970
System Action: The system waits for you to enter 0
ARI7556E Command failed. There is no current
(NO) or 1 (YES).
SQL statement to store.
User Response: If you are not worried about losing
Explanation: You tried to store an SQL statement, but
any work you have done, enter 1. To save the work
there is no SQL statement to store.
you have done before processing this statement, enter
0. Then you can enter COMMIT or SET
System Action: The system waits for you to enter the
AUTOCOMMIT ON. Then you can reenter your
next statement.
statement.
ARI7557I
Excess keywords after the ISQL
ARI7551I
Statement cancelled as requested.
command command are ignored.
Explanation: You entered CANCEL.
Explanation: There are extra keywords on the ISQL
command. They are ignored.
System Action: The command in process is cancelled,
and a ROLLBACK is done. The system waits for you to
ISQL command is the name of the command you
enter the next statement.
entered.
System Action: The command is processed. The extra
ARI7552E Command failed. You did not enter the
data is ignored.
name on the cmd command.
Explanation: You did not enter the name parameter
ARI7558E Command failed. Stored query table not
required by the command specified in the message.
found. Notify your system programmer.
cmd is the command you entered.
Explanation: SQLDBA.STORED QUERIES table was
either not created at installation, or was dropped.
System Action: The command is ignored. The system
waits for you to enter the next statement.
System Action: The command is not processed.
User Response: Reenter the command with the name
User Response: Notify your system programmer.
of the stored SQL statement you want.
System Programmer Response: Perform problem
determination. If a database system error occurred,
ARI7553E Command failed. Name entered is
make a record of what went wrong and contact the
longer than 8 characters. Reenter the
designated support group for your installation.
command with a name that is 8 or less
characters long.
ARI7559I
Command ended as requested.
Explanation: You entered a stored query name that
Explanation: You asked for the command to be ended.
was longer than 8 characters.
System Action: The system waits for you to enter the
System Action: The command is ignored. The system
next statement.
waits for you to enter the next statement.
User Response: Reenter the command with an
ARI7560E Command failed. The SQL statement
alphanumeric name of up to 8 characters.
you wanted to ISQL command was not
found. Try again.
ARI7554I
There is no previous SQL statement to
Explanation: You entered an ISQL command with an
recall.
SQL statement name that was not found.
Explanation: You tried to do a RECALL PREVIOUS,
ISQL command is the ISQL command you entered.
but there is no previous SQL statement to recall.
System Action: The system waits for you to enter the
System Action: The system waits for you to enter the
next statement.
next statement.
User Response: Check the spelling of the SQL
statement name you entered, or enter LIST SQL * to see
ARI7555I
There is no current SQL statement to
the names of your stored SQL statements. Then reenter
recall.
your ISQL command.
Explanation: You tried to do a RECALL, but there is
no current SQL statement to recall.
System Action: The system waits for you to enter the
next statement.
166
Messages and Codes
ISQL Messages - ARI7001-ARI7970
and, if necessary, notify your system programmer.
ARI7561E Command failed. You entered a
RENAME command without a new
System Programmer Response: Perform problem
name for your stored SQL statement.
determination. If a database system error occurred,
Reenter the RENAME command with
make a record of what went wrong and contact the
the old name followed by the new
designated support group for your installation.
name.
Explanation: You tried to rename a stored SQL
ARI7569E Command failed because of an SQL
statement, but you did not enter a new name for the
error.
command.
Explanation: An SQL error occurred which caused the
System Action: The system waits for you to enter the
system to stop processing your command.
next statement.
System Action: The system waits for you to enter the
User Response: To rename your stored SQL statement,
next statement.
reenter the RENAME command with the old name
User Response: Read the previous SQL error message
followed by the new name.
and, if necessary, notify your system programmer.
System Programmer Response: Perform problem
ARI7563E Command failed. A stored SQL
determination. If a database system error occurred,
statement named name already exists.
make a record of what went wrong and contact the
Choose another name and try again.
designated support group for your installation.
Explanation: You tried to rename a stored SQL
statement. The new name you chose already exists, so
ARI7570I
Processing for the ISQL command
you must choose another name.
command is complete.
name is the name you entered as the new name for the
Explanation: Processing is done for the indicated
SQL statement.
command.
System Action: The system waits for you to enter the
ISQL command is the name of the command you
next statement.
entered.
User Response: Reenter the RENAME command with
System Action: The system waits for you to enter the
a different new name. To see the names of the SQL
next statement.
statements you have already stored, enter LIST SQL *.
ARI7572E Command failed. You cannot use the
ARI7564E Command failed because of an SQL
word PREVIOUS. Reenter the command
error. Notify your system programmer.
with a different name.
Explanation: AUTOCOMMIT is ON. An SQL error
Explanation: PREVIOUS is a reserved word used to
has occurred while trying to commit work for your
refer to the previous SQL statement. You cannot
ISQL command.
STORE, ERASE, or RENAME an SQL statement with a
System Action: The system waits for you to enter the
name of PREVIOUS. You can RECALL PREVIOUS.
next statement.
System Action: The command is ignored; no
User Response: Notify your system programmer.
processing is done. The system waits for you to enter
the next statement.
System Programmer Response: Perform problem
determination. If a database system error occurred,
User Response: Reenter the command with a different
make a record of what went wrong and contact the
name.
designated support group for your installation.
ARI7574E Command failed. No SQL statement
ARI7568E Command failed because of an SQL
found on the HOLD command.
error. A ROLLBACK statement has been
Explanation: You entered a HOLD command without
issued.
including an SQL statement.
Explanation: An SQL error has occurred that forced a
System Action: The command is ignored; no
ROLLBACK to be issued. All work in this logical unit
processing is done. The system waits for you to enter
of work has been rolled back.
the next statement.
System Action: A ROLLBACK has been issued. The
User Response: Reenter the HOLD command,
system waits for you to enter the next statement.
including the SQL statement.
User Response: Read the previous SQL error message
Chapter 12. ARI7001-ARI7970 ISQL Messages
167
ISQL Messages - ARI7001-ARI7970
System Action: The system waits for you to enter the
ARI7575E Command failed. An invalid SQL
next statement.
statement was found on the HOLD
command.
ARI7579I
The stored SQL statement named name
Explanation: You entered a HOLD command with an
has been replaced.
invalid SQL statement.
Explanation: This messages indicates that the previous
System Action: The command is ignored; no
copy of the stored SQL statement has been replaced.
processing is done. The system waits for you to enter
the next statement.
name is the SQL statement name you entered.
User Response: Reenter the HOLD command with a
System Action: The system waits for you to enter the
valid SQL statement.
next statement.
ARI7576D Enter END, REPLACE, or a new name
ARI7580I
The processing to store the SQL
which is 1 to 8 characters long. You
statement named name has been
cannot choose the word PREVIOUS as a
stopped by your request. The SQL
name.
statement has not been stored.
Explanation: Your reply to message ARI7577D could
Explanation: This message indicates that, at your
not be used as a stored SQL statement name.
request, the storing of the SQL statement has not been
done. This message is displayed when you reply END
System Action: The system waits for your reply. If the
to message ARI7576D or message ARI7577D.
reply is REPLACE, the stored SQL statement is
replaced. If the reply is END, processing of the store
name is the SQL statement name you entered.
command ends. If a name other than PREVIOUS is
System Action: The system waits for you to enter the
entered, the SQL statement is stored under the new
next statement.
name.
User Response: Enter REPLACE, END, or a new
ARI7581I
There was no stored SQL statement
name for the SQL statement.
named name. Your SQL statement has
been stored as a new command.
ARI7577D A stored SQL statement named name
Explanation: This message is displayed when the
already exists. Enter a new name to
STORE command is entered with the REPLACE option,
store the SQL statement, or enter one of
but there is no stored SQL statement by that name to
the following keywords: REPLACE - to
be replaced.
replace the existing stored SQL
statement, or END - to end the store
name is the SQL statement name you entered.
command processing.
System Action: The system stores your SQL statement
Explanation: The system cannot store the SQL
as a new command. The system waits for you to enter
statement under the name you have given it because
the next statement.
that name is already in use.
name is the name you entered for the SQL statement.
ARI7582I
REPLACE is the only optional keyword
on the STORE command. token has
System Action: The system waits for your reply. If the
been ignored.
reply is REPLACE, the stored SQL statement is
replaced. If the reply is END, processing of the store
Explanation: This message indicates that excess data
command ends. If a name other than PREVIOUS is
was found on the STORE command, instead of the
entered, the SQL statement is stored under the new
optional keyword REPLACE.
name.
token is the excess data on the STORE command.
User Response: Enter REPLACE, END, or a new
System Action: The STORE command processing
name for the SQL statement to be stored.
continues.
ARI7578I
The SQL statement named name has
ARI7583E Command failed because of an error in
been stored.
STORE command processing. Notify
Explanation: This message indicates that the SQL
your system programmer.
statement has been stored.
Explanation: An error condition occurred in the
name is the SQL statement name you entered.
processing of the STORE command.
System Action: The command is not processed.
168
Messages and Codes
ISQL Messages - ARI7001-ARI7970
User Response: Notify your system programmer.
System Action: The STORE command processing
continues.
System Programmer Response: Perform problem
determination. If a database system error occurred,
make a record of what went wrong and contact the
ARI7601I
ISQL ended normally on your request.
designated support group for your installation.
Explanation: ISQL ending message. This message is
displayed when you enter the EXIT command and
ARI7585I
The stored SQL statement named name
autocommit processing was on.
has been erased.
System Action: ISQL ends.
Explanation: This message indicates that a stored SQL
statement has been erased.
ARI7602D You are in a logical unit of work. Enter
name is the SQL statement name you entered.
COMMIT to have a COMMIT issued
for you, or ROLLBACK to have a
System Action: Command processing continues if
ROLLBACK issued for you.
there are more SQL statement names on the command.
Otherwise, the system waits for you to enter the next
Explanation: This message is displayed when you
command.
enter the EXIT command and autocommit processing is
off, or when you enter SET AUTOCOMMIT ON and
autocommit processing is off.
ARI7590I
An SQL statement name must be no
more than 8 characters long.
System Action: The system waits for your reply. The
action taken by the system for each reply is as follows:
Explanation: The name under which an SQL
statement is stored cannot exceed 8 characters. You
COMMIT
A COMMIT is issued and a message
must choose a shorter name.
is generated stating whether the
commit work was successful or not. If
System Action: Command processing continues if
the command entered was EXIT and
there are more SQL statement names on the command.
the commit work was successful ISQL
Otherwise, the system waits for you to enter the next
ends. If the command entered was
command.
EXIT and the commit work was not
successful, ISQL does not end. If the
ARI7591I
PREVIOUS cannot be used as a name
command entered was SET
for a stored SQL statement.
AUTOCOMMIT ON, autocommit
processing is turned on only if the
Explanation: The name PREVIOUS is reserved for use
commit work was successful.
by the system. You must choose a different name.
ROLLBACK
A ROLLBACK is issued and a
System Action: Command processing continues if
message is generated stating whether
there are more SQL statement names on the command.
the rollback work was successful or
Otherwise, the system waits for you to enter the next
not. If the command entered was
command.
EXIT and the rollback work was
successful, ISQL ends. If the
ARI7592I
The stored SQL statement named name
command entered was EXIT and the
was not found.
rollback work was not successful,
ISQL does not end. If the command
Explanation: A stored SQL statement specified on the
entered was SET AUTOCOMMIT ON,
LIST SQL statement or ERASE command was not
autocommit processing is turned on
found.
only if the rollback work was
successful.
name is the SQL statement name you entered.
User Response:
Give one of the specified replies.
System Action: Command processing continues if
there are more stored SQL statement names on the
command. Otherwise, the system waits for you to enter
ARI7603I
{COMMIT|ROLLBACK} successful.
the next command.
ISQL now ended.
Explanation: Message displayed when you exit from
ARI7593I
Excess data token is ignored.
ISQL, and the commit work or rollback work that is
performed is successful.
Explanation: You entered more than a new stored SQL
statement name in response to message ARI7576D or
System Action: ISQL ends.
message ARI7577D.
token is the excess data that was ignored.
Chapter 12. ARI7001-ARI7970 ISQL Messages
169
ISQL Messages - ARI7001-ARI7970
ARI7604E ISQL-command command failed.
ARI7613I
CHANGE completed.
{COMMIT|ROLLBACK} not successful.
Explanation: The change was completed by the
See the previous SQL messages for a
CHANGE command.
complete explanation. Enter the
ISQL-command command again or enter
System Action: The changed SQL statement is
another command.
displayed. The system waits for you to enter the next
statement.
Explanation: You replied COMMIT or ROLLBACK to
message ARI7602D, and the COMMIT or ROLLBACK
was not successful.
ARI7614E ISQL command command failed. There
is nothing in the SQL statement buffer.
ISQL-command is the ISQL command you entered.
Enter your next SQL statement.
System Action: The system waits for you to enter the
Explanation: You entered a START or CHANGE
next statement.
command but there was no SQL statement in the SQL
User Response: Try the command again or enter
statement buffer.
another command. Notify your system programmer if
ISQL command is the ISQL command you entered.
the problem continues.
System Action: Processing of the command stops. The
System Programmer Response: Perform problem
system waits for you to enter the next statement.
determination. If a database system error occurred,
make a record of what went wrong and contact the
User Response: Enter the desired SQL statement.
designated support group for your installation.
ARI7615E ISQL command command failed. The
ARI7607I
There is nothing to ignore.
SQL statement name name on the ISQL
command command is too long. Use an
Explanation: You entered the ISQL IGNORE
SQL statement name which is 8
command when you were not continuing a command
characters long or fewer.
or data.
Explanation: An SQL statement name more than eight
System Action: The system waits for you to enter the
characters long was entered with an ISQL command.
next statement.
name is the SQL statement name you entered.
ARI7611E The CHANGE command nulled out the
ISQL command is the ISQL command you entered.
SQL statement buffer. Enter your next
System Action: Processing of the command stops. The
SQL statement.
system waits for you to enter the next statement.
Explanation: You entered a CHANGE command
User Response: Enter the command with a stored
which nulled out the current SQL buffer.
SQL statement name which is not more than eight
System Action: The system waits for you to enter the
characters long.
next statement.
User Response: Enter the desired SQL statement.
ARI7616I
ISQL command command cancelled at
your request.
ARI7612E CHANGE command failed. character
Explanation: CANCEL was entered during the
string was not found in your current
processing of a command.
SQL statement. Check the character
ISQL command is the ISQL command that was being
string you want to change and try again.
processed.
Explanation: The character string you entered on the
System Action: Command processing stops. A
CHANGE command was not found in your current
ROLLBACK is issued. The system waits for you to
SQL statement.
enter the next statement.
character string is the character string you wanted to
change. If the string is more than 20 characters long,
ARI7617E ISQL command command failed. A
only the first 20 characters are shown in the message.
nonzero code was returned during the
System Action: The system waits for you to enter the
processing of the ISQL command
next statement.
command. See the previous message for
the explanation and the action to take.
User Response: Enter RECALL to see the current SQL
statement. Then enter the CHANGE command with the
Explanation: A DB2 Server for VSE error was
character string you want to change.
encountered while processing the ISQL command.
170
Messages and Codes
ISQL Messages - ARI7001-ARI7970
ISQL command is the ISQL command that was being
ARI7621I
The counter for the LIST SQL statement
processed.
is full. Counting of stored SQL
System Action: Command processing stops. The
statements will stop, but listing will
system waits for you to enter the next statement.
continue.
User Response: Try the command again or enter
Explanation: You have more than 2 million stored
another command. Notify your system programmer if
SQL statements.
the problem continues.
System Action: Listing of the stored SQL statements
System Programmer Response: Perform problem
continues.
determination. If a database system error occurred,
make a record of what went wrong and contact the
ARI7622E ISQL command command failed. ISQL
designated support group for your installation.
command ISQL command not allowed at
this time. Enter any command except
ARI7618E ISQL command command failed. SQL
display commands or input commands.
statement name was not found. Enter
Explanation: You entered an ISQL command which
the ISQL command command with the
could not be processed now. For example, this message
name of one of your stored SQL
is generated if you enter a display command when you
statements.
are not displaying the results of a SELECT.
Explanation: You tried to list or start an SQL
ISQL command is the ISQL command you entered.
statement that was not previously stored.
System Action: Processing of the command stops. The
ISQL command is the ISQL command you entered.
system waits for you to enter the next statement.
name is the SQL statement name you entered.
User Response: Enter an allowable command.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
ARI7623E token is not an SQL or an ISQL
User Response: Enter the name of a stored SQL
command. Enter any command except
statement on the ISQL command, or enter LIST SQL *
display commands or input commands.
to see all your stored SQL statements.
Explanation: You did not enter a valid SQL or ISQL
command.
ARI7619E ISQL command command failed. There
token is what was entered.
was a missing parenthesis or no
parentheses on the parameter list of the
System Action: The system waits for you to enter the
ISQL command command. Enter the
next statement.
command with parentheses around the
User Response: Enter a command.
parameter list.
Explanation: There was no ending parenthesis on the
ARI7624E HELP command failed. topic is not a
parameter list, an uneven number of parentheses in the
HELP topic. Enter HELP or HELP
parameter list, or no parentheses around the parameter
CONTENTS for a list of topics.
list of the command.
Explanation: Your entry for the topic on the HELP
ISQL command is the ISQL command you entered.
command is not part of the HELP documentation.
System Action: Processing of the command stops. The
topic is the topic you entered.
system waits for you to enter the next statement.
System Action: Processing of the command stops. The
User Response: Enter the command with the corrected
system waits for you to enter the next statement.
parameter list.
User Response: Enter an ISQL HELP command in one
of the following forms:
ARI7620I
You have number stored SQL
statements.
HELP
HELP CONTENTS
Explanation: This is a count of your stored SQL
HELP topic
statements displayed when LIST SQL * is entered.
number is the actual count.
System Action: The system waits for you to enter the
next statement.
Chapter 12. ARI7001-ARI7970 ISQL Messages
171
ISQL Messages - ARI7001-ARI7970
System Action: Your SQL statement result will be
ARI7625E HELP command failed. The topic on the
formatted with the default formatting information that
HELP command is more than 20
is in effect when the SQL statement is started. The
characters long. Enter HELP or HELP
system waits for you to enter the next statement.
CONTENTS for a list of topics.
Explanation: Your entry for the topic on the HELP
ARI7629E CHANGE command failed. The format
command could not be processed because it was more
of the CHANGE command is CHANGE
than 20 characters long.
/string1/string2/ or CHANGE /string1//.
System Action: Processing of the command stops. The
Enter the CHANGE command by using
system waits for you to enter the next statement.
one of these formats.
User Response: Enter an ISQL HELP command in one
Explanation: The CHANGE command you entered
of the following forms:
was not in the right format.
HELP
System Action: Processing of the command stops. The
HELP CONTENTS
system waits for you to enter the next statement.
HELP topic
User Response: Enter the command with a correct
format.
ARI7626E ISQL command command failed. There
is not enough main storage available.
Try again later.
ARI7630E CHANGE command failed. The change
you requested cannot be made because
Explanation: The virtual storage needed for
it would make the SQL statement longer
processing the command was not available.
than 2048 characters. Enter the
ISQL command is the ISQL command you entered.
CHANGE command with string2 the
same size or smaller than string1.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
Explanation: You entered a CHANGE command
which would make the SQL statement in the SQL
User Response: Try the command again. If the
statement buffer longer than 2 048 characters.
condition continues, notify your system programmer.
System Action: Command processing stops. No
System Programmer Response: If this condition
change is made to the SQL statement in the current
persists, increase the SIZE parameter on the CICS EXEC
buffer. The system waits for you to enter the next
job control statement and the CICS partition size.
statement.
User Response: Enter the CHANGE command with
ARI7627E ISQL command command failed. The
string2 the same size or smaller than string1.
previous SQL statement cannot be used
on the ISQL command command. Enter
the ISQL command command with
ARI7631E Enter the START command with the
another stored SQL statement name.
corrected parameter list or correct the
parameter in your SQL statement.
Explanation: The previous SQL statement cannot be
processed by this ISQL command.
Explanation: This message is displayed when the
parameter substitutions could not be performed on the
ISQL command is the ISQL command you entered.
SQL statement in the current buffer. Refer to the
System Action: Processing of the command stops. The
previous message to determine the cause of the
system waits for you to enter the next statement.
problem.
User Response: Use another name for the SQL
System Action: Processing of the command stops. The
statement.
system waits for you to enter the next statement.
User Response: Refer to the previous message for the
ARI7628I
The formatting information for your
action to take.
SQL statement has been erased because
you changed the SELECT list or the
ARI7632E oper command operator command
table name. The default formatting
failed. A system error occurred during
information will be used for displaying
the oper command operator command.
the results of your SQL statement.
Notify your system programmer.
Explanation: You entered a CHANGE command
Explanation: An incorrect parameter was passed to
which could make the format information for the SQL
ARIICMD from ARIIOCI (interface module to operator
statement incorrect. The format information is dropped.
command processing).
172
Messages and Codes
ISQL Messages - ARI7001-ARI7970
oper command is the DB2 Server for VSE operator
System Action: The system waits for you to enter the
command being executed.
next statement.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
ARI7636D Enter END to end the oper command
command or press the Enter key to see
User Response: Notify your system programmer.
more information.
System Programmer Response: Perform problem
Explanation: Message asking if you want to end the
determination. If a database system error occurred,
operator command (reply END) or continue (press the
make a record of what went wrong and contact the
ENTER key).
designated support group for your installation.
oper command is the DB2 Server for VSE operator
command being executed.
ARI7633E oper command operator command
failed. Insufficient main storage is
System Action: The system waits for your reply.
available. Try again later.
Command processing stops if you reply END. The next
data is displayed if you just press the ENTER key. The
Explanation: There is not enough virtual storage
question is asked again if your reply is not END or
available to process the command.
ENTER.
oper command is the DB2 Server for VSE operator
User Response: Reply END or just press the ENTER
command you entered.
key.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
ARI7637E oper-command operator command
User Response: Try the command again. Notify your
failed. Operator commands cannot be
system programmer if the problem continues.
issued while you are in a logical unit of
work. Enter COMMIT or ROLLBACK
System Programmer Response: Increase the CICS
and then enter the oper-command
partition size and the SIZE parameter on the EXEC
operator command.
statement of the CICS job stream.
Explanation: You tried to execute an operator
command while in a logical unit of work.
ARI7634E oper command operator command
failed. A system error occurred during
oper-command is the DB2 Server for VSE operator
the oper command operator command.
command you entered.
See the previous message for a complete
System Action: Processing of the command stops. The
explanation. Notify your system
system waits for you to enter the next statement.
programmer.
User Response: Enter a COMMIT or ROLLBACK
Explanation: There was a problem in the DB2 Server
command, and then enter the operator command again.
for VSE operator command processing modules. The
message before this one is an SQL message describing
the problem.
ARI7638I
A parameter is in the SELECT list or
table name in your SQL statement.
oper command is the DB2 Server for VSE operator
Therefore, any formatting you do while
command being executed.
viewing the query result will be erased
System Action: Processing of the command stops. The
when you end the display.
system waits for you to enter the next statement.
Explanation: You entered one or more parameters in
User Response: Notify your system programmer.
the SELECT-list or table name portion of your SQL
statement. Therefore, you cannot save any of the
System Programmer Response: Perform problem
formatting information you enter while viewing the
determination. If a database system error occurred,
query result.
make a record of what went wrong and contact the
designated support group for your installation.
System Action: Any formatting information you enter
while viewing the query result is erased when you end
the display. The system waits for you to enter the next
ARI7635I
oper command operator command
statement.
ended.
User Response: If you want to save the formatting
Explanation: The indicated operator command has
information, use the CHANGE command to change the
ended.
parameters to values, and start the SQL statement with
oper command is the DB2 Server for VSE operator
no parameter list.
command executed.
Chapter 12. ARI7001-ARI7970 ISQL Messages
173
ISQL Messages - ARI7001-ARI7970
formatting information remain the same. ROLLBACK
ARI7639D Last of the oper command operator
WORK is not performed. The system waits for you to
command information. Enter END to
enter the next statement.
end the display.
Explanation: This is the last screen of the operator
ARI7643E HELP command failed. HELP
command output. You must reply END when finished
documentation table table name was not
with the display. Command cleanup is then done and
found. Notify your system programmer.
the command ends.
Explanation: One of the HELP documentation tables
oper command is the DB2 Server for VSE operator
was not there.
command you entered.
table name is the name of the table that was not there
System Action: The system waits for your reply. The
(either SQLDBA.SYSTEXT1 or SQLDBA.SYSTEXT2).
display ends if your reply is END. You are asked for
another reply if your reply is not END.
System Action: The system waits for you to enter the
next statement.
User Response: Reply with END when finished
looking at the last screen of output.
User Response: Notify your system programmer.
System Programmer Response: Recreate the tables
ARI7640E SQL statement ignored. SQL statements
using the HELP text installation procedures provided in
cannot be processed while using the
the DB2 Server for VSE Program Directory.
INPUT command. To process your SQL
statement, enter END and then reenter
ARI7644E HELP command failed. No
your SQL statement.
documentation is in the table
Explanation: You entered an SQL statement while
SQLDBA.SYSTEXT2 for the topic that
using the INPUT command. Your SQL statement was
was entered. Notify your system
not processed.
programmer.
System Action: The system waits for you to enter the
Explanation: The HELP text table SQLDBA.SYSTEXT2
next statement.
did not contain documentation for the topic specified,
but the HELP text table SQLDBA.SYSTEXT1 listed the
User Response: If you want to process your SQL
topic.
statement now, end the INPUT command and then
reenter your SQL statement. Otherwise, continue to
System Action: The system waits for you to enter the
input your data.
next statement.
User Response: Notify your system programmer.
ARI7641D char will be used as the delimiter for
System Programmer Response: Recreate the tables
the CHANGE command. Do you want
using the HELP text installation procedures provided in
to continue? Enter 0(No) or 1(Yes).
the DB2 Server for VSE Program Directory. If the
Explanation: The / was not used as the delimiter on
problem persists, make a record of what went wrong
the CHANGE command. If you forgot the slash
and contact the designated support group for your
delimiters, you can now end the CHANGE command.
installation.
char is the delimiter used if the CHANGE command
continues.
ARI7645E EXIT command failed. Extra information
is on the EXIT command. Enter the
System Action: The system waits for your reply. If
EXIT command with no keywords or
your reply is 0, CHANGE command processing stops.
values.
If your reply is 1, the CHANGE command is processed.
Explanation: You entered something extra after the
User Response: Reply 0 to cancel the CHANGE
word EXIT.
command or 1 to continue the command.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
ARI7642I
CHANGE command cancelled. No
change was made to the SQL statement
User Response: Reenter the EXIT command with no
buffer.
extra data on it.
Explanation: Informative message generated when
you reply NO to message ARI7641D. The CHANGE
command is ended. The SQL statement in the current
buffer is not changed.
System Action: The SQL statement buffer and
174
Messages and Codes
ISQL Messages - ARI7001-ARI7970
ARI7646E HELP command failed. The HELP text is
ARI7702E The keyword token on the LIST SET
not installed. If you want to use this
command is not a valid choice. The
facility, notify your system programmer.
valid keywords are: keyword list.
Explanation: You entered the HELP command, but the
Explanation: You entered an incorrect keyword on the
HELP text table SQLDBA.SYSTEXT1 is empty.
LIST SET command.
System Action: The system waits for you to enter the
token is the incorrect keyword you entered.
next statement.
keyword list is the list of keywords allowed on the
User Response: Continue your ISQL session. Notify
command.
your system programmer if you would like to use the
System Action: Processing of the keyword is
HELP facility.
bypassed. Command processing continues if there are
System Programmer Response: Procedures for
more keywords on the command. Otherwise, the
installing the HELP text tables are provided in the DB2
system waits for you to enter the next command.
Server for VSE Program Directory.
ARI7709I
AUTOCOMMIT processing is
ARI7650E The EXTRACT command command has
{ON|OFF}.
been ignored because the Extract Facility
Explanation: This message shows the current
is no longer supported. Enter an SQL or
AUTOCOMMIT setting.
an ISQL command.
System Action: The keyword is processed. Command
Explanation: You entered an extract facility command,
processing continues if there are more keywords on the
but the database manager no longer supports the
command. Otherwise, the system waits for you to enter
extract facility.
the next command.
command is the extract facility command you entered.
System Action: The system waits for you to enter the
ARI7710I
The continuation character is char.
next statement.
Explanation: This message shows what the
User Response: Continue your ISQL session.
continuation character is.
char is the continuation character now in effect.
ARI7700I
Extra information was on the ISQL
System Action: The keyword is processed. Command
command command. token is ignored
processing continues if there are more keywords on the
but processing will continue.
command. Otherwise, the system waits for you to enter
Explanation: Extra data was found on the command
the next command.
you entered.
ISQL command is the ISQL command you entered.
ARI7711I
The system default print class will be
used for your reports.
token is the extra information that was ignored.
Explanation: Your print class is now set to the system
System Action: Normal command processing
default.
continues.
System Action: The keyword is processed. Command
processing continues if there are more keywords on the
ARI7701E ISQL command command processing
command. Otherwise, the system waits for you to enter
stopped. The keyword keyword on the
the next command.
ISQL command command is not correct.
The valid keywords are: keyword list.
ARI7712I
The keyword value is value.
Explanation: The keyword you entered on the
command was not valid.
Explanation: This message shows the value of a
keyword you requested.
keyword is the keyword you entered.
keyword is the keyword you entered on the LIST SET
ISQL command is the ISQL command you entered.
command.
keyword list is the list of the valid keywords.
value is the value of that keyword.
System Action: Processing of the command stops. The
System Action: The keyword is processed. Command
system waits for you to enter the next statement.
processing continues if there are more keywords on the
User Response: Enter the command with a valid
command. Otherwise, the system waits for you to enter
keyword.
the next command.
Chapter 12. ARI7001-ARI7970 ISQL Messages
175
ISQL Messages - ARI7001-ARI7970
&3. is the data type.
ARI7713I
number copies of your reports will be
&4. is position N, where N is an item in select list
printed.
where applicable. Position 0 is returned if an
Explanation: This message shows how many copies of
exception error occurs in the WHERE clause of the
each report will be printed.
SELECT statement.
number is the number of copies that will be printed.
Note: The message describes the first arithmetic
System Action: The keyword is processed. Command
exception error in the queried table.
processing continues if there are more keywords on the
System Action: Command processing continues.
command. Otherwise, the system waits for you to enter
the next command.
ARI7725E The ISQL command command
processing stopped. The command is
ARI7714I
The page size of your reports is:
not complete. You must specify
WIDTH: width LENGTH: length.
information.
Explanation: This message shows the page size of
Explanation: You entered a command that did not
your reports.
have all the required keywords or values.
width is the width of the printed page.
ISQL command is the ISQL command you entered.
length is the length of the printed page.
information is a list of what you did not specify on the
System Action: The keyword is processed. Command
command.
processing continues if there are more keywords on the
System Action: Processing of the command stops. The
command. Otherwise, the system waits for you to enter
system waits for you to enter the next statement.
the next command.
User Response: Enter the command with all needed
keywords and values.
ARI7715I
The separator value is number blanks.
Explanation: This message indicates how many blanks
ARI7726E The ISQL command command
will separate the columns when a query result is
processing stopped. The value you
displayed.
entered could not be processed. The
System Action: Command processing continues if
values that can be processed are valid
there are more keywords on the command. Otherwise,
values.
the system waits for you to enter the next command.
Explanation: Something was wrong with one of the
values on the command.
ARI7716I
User userid connected to server
ISQL command is the ISQL command you entered.
server-name.
valid values is the description of the valid values.
Explanation: This message shows the current user and
the current application server that are accessed as a
System Action: Processing of the command stops. The
result of the last implicit or explicit CONNECT
system waits for you to enter the next statement.
command.
User Response: Enter the command with valid values.
System Action: The system waits for you to enter the
next command.
ARI7727I
The old keyword value was old. The
new keyword value is new.
ARI7717I
One or more arithmetic exception errors
Explanation: The keyword value has been changed to
occurred. Exception error &1. has
the value you entered on the SET command.
occurred during &2. operation on &3.
data, position &4..
keyword is the keyword you entered on the SET
command.
Explanation: This message is issued whenever an
arithmetic operation on numeric data causes an
old is the old value of the keyword.
arithmetic exception error. An example of this error
new is the new value of the keyword.
may be a division by zero or an overflow (exceeds
maximum) during the processing of a SELECT
System Action: The keyword is processed. Command
command. The data from this error is denoted by
processing continues if there are more keywords on the
number signs (# # #) across the width of columns of the
command. Otherwise, the system waits for you to enter
queried table:
the next command.
&1. is the type of exception error.
&2. is the arithmetic operation on data.
176
Messages and Codes
ISQL Messages - ARI7001-ARI7970
ARI7729I
The keyword string is more than
ARI7734E SET command processing stopped. The
number characters long. The first
keyword value data is too long. Enter
number characters will be used.
the command with a value that is 1
character long.
Explanation: You entered a separator string or null
string with the SET command that was longer than the
Explanation: You entered a value that was too long to
maximum allowed.
be a class or continuation character value.
keyword is the type of string you entered.
keyword is the keyword you entered on the SET
command.
number is the number of characters that will be used.
data is the value you entered.
System Action: The indicated number of characters of
the string is saved.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
ARI7731I
The SET AUTOCOMMIT command has
User Response: Enter the command with a correct
been cancelled. The AUTOCOMMIT
value.
setting is not changed.
Explanation: You entered SET AUTOCOMMIT ON,
ARI7735I
The keyword value on the SET keyword
and then cancelled that action with a CANCEL
command is too large. It has been set to
command.
the maximum value number.
System Action: Command processing stops; the
Explanation: You entered a SET command with a
AUTOCOMMIT value is not changed. The system
keyword value greater than the maximum for that
waits for you to enter the next statement.
keyword.
keyword is the keyword you entered on the SET
ARI7732I
To commit work, you must enter the
command.
COMMIT statement yourself.
number is the maximum value for that keyword.
Explanation: You entered SET AUTOCOMMIT OFF. If
System Action: The value has been set to the
you want to commit work, you must enter the
maximum value for that keyword. Command
COMMIT statement.
processing continues if there are more keywords on the
System Action: The ISQL performs COMMIT
command. Otherwise, the system waits for you to enter
statements or ROLLBACK statements only if you
the next command.
request them. Command processing continues if there
are more keywords on the command. Otherwise, the
ARI7736E SET command processing stopped. char
system waits for you to enter the next command.
cannot be a continuation character. The
User Response: You must enter COMMIT to make the
continuation character can be any
changes that you make to tables permanent, or enter
character except a blank, a quote, or a
ROLLBACK to back out the changes.
semi-colon.
Explanation: You entered a continuation character that
ARI7733E SET command processing stopped. The
was not valid.
keyword value data could not be
char is the continuation character you entered.
processed. The keyword value must be
valid data.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
Explanation: You entered a SET command with a
value that is not valid.
User Response: Enter any continuation character
except a semicolon, a single or double quote, or a
keyword is the keyword you entered.
blank.
data is the data you entered.
valid data is a list of acceptable values for the keyword.
ARI7737I
action is successful. All COMMIT
statements and ROLLBACK statements
System Action: Processing of the command stops. The
will now be issued for you
system waits for you to enter the next statement.
automatically.
User Response: Enter the command with a correct
Explanation: You replied COMMIT or ROLLBACK to
value.
message ARI7602D during the SET AUTOCOMMIT
command.
action is either COMMIT or ROLLBACK.
Chapter 12. ARI7001-ARI7970 ISQL Messages
177
ISQL Messages - ARI7001-ARI7970
System Action: AUTOCOMMIT has been set on.
command. Otherwise, the system waits for you to enter
Command processing continues if there are more
the next command.
keywords on the command. Otherwise, the system
waits for you to enter the next command.
ARI7744I
The new column separator is separator.
Explanation: You changed the column separator. This
ARI7739E SET command processing stopped. No
message shows what the new separator is.
WIDTH or LENGTH keyword was
specified with the PAGESIZE keyword.
separator is the new column separator value.
Reenter the command with the WIDTH
System Action: The keyword is processed. Command
and/or LENGTH keywords.
processing continues if there are more keywords on the
Explanation: You entered a SET PAGESIZE command
command. Otherwise, the system waits for you to enter
that was not correct.
the next command.
System Action: Processing of the command stops. The
system waits for you to enter the next statement.
ARI7745I
The keyword value on the SET
PAGESIZE command is too small. It has
User Response: Enter the command with the correct
been set to the minimum value number.
keywords and values.
Explanation: You entered a SET command with a
keyword value that was less than the allowable
ARI7740E SET command processing stopped. The
minimum for that keyword.
keyword value cannot be zero. The
keyword value can be valid values.
keyword is the keyword you entered on the SET
PAGESIZE command.
Explanation: You entered a SET command with a
value of zero. This is not processed because zero is not
number is the minimum value for the keyword.
a meaningful value for the keyword.
System Action: The page width or page length has
keyword is the keyword you entered.
been set to the minimum value for that keyword.
Command processing continues if there are more
valid values is the valid range for the keyword.
keywords on the command. Otherwise, the system
System Action: Processing of the command stops. The
waits for you to enter the next command.
system waits for you to enter the next statement.
User Response: Reenter the command with a value in
ARI7746I
The keyword value on the SET
the given range.
PAGESIZE command is too large. It has
been set to the maximum value number.
ARI7742E SET command processing stopped. The
Explanation: You entered a SET command with a
keyword on the SET PAGESIZE
keyword value that was greater than the allowable
command must be valid data.
maximum for that keyword.
Explanation: You entered a SET PAGESIZE command
keyword is the keyword you entered on the SET
and the width or length was not valid.
PAGESIZE command.
keyword is the keyword that had a value that could not
number is the maximum value for the keyword.
be processed.
System Action: The page width or page length has
valid data is the range of valid values for the keyword.
been set to the maximum value for that keyword.
Command processing continues if there are more
System Action: Processing of the command stops. The
keywords on the command. Otherwise, the system
system waits for you to enter the next statement.
waits for you to enter the next command.
User Response: Enter the SET PAGESIZE command
with correct values for the width and length.
ARI7750E SET command processing stopped. The
PRINTROUTE keyword keyword is
ARI7743I
The old column separator was separator.
incorrect. You must specify one of the
following keywords:
Explanation: You changed the column separator. This
message shows what the old separator was.
DESTID followed by a POWER remote
separator is the old column separator value.
workstation ID (a number from 0
to 250) or
System Action: The keyword is processed. Command
TERMID followed by a CICS
processing continues if there are more keywords on the
terminal ID (1 to 4 characters) or
TOUSER optionally followed by a user
178
Messages and Codes
ISQL Messages - ARI7001-ARI7970
identifier (1 to 8 alphameric characters
or
ARI7754E SET command processing stopped. The
SYSTEM to route output to
TERMID termid is not correct. TERMID
the system printer.
must be followed by a CICS terminal
Explanation: You entered the SET PRINTROUTE
ID of 1 to 4 characters. Try again.
command with an incorrect keyword.
Explanation: The SET PRINTROUTE command had
keyword is the keyword you entered.
an incorrect terminal printer identification.
System Action: Command processing has been
termid is the incorrect terminal printer identification.
stopped at the keyword indicated in the message. Any
System Action: Command processing has been
keywords before this keyword have been processed. All
stopped at the keyword indicated in the message. Any
other keywords are ignored. The system waits for you
keywords before this keyword have been processed. All
to enter the next statement.
other keywords are ignored. The system waits for you
User Response: Enter the SET PRINTROUTE
to enter the next statement.
command with a valid keyword.
User Response: Reenter the SET PRINTROUTE
command with a correct CICS terminal id of 1 to 4
ARI7751E SET command processing stopped. The
characters.
DESTID destid is incorrect. You must
follow DESTID with a POWER remote
ARI7756E SET command processing stopped. The
workstation ID with a value from 0 to
TOUSER touser is not correct. TOUSER
250. Try again.
must be followed by a user identifier of
Explanation: The SET PRINTROUTE command had
1 to 8 alphameric characters. Try again.
an incorrect printer identification.
Explanation: The SET PRINTROUTE command had
destid is the VSE/POWER remote workstation id you
an incorrect user identifier.
entered.
touser is the incorrect user identifier.
System Action: Command processing has been
System Action: Command processing has been
stopped at the keyword indicated in the message. Any
stopped at the keyword indicated in the message. Any
keywords before this keyword have been processed. All
keywords before this keyword have been processed. All
other keywords are ignored. The system waits for you
other keywords are ignored. The system waits for you
to enter the next statement.
to enter the next statement.
User Response: Reenter the SET PRINTROUTE
User Response: Reenter the SET PRINTROUTE
command with a VSE/POWER remote workstation id
command with a valid user identifier of 1 to 8
from 0 to 250.
alphameric characters.
ARI7752I
Your reports will be routed to the
ARI7757I
The old page size width was: old width.
printer.
The new page size width is: new width.
Explanation: This message indicates where your
Explanation: The SET PAGESIZE command was
printed output will be routed.
entered with a WIDTH parameter only. Therefore, this
printer is the printer identification you specified on the
message states only new and old WIDTH values.
SET PRINTROUTE command.
old width is the previous page width value.
System Action: The system waits for you to enter the
new width is the new page width value.
next statement.
System Action: The system waits for you to enter the
next statement.
ARI7753I
Because your reports will be routed to a
CICS terminal printer, only one copy of
your reports will be printed.
ARI7758I
The old page size length was: old
length. The new page size length is: new
Explanation: When a CICS terminal printer is
length.
specified by the SET PRINTROUTE command, only one
copy will be printed, regardless of the number set by
Explanation: The SET PAGESIZE command was
the SET COPIES command.
entered with a LENGTH parameter only. Therefore, this
message states only the new and old LENGTH values.
System Action: The system waits for you to enter the
next statement.
old length is the previous page length value.
new length is the new page length value.
Chapter 12. ARI7001-ARI7970 ISQL Messages
179
ISQL Messages - ARI7001-ARI7970
System Action: The system waits for you to enter the
ARI7865D The printer is in use. Choose one of
next statement.
these options:
ARI7759I
Your reports will be routed to the
0
(Retry) - to try again now, or
system printer.
1
(End)
- to end your print request, or
2
(Wait)
- to wait until the printer
Explanation: This message indicates that your printed
is not in use.
output will be routed to the system printer.
Note: If you choose 2(Wait), your keyboard
System Action: Command processing continues if
will lock until the PRINT is completed.
there are more keywords. Otherwise, the system waits
Explanation: You entered a PRINT command and the
for you to enter the next command.
virtual printer was not available. You are given the
three choices shown in the message.
ARI7760E SET command processing stopped. The
System Action: The system waits for you to make a
SET PRINTROUTE command is not
choice.
complete. You must specify one of the
following keywords:
User Response: Choose one of the listed options.
DESTID followed by a POWER remote
ARI7866I
The system is trying to print your
workstation ID (a number from 0 to
report.
250) or
TERMID followed by a CICS
Explanation: You replied RETRY to message
terminal ID (1 to 4 characters) or
ARI7865D.
TOUSER optionally followed by a user
System Action: The system will try to print your
identifier (1 to 8 alphameric characters)
report. If the printer is still in use, message ARI7865D
or
will be displayed again.
SYSTEM to route output to the system
printer.
User Response: There is nothing to do if printing is
successful. If not, message ARI7865D will be displayed
Explanation: You entered the SET PRINTROUTE
again, and you can reply RETRY, END, or WAIT.
command without a keyword. The valid keywords are
DESTID, TERMID, TOUSER, or SYSTEM.
ARI7867I
The system will return to displaying the
System Action: Command processing has been
query result. Continue your ISQL
stopped at the keyword indicated in the message. Any
session.
keywords before this keyword have been processed. All
other keywords are ignored. The system waits for you
Explanation: You replied END to message ARI7865D.
to enter the next statement.
System Action: The system will return to displaying
User Response: Enter the SET PRINTROUTE
the query result.
command with a valid keyword.
User Response: You can continue your ISQL session.
The PRINT command can be reentered now or later.
ARI7761I
Because you set the DESTID to zero,
your reports will be routed to the
ARI7868I
Printing will begin when the printer is
system printer.
available. Your keyboard is locked until
Explanation: You specified a DESTID value of 0, 00, or
the printing is complete.
000. VSE/POWER considers a value of 0 to mean the
Explanation: You replied WAIT to message ARI7865D.
system printer.
System Action: The system is waiting for access to the
zero is either 0, 00, or 000.
printer.
System Action: The system waits for you to enter the
next statement.
ARI7869E The PRINT command failed. The
User Response: If you don’t want your report to be
TERMID termid is incorrect. TERMID
routed to the system printer, reenter the SET
must be followed by a CICS terminal
PRINTROUTE command with a DESTID value from 1
ID of 1 to 4 characters. Try again.
to 250. Otherwise, no action is required.
Explanation: You entered an incorrect CICS terminal
id.
termid is the terminal id you entered.
180
Messages and Codes
ISQL Messages - ARI7001-ARI7970
System Action: The system will return to displaying
correct CICS terminal id of 1 to 4 characters.
the query result.
User Response: Reenter the PRINT command with a
ARI7873E The PRINT command failed. The
correct CICS terminal id of 1 to 4 characters. If you did
terminal ID you specified was more
enter a correct id, notify your system programmer.
than 4 characters long. Follow TERMID
by a CICS terminal ID of 1 to 4
System Programmer Response: Check that the
characters. Try again.
terminal the user specified has an entry in the CICS
Terminal Control Table (TCT).
Explanation: You entered the TERMID keyword with
a TERMID value that was more than 4 characters long.
ARI7870E The PRINT command failed. The
System Action: The system will return to displaying
system does not support the terminal
the query result.
termid. Check the terminal ID you
User Response: Reenter the PRINT Command with a
entered and try again.
CICS terminal id from 1 to 4 characters.
Explanation: You entered a CICS terminal id that is
not supported by the system.
ARI7874E The PRINT command failed. The
termid is the terminal id you entered.
system does not accept a terminal ID of
0. Check the terminal ID you entered
System Action: The system will return to displaying
and try again.
the query result.
Explanation: You entered the TERMID keyword with
User Response: Check that you entered the CICS
a value of 0. The system does not accept a terminal id
terminal id correctly. If you did, there may be a system
of 0.
problem. In that case, notify your system programmer.
System Action: The system will return to displaying
System Programmer Response: Check that the
the query result.
terminal the user specified is supported under BMS. If
it is, check that terminal’s CICS Terminal Control Table
User Response: Reenter the PRINT command with a
(TCT) entry does not prevent data from being routed to
CICS terminal id from 1 to 4 characters. 0 cannot be a
it.
CICS terminal id.
ARI7871E The PRINT command failed. Your
ARI7875E The PRINT command failed. You must
report could not be routed to the CICS
follow DESTID with a POWER remote
terminal printer termid. Check the
workstation ID from 0 to 250. Try again.
terminal ID you entered and try again.
Explanation: You entered the DESTID keyword
Explanation: Your report could not be routed to the
without a VSE/POWER remote workstation id.
CICS terminal printer you entered.
System Action: The system will return to displaying
termid is the terminal id you entered.
the query result.
System Action: The system will return to displaying
User Response: Reenter the PRINT command with a
the query result.
VSE/POWER remote workstation id from 0 to 250.
User Response: Check that you entered the CICS
terminal id correctly. If you did, there may be a system
ARI7876E The PRINT command failed. The
problem. In that case, notify your system programmer.
POWER workstation ID you entered
was not a number. DESTID must be
System Programmer Response: An RTEFAIL error
followed by a POWER remote
occurred during the CICS ROUTE command. Check for
workstation ID from 0 to 250. Try again.
possible problems with the terminal or with BMS.
Explanation: You entered the DESTID keyword with a
VSE/POWER remote workstation id that is not a
ARI7872E The PRINT command failed. TERMID
number.
must be followed by a CICS terminal
ID of 1 to 4 characters. Try again.
System Action: The system will return to displaying
the query result.
Explanation: You entered the TERMID keyword
without a CICS terminal id.
User Response: Reenter the PRINT command with a
VSE/POWER remote workstation id from 0 to 250.
System Action: The system will return to display the
query result.
User Response: Reenter the PRINT command with a
Chapter 12. ARI7001-ARI7970 ISQL Messages
181
ISQL Messages - ARI7001-ARI7970
ARI7877E The PRINT command failed. You
ARI7883I
Your report has been routed to the
entered a POWER remote workstation
POWER remote workstation destid.
ID longer than 250. Reenter the PRINT
Explanation: Your report has been routed to the
command with a POWER remote
VSE/POWER remote workstation you specified.
workstation ID from 0 to 250.
destid is the VSE/POWER remote workstation id you
Explanation: You entered the DESTID keyword with a
specified.
VSE/POWER remote workstation id greater than 250.
System Action: Printing continues.
System Action: The system will return to displaying
the query result.
ARI7884I
Your output has been routed to the
User Response: Reenter the PRINT command with a
system printer.
VSE/POWER remote workstation id from 0 to 250.
Explanation: Your report has been routed to the
system printer, not to a terminal printer.
ARI7878I
Because your POWER remote
workstation is zero, your report has
System Action: Printing continues.
been routed to the system printer.
Explanation: You specified a DESTID value of 0, 00, or
ARI7893I
Your reply to message ARI7865D was
000. VSE/POWER considers a value of zero to mean
not correct. The system is trying to print
the system printer.
your report anyway.
System Action: The system will return to displaying
Explanation: You entered a reply other than RETRY,
the query result.
END, or WAIT to message ARI7865D.
User Response: If you don’t want your report to be
System Action: The system will try to print your
routed to the system printer, reenter the PRINT
report, as if you had replied RETRY. If the printer is
command with a DESTID value from 1 to 250.
still in use, message ARI7865D will be displayed again.
Otherwise, no action is required.
User Response: There is nothing you need to do if
printing is successful. If not, message ARI7865D will be
ARI7879E The PRINT command failed because of
displayed again, and you can reply RETRY, END, or
a system problem. Notify your system
WAIT.
programmer. You can continue your
ISQL session.
ARI7894I
The width of the data to be printed is
Explanation: The PRINT command failed due to a
greater than the printer width. The data
system problem.
to be printed has been shortened to fit
within the printer width.
System Action: The system will return to displaying
the query result.
Explanation: The width of the data to be printed is
greater than the system printer width.
User Response: Notify your system programmer. You
can continue your ISQL session.
System Action: The data will be printed up to a width
of 132 characters.
System Programmer Response: An RTESOME error
occurred during the CICS ROUTE command. Perform
User Response: There is nothing you need to do if
CICS problem determination.
you are satisfied with your report. To print further
data, use the COLUMN command to see the columns
you want to print, and enter the PRINT command
ARI7882I
You cannot specify CLASS or COPIES
again.
for a CICS terminal. Your report has
been routed to the CICS terminal
termid. A single copy of your report will
ARI7901E The PRINT command failed. You cannot
be printed without separator pages.
issue a PRINT command because you
were not viewing a query result. Issue a
Explanation: Your report has been routed to the CICS
SELECT statement.
terminal you specified. Class and copies cannot be
specified for a CICS terminal. One copy of your report
Explanation: You entered a PRINT command while
will be printed in the system class.
you were not viewing a query result. The PRINT
command is valid only while a query result is being
termid is the terminal id you specified.
displayed.
System Action: Printing continues.
System Action: The system waits for you to enter the
next statement.
182
Messages and Codes
ISQL Messages - ARI7001-ARI7970
User Response: Enter a SELECT statement before
ARI7907I
Only a single copy of your report can be
entering the PRINT command.
printed now. It will be printed in the
system print class without separator
ARI7902I
You entered the PRINT command, but
pages. If you need more than one copy,
there is no data to be printed. Your
see your system programmer.
report will contain only titles and
Explanation: The system print program is not
column headings.
operating properly.
Explanation: You entered a PRINT command, but
System Action: Your report will be printed as
there is no data in your query result to be printed.
described in the message.
System Action: The system will print your report. It
User Response: Notify your system programmer if
will contain only titles and column headings. The
you are concerned about only receiving one copy of
system waits for you to enter the next statement.
your report.
System Programmer Response: A nonzero return code
ARI7903E The PRINT command failed. You
was received when ISQL tried to invoke VSE/POWER.
entered an incorrect keyword token on
This could occur if VSE/POWER is not available, or if
the PRINT command. Try again.
there is a problem with VSE/POWER.
Explanation: You entered an incorrect keyword on the
PRINT command.
ARI7908I
You are trying to print a report that is
token is the incorrect keyword you entered.
wider than the page width. Only the
first number characters of your report
System Action: The system waits for you to enter the
will be printed.
next statement.
Explanation: You tries to print a report that is wider
User Response: Correct the keyword in error and
than the page width you set.
reenter the PRINT command. The correct keywords for
PRINT are CLASS, COPIES, DESTID, TERMID, and
number is the number of characters that will be printed.
SYSTEM.
System Action: Your report will be printed, but some
of the columns will be cut off.
ARI7904I
The PRINT function is being scheduled.
User Response: Enter the SET PAGESIZE command if
Explanation: Access to the print capability is being
you want to make your page wider. Reenter or start
scheduled. If the print capability is in use, the current
your SELECT command. Then reenter the PRINT
request will wait until the print capability is available
command.
for use.
System Action: The system is trying to gain access to
ARI7910E The PRINT command failed. The
the print capability.
CLASS keyword is specified without a
following value. Reissue the PRINT
command with a CLASS value of A to
ARI7905I
The PRINT function is in progress.
Z.
Explanation: The PRINT command is being processed.
Explanation: You entered the CLASS keyword without
System Action: The system fetches the data and
a following value.
processes the PRINT command.
System Action: The system waits for you to enter the
next statement.
ARI7906I
The name of your report is name.
User Response: Reenter the PRINT command,
number copies of this report will be
specifying an allowable CLASS value of A to Z.
printed in class class.
Explanation: Your report is being printed. The print
ARI7911E The PRINT command failed. The
class and number of copies are shown in the message.
CLASS value can only be one character
name is the user ID you entered when you signed on. If
long. Reissue the PRINT command with
you did not enter a user ID, the system uses the
a single character CLASS value of A to
terminal id for this value.
Z.
number is the number of copies to be printed.
Explanation: You entered a CLASS value greater than
one character in length.
class is your print class.
System Action: The system waits for you to enter the
System Action: The system prints your report.
next statement.
Chapter 12. ARI7001-ARI7970 ISQL Messages
183
ISQL Messages - ARI7001-ARI7970
User Response: Reenter the PRINT command,
ARI7918E
The PRINT command failed. You
specifying a valid CLASS value of A to Z.
specified too large a COPIES value.
Reissue the PRINT command with a
ARI7913E The PRINT command failed. You
COPIES value of 1 to 99.
specified an invalid class value. Reissue
Explanation: You entered a COPIES value greater than
the PRINT command with a CLASS
99.
value of A to Z.
System Action: The system waits for you to enter the
Explanation: The CLASS value you specified was not
next statement.
valid. It must be specified as alphabetic.
User Response: Reenter the PRINT command with a
System Action: The system waits for you to enter the
valid COPIES value of 1 to 99.
next statement.
User Response: Reenter the PRINT command with a
ARI7920E
A system problem exists. An SQL error
valid CLASS value of A to Z.
was encountered. The PRINT is
terminated. Notify your system
ARI7915E The PRINT command failed. You
programmer.
specified the COPIES keyword without
Explanation: An unexpected indication was received
a following value. Reissue the print
when closing or opening the cursor.
command with a COPIES value of 1 to
99.
System Action: The system waits for you to enter the
next statement.
Explanation: You entered the COPIES keyword with
no following value.
User Response: Notify your system programmer.
System Action: The system waits for you to enter the
System Programmer Response: Perform problem
next statement.
determination. Check the correctness of the table.
Reenter the PRINT command. If a database system
User Response: Reenter the PRINT command,
error occurred, make a record of what went wrong and
specifying an allowable COPIES value of 1 to 99.
contact the designated support group for your
installation.
ARI7916E The PRINT command failed. You
specified a nonnumeric COPIES value.
ARI7921E
An SQL error was encountered. The
Reissue the PRINT command with a
PRINT will continue, but you may not
COPIES value of 1 to 99.
have your full output.
Explanation: You entered a COPIES value that was
Explanation: An unexpected indication was received
not numeric.
when reading a row of data.
System Action: The system waits for you to enter the
System Action: Printing continues.
next statement.
User Response: Check the output to see if the full
User Response: Reenter the PRINT command with a
table was printed. If the full output was not obtained,
valid COPIES value of 1 to 99.
notify your system programmer.
System Programmer Response: Perform problem
ARI7917E The PRINT command failed. You cannot
determination. Check the output to see if the full table
specify a COPIES value of zero. Reissue
was printed. Check the correctness of the table. Reenter
the PRINT command with a COPIES
the PRINT command. If a database system error
value of 1 to 99.
occurred, make a record of what went wrong and
Explanation: You entered a COPIES value of zero.
contact the designated support group for your
installation.
System Action: The system waits for you to enter the
next statement.
ARI7922I
The PRINT command has been
User Response: Reenter the PRINT command with a
cancelled.
valid COPIES value of 1 to 99.
Explanation: The CANCEL command was entered or
you indicated you did not want to continue in response
to message ARI7923D.
System Action: The system waits for you to enter the
next statement.
184
Messages and Codes
ISQL Messages - ARI7001-ARI7970
ARI7923D This PRINT begins in column number1
ARI7933I
The ROLLBACK process is complete.
position number2. Do you want to
Explanation: Your ROLLBACK statement completed
continue? Press Enter to continue. If you
normally.
do not want to continue, enter 0(No).
System Action: The database manager backs out any
Explanation: The data as displayed does not start in
changes made since the last COMMIT or ROLLBACK.
column 1 position 1 of the table.
The system waits for you to enter the next statement.
number1 is the numeric value of the leftmost column in
the display.
ARI7934E The action statement failed. A portion of
number2 is the numeric value of the left most position
the statement is incorrect following or
within the leftmost column in the display.
involving token.
System Action: If you press the ENTER key, the table
Explanation: The portion of the action statement
will be printed as displayed, starting from the top of
following or involving token is incorrect.
the table. If you enter NO, the print will be ended.
System Action: The system waits for you to enter the
User Response: Enter a response to indicate whether
next statement.
to print the table from its current column (or tab)
User Response: Correct the error and reenter the
position or end this print.
statement.
ARI7924I
The PRINT function is completed.
ARI7937E You cannot use the SQL statement sql
Explanation: The print function has been completed.
command in ISQL.
System Action: The system waits for you to enter the
Explanation: You entered an SQL statement that
next statement.
cannot be processed by ISQL.
System Action: The command is ignored. The system
ARI7925E The PRINT command failed. User
waits for you to enter the next statement.
identifier must be 1 to 8 alphameric
User Response: For details on how to use this
characters.
command, see the DB2 Server for VSE & VM Application
Explanation: You entered an invalid user identifier.
Programming manual.
System Action: The system waits for you to enter the
next statement.
ARI7939E token is invalid. It must be either
numeric or MAX for forward or
User Response: Issue the PRINT command again,
backward.
specifying a valid user identifier. Refer to the DB2
Server for VSE & VM Interactive SQL Guide and Reference
Explanation: Either:
for the definition of a valid user identifier.
v You entered a nonnumeric value where only a
numeric value can be used.
ARI7926I
Your report has been queued for userid.
v You entered a FORWARD or BACKWARD command
with a nonnumeric value other than the keyword
Explanation: The print function has been completed.
MAX.
Your report has been queued into the POWER print
queue and destined for the user identifier you
token is the value you entered.
specified.
System Action: The command is ignored. The system
System Action: The system waits for you to enter the
waits for you to enter the next statement.
next statement.
User Response: Reenter the command with a proper
value.
ARI7932I
The COMMIT process is complete.
Explanation: Your COMMIT statement completed
ARI7940E Not enough storage is available for
normally.
processing the DISPLAY command you
System Action: Any changes made are committed to
entered. Try the command at a later time
the database. The system waits for you to enter the
or enter a different command.
next statement.
Explanation: You entered a command which requires
more virtual storage than the amount now available.
System Action: The command is ignored. The system
waits for you to enter the next statement.
Chapter 12. ARI7001-ARI7970 ISQL Messages
185
ISQL Messages - ARI7001-ARI7970
User Response: Retry the command. If this condition
ARI7945I
The CONNECT statement completed
persists, notify your system programmer.
successfully.
System Programmer Response: If this condition
Explanation: Your CONNECT statement completed
persists, increase the SIZE parameter on the CICS EXEC
normally.
job control statement and the CICS partition size.
System Action: The specified user is now connected
to the database manager. The system waits for you to
ARI7942E The command cmd is not a valid ISQL
enter the next statement.
command. Please enter another
command.
ARI7946E The CONNECT statement failed. If this
Explanation: You entered a command that is not
message is followed by an SQL error
recognized by ISQL.
message, follow its directions. If it is
cmd is the command you entered.
not followed by an SQL error message,
check the format of the CONNECT
System Action: The command is ignored. The system
statement and reenter it.
waits for you to enter the next statement.
Explanation: Your CONNECT statement failed.
ARI7943E The field token is not supported by
|
System Action: The CONNECT is not processed. If
ISQL DISPLAY processing. Reenter the
|
the CONNECT was issued from a bind process, the
SELECT statement without specifying
|
binding ends. The system waits for you to enter the
field token.
|
next statement.
Explanation: Your SQL statement explicitly or
User Response: Reenter the CONNECT statement
implicitly requests that a long field column is to be
after checking the USER ID and PASSWORD for
used. Long field data types are not supported by ISQL.
validity. If the problem persists, notify your system
programmer.
token is the name of the column.
System Programmer Response: Perform problem
System Action: The command is ignored. The system
determination. If a database system error occurred,
waits for you to enter the next statement.
make a record of what went wrong and contact the
User Response: Enter a different SQL statement or
designated support group for your installation.
reenter the SELECT statement without retrieving the
field specified in the message.
ARI7947E An internal processing error has
occurred. An invalid call occurred to the
ARI7944E System error. The field token is of a
SQL interface module. Notify your
type unknown to ISQL. Notify your
system programmer.
system programmer.
Explanation: An internal call was made to the SQL
Explanation: A column identified by token was
processing routine with a parameter list that was not
retrieved from the database manager, but the data type
valid.
of this column is not known to ISQL. Data types
System Action: The command is ignored. The system
known to ISQL are: INTEGER, SMALLINT, DECIMAL,
waits for you to enter the next statement.
FLOAT, CHAR, VARCHAR, LONG VARCHAR,
GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC,
User Response: Notify your system programmer.
DATE, TIME, and TIMESTAMP. However, long fields
System Programmer Response: Perform problem
are not supported by ISQL display processing. A long
determination. If a database system error occurred,
string column is either a LONG VARCHAR, LONG
make a record of what went wrong and contact the
VARGRAPHIC, VARCHAR(n) where n is greater than
designated support group for your installation.
254 but less than or equal to 32767, or
VARGRAPHIC(n) where n is greater than 127 but less
than or equal to 16383.
ARI7949I
Too many parameters were on the
command. They will be ignored.
System Action: The command is ignored. The system
waits for you to enter the next statement.
Explanation: You entered an SQL command with too
many fields specified.
User Response: Notify your system programmer.
System Action: The extra information on the
System Programmer Response: Perform problem
command is ignored. The system waits for you to enter
determination. If a database system error occurred,
the next statement.
make a record of what went wrong and contact the
designated support group for your installation.
186
Messages and Codes
ISQL Messages - ARI7001-ARI7970
This is the maximum size that a row can be for your
ARI7951I
The value specified would cause the
terminal size.
DISPLAY to be positioned before the
first or after the last column. The
System Action: The command is ignored. The system
DISPLAY will be positioned as far as
waits for you to enter the next statement.
possible in the direction specified.
User Response: Retry your query, selecting fewer
Explanation: You specified a value on an ISQL display
columns, or use the SET command to decrease the
command that, if used, would have resulted in an
VARCHAR value.
incorrect display.
System Action: The system processes as much as
ARI7955I
The system ended your query result to
possible of the command. The system waits for you to
process your command.
enter the next statement.
Explanation: You entered a command that cannot be
processed while you are viewing a query result.
ARI7952E You cannot use zero as a value for the
System Action: The system ends the query result and
COLUMN or TAB command. Reenter
processes the command.
the command with a value greater than
zero.
ARI7956E Command failed. This command is not
Explanation: You entered a COLUMN or TAB
valid while you view a query result
command with a value of zero. Zero is not an
from a routine.
acceptable value.
Explanation: You entered a command that is not valid
System Action: The command is ignored. The system
while you are viewing a query result from a routine.
waits for you to enter the next statement.
System Action: The command is ignored. The system
User Response: Reenter the COLUMN or TAB
waits for you to enter the next statement.
command with a value greater than zero.
User Response: Reenter the command, specifying a
valid option.
ARI7953E An internal processing error has
occurred within the DISPLAY processor.
Notify your system programmer.
ARI7957E The TAB command failed. The TAB
command is valid for the CHAR and
Explanation: An internal error was encountered in the
VARCHAR columns only. Tabbing into
ISQL display processor, ARIIDQY.
DECIMAL, FLOAT, INTEGER, and
System Action: The command is ignored. The system
SMALLINT columns is not allowed.
waits for you to enter the next statement.
Explanation: You can use the TAB command on
User Response: Notify your system programmer.
CHAR and VARCHAR columns only.
System Programmer Response: Perform problem
System Action: The command is ignored. The system
determination. If a database system error occurred,
waits for you to enter the next statement.
make a record of what went wrong and contact the
User Response: Enter next command.
designated support group for your installation.
ARI7958I
The COMMIT RELEASE process is
ARI7954E Query failed. Full query result row
complete.
length exceeded nnnn positions. Retry
query by selecting fewer columns or use
Explanation: The COMMIT RELEASE statement you
the SET command to decrease the
entered has completed normally.
VARCHAR value.
System Action: Any changes made to the database are
Explanation: The query result row length exceeds the
committed. The system waits for you to enter the next
maximum length of nnnn characters allowed by ISQL
statement.
for the screen size of your terminal: The maximum row
length is determined by taking the screen height,
ARI7959I
The ROLLBACK RELEASE process is
subtracting 4, multiplying this by 2, because SQL
complete.
retrieves 2 screens worth of data, adding 1 and
dividing this into the size of the buffer, 65535. The
Explanation: The ROLLBACK RELEASE statement
formula is:
you entered has completed normally.
65535 / (((SCREENHT - 4) * 2) + 1) = MAX ROW LENGTH.
System Action: Any changes made to the database are
rolled back. The system waits for you to enter the next
statement.
Chapter 12. ARI7001-ARI7970 ISQL Messages
187
ISQL Messages - ARI7001-ARI7970
User Response: Try again later. If this problem
ARI7960I
The query cost estimate for this SELECT
persists, notify your system programmer.
statement is number.
System Programmer Response: If this problem
Explanation: You entered a SELECT statement. The
persists, perform problem determination and contact
database manager has calculated a cost estimate for this
the designated support group for your installation.
query. The larger this number is, the longer you will
have to wait to see your query result.
ARI7966I
The value specified would cause the
number is the query cost estimate, ranging from 1 to
display to be positioned after the last
9999. If the query cost estimate is greater than 9999, the
character in the column. The display
value ">9999" is presented in the message. (The query
will be positioned at the rightmost
cost estimate is calculated by adding 1 to the result of
character in the column.
dividing the DB2 Server for VSE optimizer cost
estimate by 1000.)
Explanation: You specified a value on an ISQL display
command that, if used, would have resulted in an
System Action: Command processing continues unless
incorrect display.
you enter the CANCEL command.
System Action: The system processes as much as
User Response: If you do not want to wait for the
possible of the command. The system waits for you to
result, enter the CANCEL command.
enter the next statement.
ARI7961I
The DISPLAY command is valid only
ARI7967E HELP text for language id could not be
from a routine. It was ignored.
found.
Explanation: You entered a DISPLAY command from
Explanation: Either the topic name has been
the terminal while viewing a query result. The display
misspelled, or the HELP text for this topic cannot be
command is valid only from a routine.
found.
System Action: The command is ignored. The system
System Action: The system waits for you to enter the
waits for you to enter the next statement.
next command.
User Response: Verify the topic name and retry the
ARI7962E Command failed. A severe SQL error
command. If the topic cannot be found, contact your
has occurred. A CONNECT statement is
system programmer.
required in order to continue this ISQL
session. Report this message and the
System Programmer Response: Verify the existence of
previous SQL error message to your
HELP text for this topic in SYSTEXT2.
system programmer.
Explanation: A severe SQL error occurred while your
ARI7968E Invalid string of double-byte character
command was being processed.
set (DBCS) characters.
System Action: ISQL ends.
Explanation: A string of DBCS characters is either is
too long, contains bytes that are not properly paired, or
User Response: Notify your system programmer.
improperly terminated, as in having an opening so
System Programmer Response: Perform problem
delimiter (X’0E’) without a terminating si delimiter
determination. If a database system error occurred,
(X’0F’).
make a record of what went wrong and contact the
System Action: Command processing is ended.
designated support group for your installation.
User Response: Correct the input command and
re-enter it.
ARI7965I
A delay has occurred during ISQL
initialization. Try later.
ARI7969I
DISPLAY command has been processed
Explanation: A delay has occurred during ISQL
successfully.
initialization. This delay may be caused by various
reasons, for example:
Explanation: This message indicates that the display
v The maximum number of users allowed on ISQL has
command was processed successfully. In the case of a
been exceeded.
FORMAT TTITLE title or FORMAT BTITLE title, the
top title or bottom title respectively have the value of
v CICS is experiencing a delay due to heavy use of the
title.
system.
v CICS is experiencing a delay in obtaining storage for
System Action: The keyword is processed. Command
ISQL initialization.
processing continues if more keywords are on the
System Action: The system ends the ISQL transaction.
188
Messages and Codes
ISQL Messages - ARI7001-ARI7970
command. Otherwise, the system waits for you to enter
the next command.
ARI7970I
This DISPLAY command cannot be
processed because of graphic data
present.
Explanation: This message indicates that the display
command entered was correct but because the data to
be displayed has graphic data, the command cannot be
processed. This is a restriction of FORMAT TTITLE and
FORMAT BTITLE.
System Action: The keyword is processed. Command
processing continues if there are more keywords on the
command. Otherwise, the system waits for you to enter
the next command.
Chapter 12. ARI7001-ARI7970 ISQL Messages
189
|
||
|
|
|