I have created a connection and I am able to connect to the database using that. But when I select records from the table it is not coming up.
[dbadmin@Vertica sql]$ cat /etc/odbc.ini
[ODBC Data Sources]
VerticaDSN = "sfpdb database"
[VerticaDSN]
Description = SFP Database
Driver = /opt/vertica/lib64/libverticaodbc.so
Database = sfpdb
Servername = 16.181.233.133
UserName = dbadmin
Password = sfpdb
Port = 5433
[dbadmin@Vertica ~]$ isql -v VerticaDSN
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from t;
+---------------------+|
a |
+---------------------+|
|1 |
|
|
+----------------------+
SQLRowCount returns 3
3 rows fetched
Not sure whey I am unable to see all the three rows.
RPM: vertica-6.1.3-0
unixODBC-2.2.11-7.1
RHEL 5.5
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.