To create the database from the OS/400 command line

  1. At the OS/400 command prompt, type

    WRKMBRPDM FILE(YourLibrary|YourSource)

  2. Press F6 to create a new source member called SQLTEXT with Source Type TXT.
  3. Enter the following SQL command

    CREATE COLLECTION LIBRARY_NAME

  4. Press F3 to exit.
  5. Press Enter to update.
  6. To execute the commands, type

    RUNSQLSTM SRCFILE(YourLibrary|YourSource) SRCMBR(SQLTEXT)