Changing Storage Parameters

Use this procedure to make changes to the storage parameters of the Lawson tables stored in the Microsoft SQL Server database.

To implement storage parameter changes

  1. Create a file containing the values and type the following command at the command prompt

    osql -U username -P password -S servername -i input_file -o output_file

    - or -

    Change existing values by issuing UPDATE SQL statements.

    For more information about using SQL statements to update tables, see “Microsoft SQL Server Transact-SQL Reference” from Microsoft SQL Server.

  2. For each table that you want to change index storage parameters for, at the command prompt, type

    bldmsf2000ddldataarea|dataID systemcode filename