Creating the SYBASE collection using the AS/400 SEU utility

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

Log on to the AS/400 at 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.
Start the SEU program by entering the following command:
```
STRSEU
```
Press F4. The Work With Members Using SEU window appears.
Provide the following information:
- In the Source File field, enter:
```
QQMQRYSRC
```
- In the Source Member field, enter:
```
*SELECT
```
- In the Library File field, enter:
```
QGPL
```
  If the source file does not exist, you must create it using the CRTSRCPF command.
Press Enter. The members of the source file are listed.

Build the query that creates the collection by creating a source member for the query:
- In the New Member field, enter:
```
SYBASE
```
- In the Type for New Member field, enter:
```
TXT
```
Press Enter. The Edit window appears.
Create the query member by entering the following in the first line of the source file:
```
CREATE COLLECTION SYBASE
```
Press F3. Verify that the Change/Create Member field is set to Y, and the Member field is SYBASE.
Press Enter to exit the editor. Now you can work with the query you created.
Press F3 again to exit and return to the Main menu.

Enter the following on the command line:
```
CRTQMQRY QMQRY(QGPL/SYBASE) SRCFILE(QGPL/QQMQRYSRC)
```
Press Enter. The AS/400 utility creates the query

You might receive a warning message that the source length exceeds 79 characters. Disregard this message, as it does not affect the access service
To run the query that creates the SYBASE collection, enter the following on the command line:
```
STRQMQRY QMQRY(QGPL/SYBASE)
```
Press Enter. The SYBASE collection is created.

Building the collection might take a few minutes. During this time, you will receive messages indicating the status of the operation.