#DateForumTypeThreadPost
94619 Mar 2016 @ 10:29 PDTConnectivityReplyUserID/Password failure when attempting a connectionTdException.ErrorCode is defined to be a Microsoft-compatible HRESULT. TdException returns an Errors collection of TdError instances (because in some cases there can be more than one error, e....
94519 Mar 2016 @ 10:06 PDTConnectivityReplyUnable to connect to Teradata from Qlikview Management ConsoleOr a better approach: don't use ODBC. Install the Teradata OLEDB Provider and use Provider=TDOLEDB.
94419 Mar 2016 @ 10:03 PDTToolsReplyTPT load failure - Please suggestDouble-check your SELECT statement syntax, to be sure it is valid for DB2.   Note that Teradata does not support use of the IBM driver with the ODBC operator (though it may work). Only ...
94319 Mar 2016 @ 09:56 PDTToolsReplyTdload failing with TPT02638: Error: Conflicting data lengthYou should be able to override this via CLIv2 which TPT calls. Specify max_decimal_returned=38 in a clispb.dat file and specify the path in which this file can be found using COPLIB envi...
94218 Mar 2016 @ 03:34 PDTDatabaseReplygetting error [5531: HY000] with a simple store procSo what does the CALL statement look like?
94118 Mar 2016 @ 03:22 PDTConnectivityReplyUnable to connect to Teradata from Qlikview Management ConsoleLooks like QlikView's ODBC CONNECT ... expects a predefined Data Source Name (DSN). Either use ODBC Control Panel to create a DSN or try OLEDB CONNECT with Provider=MSDASQL,Driver={Terada...
94016 Mar 2016 @ 01:26 PDTConnectivityReplyUnable to connect to Teradata from Qlikview Management ConsoleAn ODBC driver is not a "provider". If you want to connect via ODBC without a predefined DSN, specify Driver={Teradata} instead of Provider=Teradata.  
93916 Mar 2016 @ 01:04 PDTDatabaseReplyMerge - Without insert when not matched?The locations (source) table apparently has multiple rows with the same combination of Latitude/Longitude values. The database can't determine which one should be used to update ...
93815 Mar 2016 @ 11:52 PDTDatabaseReplyFEXP or MLOAD are converting an INTEGER field in a negative BIGINTDoes MLOAD define the input record correctly? What record format are you using? Are both FEXP and MLOAD running on the same client, or did you move the file to a different hardware / OS platf...
93715 Mar 2016 @ 11:39 PDTThird Party SoftwareReplyArchiving Teradata tablesNot an answer to your question, but I am curious what you mean when you say OPTIM Data Growth "is unable to handle it".
93615 Mar 2016 @ 11:27 PDTDatabaseReplyREVOKE user rights, inherited from "Public"No. Teradata does not allow a specific REVOKE to override a more general GRANT for SQL access rights. (REVOKE removes the row that GRANT inserts).
93511 Mar 2016 @ 12:19 PSTDatabaseReplyTPT load in informatica giving CLI ErrorThose look like ulimit settings (and I see no issues with those). COPERR is an environment variable (typically set to /opt/teradata/client/vv.vv/lib64) If the problem was exceeding a databas...
93411 Mar 2016 @ 11:28 PSTConnectivityReplyODBC.INI configuration with LDAP Authentication MechanismDoes the password contain special characters? Sometimes that can be a problem with ODBC. What patch level of 15.00?
93311 Mar 2016 @ 11:07 PSTDatabaseReplyBLOCK SIZE INCRASEALTER TABLE ... DATABLOCKSIZE ... IMMEDIATE
93211 Mar 2016 @ 11:03 PSTDatabaseReplyFASTLOAD WITH FIXED WIDTH FILESPlease start a new thread for a new question.   With UNFORMATTED you need to declare any end-of-record termination as a field in your DEFINE (which you would not include in the INSERT)....
93110 Mar 2016 @ 02:38 PSTToolsReplyTeradata ODBC Driver For Linux - Urgent Help RequestedThe message indicates either username or password was not supplied. Are you typing the password when prompted by the "adhoc" program? The DSN goes in the ODBCINI file not ODBCINST. &nbs...
93010 Mar 2016 @ 02:19 PSTDatabaseReplyTPT load in informatica giving CLI ErrorCLI 207 means that the client OS told CLIv2 that the TCP/IP connection request failed. If this is a Unix / Linux server, be sure you have the environment variable THREADONOFF=1 It also ...
92909 Mar 2016 @ 01:14 PSTGeneralReplyExporting to an excelTeradata supports connections directly from Windows and Unix / Linux clients; Excel can use the Teradata ODBC driver as a data source.
92808 Mar 2016 @ 09:55 PSTGeneralReplyExporting to an excelThe file exported from TD is not in scientific notation. This reformatting when reading delimited text input is an Excel "feature". The only way I know of to avoid the reformatting i...
92707 Mar 2016 @ 02:51 PSTDatabaseReplyExpensive self joinSELECT REVENUE.ACC_ID, CALENDAR.WEEK_ID, SUM(CASE WHEN ACCOUNT.ACCOUNT_CAT='NEW' THEN REVENUE.REVENUE END) AS REVENUE_NEW, SUM(CASE WHEN ACCOUNT.ACCOUNT_CAT='OLD' THEN REVENUE.REV...
92607 Mar 2016 @ 02:48 PSTDatabaseReplyData type does not match a Defined Type name errorThe DATABASE statment provides a default qualifier for unqualified object names (such as the view names in your example); it's not directly related to using a function. This is true for all rel...
92504 Mar 2016 @ 08:23 PSTDatabaseReplyData type does not match a Defined Type name errorTry pasting the SQL into Notepad, then copy the "plain text" version and paste it back into SQL Assistant.
92404 Mar 2016 @ 08:18 PSTDatabaseReplyprogram to retrieve datbase table namesDBFCON returns a status parcel. Did you close the Connect request before the DBFIRQ? Have you checked DBQL to verify that the statement was sent to the database and executed?   On Unix / Li...
92303 Mar 2016 @ 11:56 PSTDatabaseReplySessions used by load utiltiesNot by looking at DBQLogTbl / QryLogV alone (even in later releases). In TD15.0 and later you can optionally collect that information in DBQLUtilityTbl / QryLogUtilityV. In prior releases...
92203 Mar 2016 @ 10:36 PSTDatabaseReplyprogram to retrieve datbase table namesSo you are using CLIv2 in a C/C++ application? Under the cliv2 install directory is a clisamp directory with source for a sample program. After the DBFIRQ (Initiate Request) call with a data-retur...

Pages