DB2 Server for VSE & VM: Interactive SQL Guide and Reference

Ignoring an SQL Line

Another way to correct a typing mistake in a multiple-line statement is to use the IGNORE command.

To illustrate, type the following (deptname is misspelled): 

   select depname,mgrno -

Press ENTER. Now, you realize the valid column name is DEPTNAME. Type: 

   ignore
DB2 Server for VSE

You receive the message: 

   ARI7061I Previous input ignored.

in the output area, and the status area contains ENTER A NEW COMMAND.

DB2 Server for VM

You receive the message: 

   ARI7061I Previous input ignored.

in the output area, and the status area contains VM READ.

You can now retype the statement, or use PF12 to retrieve the line for correction.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]