I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)

Hi,
I'm new to TeraData and need to call a Macro from C# using the .Net Provider.
I wasn't able to find any sample code, and not sure what the correct way to do this.
I don't want toe send "exec macroName(param1)" from my code, I would like to have something similar to the way i call procedures.

Does anyone have experiece using .NET Provider with Mono CLR on Linux? I cannot find any information in the help file or Teradata site. 

Hello folks,

                I am new to Teradata , and was hoping to connect to the Teradata DB using the .net provider.

However I am unable to connect. I am getting a invalid connection string error.

I was wondering if you have to follow certain steps to connect using the .net provider ?

I am trying to use the .Net Provider with a Web Application however at runtime I keep getting the following error:

exePath must be specified when not running inside a stand alone exe.

[ArgumentException: exePath must be specified when not running inside a stand alone exe.]
System.Configuration.ConfigurationManager.OpenExeConfigurationImpl(ConfigurationFileMap fileMap, Boolean isMachine, ConfigurationUserLevel userLevel, String exePath) +179166
Teradata.Client.Provider.TeraAppConfig..ctor() +58
Teradata.Client.Provider.TeraAppConfig..cctor() +21

Hi,

I am using TD .NET provider 12.x and have stored procedures. All my SPs have IN & OUT parameters. In my understanding, TD has a strange way to returning the OUT params as a dataset & it works fine. When I have SP that delete records from a table, and also returns OUT params.

When I execute this Sp from .NET, I get a empty dataset (tables = 0). On checking the data, it actually deletes the data correctly. But how can I know that records are deleted? I don't want to unnecessarily check the data for delete confirmation.

any help is appreciated. Thanks.

SP Code: