Turn Off Row Counts in VSQL
Jim_Knicely
- Select Field - Administrator
The SET NOCOUNT command in SQL Server will stop the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.
You can accomplish the same thing in Vertica by shutting off the footer.
Example:
[dbadmin@s18384357 ~]$ vsql -c "SELECT * FROM dual;" dummy ------- X (1 row) [dbadmin@s18384357 ~]$ vsql -P footer=off -c "SELECT * FROM dual;" dummy ------- X
Have fun!
0