Creating the SYBASE Collection Through SQL/400

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

  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. From the command prompt, enter:
    STRSQL
  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.