Creating the SYBASE Collection Using the AS/400 SEU Utility

Use the SEU utility to create SYBASE collection. 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 user ID that is to be the owner of the SYBASE collection.
2. Start the SEU program. Enter:

   STRSEU

3. Press F4 and provide this information:
   • Source File – QQMQRYSRC
   • Source Member – *SELECT
   • Library File – QGPL

   If the source file does not exist, you must create it using the CRTSRCPF command.

4. Press Enter. The members of the source file are listed.
5. Build the query that creates the collection by creating a source member for the query; enter:
   • New Member – SYBASE
   • Type for New Member – TXT
6. Press Enter.
7. To create the query member, enter this in the first line of the source file:

   CREATE COLLECTION SYBASE

8. Press F3. Verify that the Change/Create Member field is set to Y, and the Member field is SYBASE.
9. Press Enter to exit the editor.
   You can now work with this query.
10. Press F3 again to return to the main menu.

• Building the Query for Sybase Collection
  Use the AS/400 utility to create build query for Sybase collection.