Set up the RDBMS

Create the collections for the GEN and LOGAN database libraries for the Environment for this working environment.

Note: If you are installing Lawson Core Technology onto an IASP, you have the option create these collections in the IASP; however, it is not a requirement.
  1. If you have the SQL "Green Screen" interface, access the OS/400 command prompt and type the following commands:

    STRSQL

    CREATE COLLECTION GENDB

    CREATE COLLECTION LOGANDB

    where GENDB and LOGANDB are the names for the GEN and LOGAN database library collections. Names have a 10 character limit.

    Press F3 to exit STRSQL.

    Use Option 1 to save a record of your SQL commands, if desired.

    -or-

    If you are installing Lawson Core Technology onto an IASP, create these collections in the IASP:

    CREATE COLLECTION GENDB IN ASP IASPName

    CREATE COLLECTION LOGANDB IN ASP IASPName

    where

    GENDB and LOGANDB are the names for the GEN and LOGAN database library collections. Names have a 10 character limit.

    IASPName is the name of your IASP.

  2. If you have not purchased the SQL Green Screen interface, access the OS/400 command prompt and type the following commands:

    WRKMBRPDM FILE(YourLib/YourSource)

    Use F6 to create a new source member called SQLTEXT with Source Type TXT.

    Enter the following SQL commands as text, separated by a semicolon (;)

    CREATE COLLECTION GENDB; CREATE COLLECTION LOGANDB

    -or-

    If you are installing Lawson Core Technology onto an IASP, type

    CREATE COLLECTION GENDB IN ASP IASPName; CREATE COLLECTION LOGANDB IN ASP IASPName

    where

    GENDB and LOGANDB are the names for the GEN and LOGAN database library collections. Names have a 10 character limit.

    IASPName is the name of your IASP.

    Press F3 to exit and Enter to update.

    To execute the commands, type

    RUNSQLSTM SRCFILE(YourLib/YourSource) SRCMBR(SQLTEXT)