Building the Query for Sybase Collection

Use the AS/400 utility to create build query for Sybase collection.

  1. From the command prompt, enter:
    CRTQMQRY QMQRY(QGPL/SYBASE) SRCFILE(QGPL/QQMQRYSRC)

    Press Enter. The AS/400 utility creates the query.

    Note: You may disregard a warning message that the source length exceeds 79 characters; it does not affect the access service.
  2. To run the query that creates the SYBASE collection, enter:
    STRQMQRY QMQRY(QGPL/SYBASE)

    Press Enter. The SYBASE collection is created.

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