#DateForumTypeThreadPost
9616 Jun 2008 @ 02:55 PDTUDAReplyDoes V2R6 support Arabic data?Teradata Database supports 5 Server Character Sets: LATIN UNICODE GRAPHIC KANJI1 KANJISJISTeradata also supports Client Character sets (a.k.a. Session Character Set) like: UTF8 UTF16 ...
9513 Jun 2008 @ 02:09 PDTConnectivityReply.NET Provider performanceI wrote "empty staging tables". That is each thread/connection/DataTable will load into a separate empty table. For example lets assume that you want to load 1,000,000 rows. You can partition the r...
9412 Jun 2008 @ 03:33 PDTConnectivityReply.NET Provider performanceBTW, you can use TPT API but you must use C++/CLI.Another option is to partition the data into multiple DataTables; use one thread per connection per DataTable to load the data into empty staging t...
9311 Jun 2008 @ 09:22 PDTConnectivityReply.NET Provider performanceDo you set TdDataAdapter.UpdateBatchSize property? if yes, did it enhance the overall performance?
9228 May 2008 @ 04:59 PDTConnectivityReplyVS 2008 Integration.NET Data Provider for Teradata version 12.0 now supports Visual Studio 2008; download the new ZIP file from the download center. This new ZIP file has a separate Installation package for Visual St...
9128 May 2008 @ 04:26 PDTConnectivityReplyCannot get stored procedure call from C# with output parameters to workQ#1: I'm concerned that the Microsoft.Data.Odbc provider might be out of date? I'm using it because I'm updating legacy code. Is there something else I should try (willing to spend the time to upda...
9027 May 2008 @ 05:31 PDTConnectivityReplyCannot get stored procedure call from C# with output parameters to workYou must enable "Return Output Parameters as ResultSet" DSN Option for that code to work. Following version returns an output parameter: string myConnection = "DSN=x;UID=y;PWD=z"; ...
8927 Mar 2008 @ 02:52 PDTUDAReplyDecimal datatype in Teradata V12Decimal(18) takes up 8 bytes while Decimal(19) through Decimal(38) takes up 16 bytes.See SQL Reference: Data Types and Literals.Is the source data/field 16 bytes long?
8826 Mar 2008 @ 10:51 PDTDatabaseReplyCan I insert/delete data on Teradara database installed on x86 from AMD64 machine?VSTS? is this Visual Studio Team System? Are you simply using Visual Studio IDE and Server Explorer?If not, is VSTS a 32-bit or 64-bit process? OLE DB Provider for Teradata is 32-bit; it cannot loa...
8726 Mar 2008 @ 02:52 PDTConnectivityReplyMTDP: EM_TIMEEXCEEDED(245): Timeout from DBCHWL.I cannot answer your question about CPU utilization without additional information. However Teradata Database was designed from ground up as a data warehouse; SQL Server was designed as an OLTP. T...
8625 Mar 2008 @ 02:11 PDTDatabaseReplySP: Timestamp as Host variableSorry for the typos; as Dieter mentioned already there is one too many TIMESTAMP keyword.
8525 Mar 2008 @ 01:13 PDTConnectivityReplyMTDP: EM_TIMEEXCEEDED(245): Timeout from DBCHWL.I do not think it is related to Connection Pooling. Connection (DbConnection) has a separate Timeout value. In another word, the process of "opening" a connection is separate and distinct from the ...
8424 Mar 2008 @ 03:02 PDTConnectivityReplyMTDP: EM_TIMEEXCEEDED(245): Timeout from DBCHWL.Provider does not receive a response from Teradata Database within the specified TIMEOUT period.DbCommand (TdCommnad) has a default timeout: [url=http://msdn2.microsoft.com/en-us/library/system.dat...
8321 Mar 2008 @ 01:33 PDTDatabaseReplyExcel Querytable ODBC Connection IssueDBCName is the name of your Teradata system. For example if your system name is TestBox and the IP address for COP1 is 101.100.99.98 then the following connection strings are all valid. Driver=...
8221 Mar 2008 @ 01:22 PDTConnectivityReplyEquivalent to Oracle's New_Time()I am not an expert in Oracle function. I assume you are looking for conversion from one Time Zone to another. Teradata support "AT TIME ZONE"; see "AT TIME ZONE" in "SQL Reference: Functions and Op...
8120 Mar 2008 @ 12:59 PDTUDAReplyHow to get Output as a pipe delimited file?if you are using BTEQ .SET SEPARATOR 'string' BTEQ manual has an example for .set separator "|".
8020 Mar 2008 @ 12:52 PDTAnalyticsReplyRetrieving varbyte column into a fileYou might want to investigate DATA export mode.The syntax is something like: .EXPORT DATA FILE = filenameIf I recall correcting, the resulting row in the export file starts with 2 byte row length...
7919 Mar 2008 @ 03:30 PDTDatabaseReplyExcel Querytable ODBC Connection IssueDriver={Teradata};DBCName=myDBCName;UID=X;PWD=Y;Database=foo;I assume ODBC at the very beginning is used internally by Excel and not passed to Driver. Therefore add ODBC; to the very beginning of t...
7818 Mar 2008 @ 02:50 PDTDatabaseReplySP: Timestamp as Host variableThere is an extra space in my previous post; It should be call dbc.sysexecsql('INSERT INTO logarchive.TB_DBQLObjTbl_' || table_year || ' SELECT * FROM DBC.DBQLObjTbl WHERE CollectTimeStamp BETWEEN ...
7718 Mar 2008 @ 02:45 PDTDatabaseReplySP: Timestamp as Host variableDid you try this?call dbc.sysexecsql('INSERT INTO logarchive.TB_DBQLObjTbl_' || table_year || ' SELECT * FROM DBC.DBQLObjTbl WHERE CollectTimeStamp BETWEEN TIMESTAMP TIMETSTAMP'' ' || stamp1 || '''...
7612 Mar 2008 @ 04:01 PDTDatabaseReplyHow to round a timestamp ?Select CAST(CURRENT_TIMESTAMP as TIMESTAMP(6)) AS A_TIMESTAMP, Extract(second FROM A_TIMESTAMP) as SECONDS, (CASE WHEN (SECONDS MOD CAST(SECONDS as Integer)) > 0.5 THEN INTERVA...
7510 Mar 2008 @ 04:14 PDTDatabaseReplyOLE DB fast load/bulk insertOLE DB Provider for Teradata does not have BULK INSERT.It does support Parameter Array / Set. That is it can send one INSERT statement with multiple rows of Data. This should improve the overall pe...
7405 Mar 2008 @ 02:19 PSTToolsReplytimestamp related problemhttp://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=TDBS12.0&sbrn=7&nm=Teradata+Database+12.0Look for "Timestamp With Time Zone" in "SQL Refe...
7331 Jan 2008 @ 01:48 PSTConnectivityReplyBad characters when querying on UNIX enviornmentCan you post details like ODBC driver version ODBC DSN settings including Session Character Set and AppCodePage Teradata database version Target column Server Character SetDid you try I IANAAp...
7228 Jan 2008 @ 03:10 PSTConnectivityReplyBad characters when querying on UNIX enviornmentIs OracleBI a UNICODE application?If yes: 1- Make sure the Session Character Set is UTF8 or UTF16 (e.g. Connection String should be like UID=X;PWD=Y;CharacterSet=UTF16); 2- Make sure th...

Pages