Start of change

CHANGE MAXLINESFROMSELECT (Db2 command line processor)

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

Read syntax diagramSkip visual syntax diagram 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 Db2 command line processor LIST TABLES, DESCRIBE TABLE, or DESCRIBE CALL command

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

End of change