Search Results

Hello,

In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data...

For the db user, max idle session timeout is set to unlimited.

I got the below points for fixing the issue(at linux server side).

Update the settings as below :
echo 600 >...

-When I execute in interactive db session, I dont get the error. The server from which shell script is invoked and the server where the vertica DB is installed are different.
- shell used is ksh;...

Hi,

I have a bash script which connects HP Vertica DB and executes few sql files in sequential manner. One sql file has commands related to one table(stage , base schema tables)and contains 7-8...