RMUALTER72.HLB  —  AREA-PAGE
    Specifies a storage area, a snapshot area, or a page in an area
    of the database to which you are currently attached.

1  –  Description

    Only one page of one area is accessible to RdbALTER at a time.
    This command switches you from one page of the currently attached
    database to another page.

    When you attach to a database, RdbALTER automatically makes area
    1 the current area and page 1 of that area the current page. To
    work on any other area and page, you must use the AREA . . . PAGE
    command.

    If you specify AREA but not PAGE, RdbALTER makes the area you
    specify current and fetches page 1 of that area.

    If you specify both AREA and PAGE, RdbALTER makes the area you
    specify current and fetches the page you specify from the new
    current area.

    If you specify an area or page that does not exist, an error
    occurs and the current area and page do not change.

    Use the PAGE option to switch from one page in the current area
    to another page in the current area.

2  –  Format

  (B)0AREA qqwq> storage-area-name qqqwqwqqqqqqqqqqq>qqqqqqqqqwq>
         mq> area-number qqqqqqqqqj mq> PAGE page-number qj

3  –  Arguments

3.1  –  storage-area-name

    Specifies a storage area of the current database by the storage
    area name, which is the name defined in the SQL CREATE STORAGE
    AREA statement. To specify a snapshot area, use the area-number
    parameter.

3.2  –  area-number

    Specifies a storage area or snapshot area of the current database
    by the area number, which is assigned when the database is
    created and is given on the first line of a page display.

3.3  –  page-number

    Identifies the area page to be altered. Express it as an integer
    from 1 to the number of pages in the area.

4  –  Examples

    Example 1

    The following example specifies the area JOBS of the currently
    attached database. No page number has been specified, so RdbALTER
    fetches page 1 of the area.

    RdbALTER> AREA JOBS

    Example 2

    The following example is similar to Example 1, except it
    specifies the area by its area number instead of its area name.
    If area 4 is the area named JOBS in the database, either command
    produces the same result.

    RdbALTER> AREA 4

    Example 3

    The following example fetches area 3, page 100:

    RdbALTER> AREA 3 PAGE 100
Close Help