We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Turn Off Row Counts in VSQL — Vertica Forum

Turn Off Row Counts in VSQL

Jim_KnicelyJim_Knicely - Select Field - Administrator
edited January 2019 in Tips from the Team

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

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/vsql/CommandLineOptions/PAssignment--psetAssignment.htm

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/psetNAMEVALUE.htm

Have fun!

Sign In or Register to comment.