How to use the Rocket U2 relay

Rocket U2 is an application platform that is used to interact with a Rocket database. This can be done by creating a relay.

NB: Rocket U2 Relays will allow you to interact with the Rocket database using Rocket TCL commands. ODBC Relays will allow you to interact with the Rocket databases using SQL.

Illustrated below is an image of a Rocket U2 source step. Select the existing relay from the dropdown list. Type the command you require in the Command field. In this example, it is reading a list of Zip codes in the database using a TCL command, and it will provide a sample of 10 zip codes.

The page below is an example of the ODBC source step. Select the existing relay from the dropdown list. Type the command you require in the Command field. In this example, it is reading a list of Zip codes in the database using SQL.

The link below assists with TCL Commands:

TCL Commands

Additional information:

Relays

Creating Relays