Defining Database Spaces

This procedure lets you define a database space in order to designate where data is stored.

  1. In the Product Line field on the Product Line Definition form of the Database Definition utility (dbdef), type or select any product line or data area. You will assign the database space to the product line or data area after the space is defined.
  2. Press Define (F6) and choose Database Space.

    The Database Space Definition form appears.

    The fields that appear vary depending on the database type. The following table describes the valid values for each database type.

    Field Description
    Database Space Name that identifies the database space you are defining.
    Type Type of database you use. Valid entries are IBM DB2, or Empty.
    Add Locally Not implemented.

    DB Space

    		 The location where your database files are stored. You must specify a location here or in the field below.

    Index Location

    ― or ―

    Index DB Space

    		 The location where your index files are stored. The default is the value in the Location field (directly above this field). You must specify a location here.
    Condition Name Not implemented.
    Is View

    Specifies whether the files in this space are views of non-Lawson tables in the Lawson database.

    The Reorganize Database (dbreorg) utility does not reorganize views.

    Setting this field to Yes allows you to define a file to the Lawson system, but dbdef will not create a file with that name. This allows the Lawson system to access the data in an external file, via Selects and Drills to it from within Lawson, etc.
    MetaData Imported

    Enter Yes or No. The default is No.

    If MetaData Imported is Yes, the view names and field names in those views will be V_<OriginalFileName>.

    Note: This field is only accessible if the value for the Is View field is Yes.
    Use RPG Naming

    Enter Yes or No. Yes indicates that files will be named using the standard Lawson conventions: DB<SC><PRE>, where <SC> is the 2–character system code and <PRE> is the 3–character database file prefix defined in dbdef.

    No indicates that the file should not be renamed within the Lawson system.

    For all files shipped by Lawson, this should be set to Yes.

  3. Press Enter twice.

    You are now ready to assign the database space to the product line or data area. See Modifying Product Lines Using Database Definition and Defining Data Areas and Data IDs Using Database Definition