20751-12 Rev.5 5-17
Configuring ODBC for UNIX/Linux
isql -v NZSQL
If your connection is successful, you will see a response similar to the following:
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
+---------------------------------------+
3. The system database in the NZSQL data source contains a table named _t_dslice.
Enter the following command to query the _t_dslice table:
select * from _t_dslice
4. If your ODBC driver is correctly installed, and your system data source is correctly con-
figured, the isql program displays the contents of the _t_dslice table from the
system database in the NZSQL data source. You will see a response similar to the
following:
+------------+------------+------------+------------+
| ds_id | ds_pridskid| ds_priptid | ds_mirdskid|
+------------+------------+------------+------------+
| 1 | 1002 | 0 | |
+------------+------------+------------+------------+
5. Enter the quit command to end the connection to the NZSQL system data source and
exit the isql program. Then restart isql and connect to the Test_User user data
source by entering the following command:
isql -v Test_User
If your connection is successful, you will again see a response similar to the following:
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
+---------------------------------------+
6. The example assumes the system database in the Test_User data source contains a
table named a_inventory. Enter the following command to query the a_
inventory table:
select * from a_inventory
7. If the ODBC driver is correctly installed, and the user data source is correctly config-
ured, the isql program displays the contents of the a_inventory table from the
system database in the Test_User data source:
+------------+----------+------------+
| part_no | part_name| on_hand |
+------------+----------+------------+
| 181 | Wheel | 449 |
| 124 | Bolt | 900 |
| 105 | Gear | 0 |
| 134 | Nut | 743 |
+------------+----------+------------+
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji