Progress DataDirect ships an application, named example, that is installed in the /samples/example subdirectory of the product installation directory. After you have configured your environment and data source, you can use the example application to test passing SQL statements.

Before you can begin testing, you will need to compile the application using the make files installed in the /example directory. You can then run the application by entering example from the Terminal and following the prompts to enter your data source name, user name, and password.

If successful, a SQL> prompt appears and you can type in SQL statements, such as SELECT * FROM table_name. If example is unable to connect to the database, an appropriate error message appears.

Refer to the example.txt file in the example subdirectory for an explanation of how to build and use this application.