Collection (Schema) Creation

A collection or library in DB2® for OS/400® is equivalent to a schema in DB2 for UNIX™.

  1. Launch "Interactive SQL"

    STRSQL COMMIT(*NONE)

  2. Create a Collection

    CREATE COLLECTION

    Press F4

    Enter field values:

    LIBRARY: name of the collection (Schema)

    ASP: 1

    WITH DATA DICTIONARY: Y

    Press ENTER

    Press F3 to quit ( choose Option 1 (save and exit) ).

Note: The name of the Schema should not begin with “Q”; libraries beginning with “Q” are system libraries.

This procedure creates: