Search found 6 matches

by sushanth
Mon Oct 21, 2013 10:13 am
Forum: Vertica External Procedures
Topic: Creating external procedures
Replies: 1
Views: 2131

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...
by sushanth
Mon Oct 07, 2013 12:58 pm
Forum: Vertica Data Load
Topic: Loading data hangs up
Replies: 3
Views: 1744

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...
by sushanth
Mon Oct 07, 2013 10:52 am
Forum: Vertica Data Load
Topic: Loading data hangs up
Replies: 3
Views: 1744

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 ...
by sushanth
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: 1361

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...
by sushanth
Wed Sep 25, 2013 2:53 pm
Forum: ADO.NET
Topic: ADO.Net transaction not working
Replies: 3
Views: 6796

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 ...
by sushanth
Wed Sep 25, 2013 1:49 pm
Forum: ADO.NET
Topic: ADO.Net transaction not working
Replies: 3
Views: 6796

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...

Go to advanced search