Wind River Spas TORNADO Especificações descarregar pdf (Página 56)

5-16 20751-12 Rev.5

Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide

ODBC Connectivity Validation for UNIX/Linux

To validate that you can use ODBC to connect to an Netezza appliance data source, use the

interactive SQL query program called isql. The isql program is installed on your system

when you install the unixODBC driver manager (See “unixODBC Driver Manager Installa-

tion” on page 4-4.) You can use isql to run SQL queries against both the system data

source and any user data sources you configure.

Note: If you are using a driver manager other than the unixODBC driver manager, consult

your Netezza system administrator to see if there is an SQL query program installed on your

client system that you can use instead of isql to validate ODBC connectivity and query

Netezza appliance data sources.

The following example uses the DataDirect driver manager, where you run the example

program in the example directory, specifying the NZSQL DSN, login, and password, dis-

playing output as in the following:

./example

DataDirect Technologies, Inc. ODBC Example Application.

Enter the data source name : NZSQL

Enter the user name : admin

Enter the password : password

Enter SQL statements (Press ENTER to QUIT)

SQL>

Once connected, you can run the same queries as used in the following examples. The sys-

tem should return the same results.

ODBC Connectivity Validation Steps for UNIX/Linux

The following are the steps to validate ODBC connectivity to the Netezza appliance data

sources configured in the previous section.

1. Change directories.

2. Connect to NZSQL system data source.

3. Query system database.

4. Display query results.

5. Connect to Test User data source.

6. Query user database.

7. Display query results.

ODBC Connectivity Validation Procedure for UNIX/Linux

The following sections describe each of the above steps in the connectivity validation

procedure.

1. Change to the directory containing the isql interactive SQL application by entering

the following command:

cd /usr/local/unixODBC/bin

2. Start the isql interactive SQL application, and connect to the NZSQL system data

source by entering the following command:

1 2 ... 51 52 53 54 55 56 57 58 59 60 61 ... 77 78

Sem comentários

Wind River Spas TORNADO Especificações Página 56