Unable to See rows using isql using ODBC connection for Vertica

Siddarth

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

Siddarth

This is resolved now.