VSQL command to return only the output

[arun2986]

Hi All,
I have a requirement where i need to connect vertica from Perl and store the result in a variable.
For eg.
$var=vsql -c "select count(*) from tableA";

Whenever i try to fetch the value , i get the whole result as

count
-------
7
(1 row)

This whole result is stored in the variable. Iam expecting the value 7 alone to be stored in the variable. Is there an inbuilt functionality which can do it , similar to db2 -x "select count(*) from tableA" ?

[JimKnicely]

Hi arun2986 ,

Welcome to the forums!

Please check out the post:

viewtopic.php?f=18&t=236

This should work for you:

Code: Select all

$var=vsql -At -c "select count(*) from tableA";

[arun2986]

Thanks a lot Jim. That helps.