Search found 6 matches
- Mon Oct 21, 2013 10:13 am
- Forum: Vertica External Procedures
- Topic: Creating external procedures
- Replies: 1
- Views: 15803
Creating external procedures
Hi All, I am new to vertica and got to know that there is no support for stored procedures in vertica and instead we can create external procedures and add it to vertica. Please provide me a step by step instructions for how to create an external script and add it to vertica. My requirement is to se...
- Mon Oct 07, 2013 12:58 pm
- Forum: Vertica Data Load
- Topic: Loading data hangs up
- Replies: 3
- Views: 10646
Re: Loading data hangs up
Dear nnani, thanks for the reply. In my copy command i have given reference to the exception file and i have checked that file and didnt find any error. what's the CopyErrorLogs you are mentioning? is this the same exception file which iam using along with the copy command? How can i get the transac...
- Mon Oct 07, 2013 10:52 am
- Forum: Vertica Data Load
- Topic: Loading data hangs up
- Replies: 3
- Views: 10646
Loading data hangs up
Dear all, I am trying to load data to vertica using copy local. I have created a console application in .net using ado.net for vertica and creating the text file for the records to be copied to vertica for various date ranges. After creating the text file iam loading the data using COPY LOCAL. This ...
- Mon Sep 30, 2013 12:29 pm
- Forum: ADO.NET
- Topic: How to insert a byte[] into a binary field in vertica
- Replies: 1
- Views: 16961
How to insert a byte[] into a binary field in vertica
My requirement is to export data in sqlserver to vertica. Iam able to export the data using COPY from LOCAL command. Steps which i followed is as follows 1. Get the data from table in .net datareader object 2. loop through the reader object and will create a csv file 3. export the csv file using COP...
- Wed Sep 25, 2013 2:53 pm
- Forum: ADO.NET
- Topic: ADO.Net transaction not working
- Replies: 3
- Views: 54544
Re: ADO.Net transaction not working
Hi i know objCommand.CommandText ="Insert into transtest value (" + 1 + ","+"sumesh)"; is a wrong insert statement , but i have deliberately given this in order to check whether the transaction is rolled back. but now after reading the documentation i came to know that "TRUNCATE" is auto commit and ...
- Wed Sep 25, 2013 1:49 pm
- Forum: ADO.NET
- Topic: ADO.Net transaction not working
- Replies: 3
- Views: 54544
ADO.Net transaction not working
i have a table called transtest which contain only two fields called id and name i was trying to test transaction in vertica through ado.net. initially i have filled the table with 2 records like id name ----- ----------- 1 sushanth 2 jayesh ---------------------------------------------- my test has...