Search found 5 matches

by usao
Mon Jan 22, 2018 4:13 pm
Forum: New to Vertica
Topic: Run VSQL under CygWin?
Replies: 6
Views: 29195

Re: Run VSQL under CygWin?

Ok, I replaced the chop with chcp, and I was able to run thta batch file from Windows command prompt, but not from Cygwin.
In either case, when I run:
$ cmd /c "C:\Program Files\Vertica Systems\VSQL64\vsql.exe" -h 10.0.3.51 -U dbadmin -w *****
from either Windows CMD or from Cygwin, it just hangs.
by usao
Thu Jan 18, 2018 8:20 pm
Forum: New to Vertica
Topic: Run VSQL under CygWin?
Replies: 6
Views: 29195

Re: Run VSQL under CygWin?

I tried to create the cygwin1.bat file (which did not previously exist).
When it tries to run the "chop" command, it sais that it doesn't exist.
Image
by usao
Wed Jun 07, 2017 9:55 pm
Forum: New to Vertica
Topic: Run VSQL under CygWin?
Replies: 6
Views: 29195

Run VSQL under CygWin?

Im looking for a way to run VSQL (Windows client) under CygWin.
So far, not much success.
It hangs when asking for the password.
I saw other posts about a cygwin.bat file, but I cannot find that on my system.
BASH_VERSION='4.4.5(1)-release'
by usao
Mon Jun 05, 2017 2:56 pm
Forum: New to Vertica
Topic: identity columns
Replies: 1
Views: 16454

identity columns

Ive been experimenting with the identity settings and had some questions. I have a table with 1.5 billion records in IQ that I need to move to Vertica. It makes use of an identity column. In my testing so-far, when I specify "identity(1,1,1)" I get the correct identity values migrated from IQ to Ver...
by usao
Tue May 23, 2017 5:44 pm
Forum: New to Vertica
Topic: Changing the value of an IDENTITY column?
Replies: 1
Views: 20462

Changing the value of an IDENTITY column?

I am working to transfer data from a SAP IQ database to a Vertica database. The DDL contains a number of IDENTITY columns, and I need to preserve the data from the IQ server when it's pulled into Vertica. The reason for this is to avoid having to re-key all the data in the child tables which depend ...

Go to advanced search