Start of change

Command line processor CHANGE MAXLINESFROMSELECT command

The CHANGE MAXLINESFROMSELECT command changes the number of rows that the command line processor returns.

>>-CHANGE MAXLINESFROMSELECT--TO--integer----------------------><

integer
The maximum number of rows that are displayed after execution of:
  • An SQL SELECT statement
  • An SQL CALL statement that returns a result set
  • A command line processor LIST TABLES, DESCRIBE TABLE, or DESCRIBE CALL command

This value overrides the value of the MaxLinesFromSelect command line processor property during the command line processor session.

End of change