The user ID for creating the SYBASE collection must have a valid CCSID for your language installation.
To create the SYBASE collection through the AS/400
SEU utility
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.
To build the query that creates the SYBASE collection
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.
