SQL$HELP72.HLB

    Used to size a page. Currently this is only used by the
    pagination control in the SQL HELP command.

1 – Environment

    You can use the SET PAGE LENGTH (or SET PAGESIZE) statement:

    o  In interactive SQL

    o  Embedded in host language programs

    o  As part of a procedure in an SQL module or other compound
       statement

    o  In dynamic SQL as a statement to be dynamically executed

2 – Format

  (B)0[m[1;4mSET[m[1m [1;4mPAGE[m[1m [1;4mLENGTH[m[1m qqqqq> integer qqqqqq>   [m
  [1m                                                      [m

3 – Examples

    This example uses the SET PAGE LENGTH command to change the
    pagination length of HELP.

    SQL> set page length 40;
    SQL> show display
    Output of the query header is enabled
    Output of the row counter is enabled
    Output using edit strings is enabled
    Page length is set to 40 lines
    Line length is set to 80 bytes
    Display NULL values using "NULL"