Creating the SYBASE collection using SQL/400

The user ID for creating the SYBASE collection must have a valid CCSID for your language installation.

StepsTo create the SYBASE collection through SQL/400

  1. Log in to the AS/400 from the main console, a 5250 terminal, or a 5250 terminal emulator, using the ID that you want to own the collection (usually SYBASE).

  2. On the command line, enter:

    STRSQL
    

    The STRSQL program begins.

  3. On the SQL command line, enter:

    CREATE COLLECTION SYBASE
    

The collection process requires a few minutes to complete. You can create other collections by using this same syntax and substituting the name of the collection for "SYBASE."