#DateForumTypeThreadPost
34608 Jan 2009 @ 09:50 PSTConnectivityReplyConnecting To Teradata using ODBC in .NETFor a long time we have been able to set the options when invoking the ODBC API directly, but in the past there sometimes were issues with getting the intermediary Microsoft "Provider for ODBC" lay...
34508 Jan 2009 @ 08:48 PSTConnectivityReplyConnecting To Teradata using ODBC in .NETWhile it is possible to use the Teradata ODBC driver for a "DSN-less" connection, you can't control all the driver parameters via the ConnectionString. (See RunInQuietMode, for example.)Why not use...
34407 Jan 2009 @ 09:34 PSTDatabaseReplyRemove characters after '-' in a stringSUBSTRING(myField FROM 1 FOR POSITION('-' IN myField)-1)
34306 Jan 2009 @ 08:49 PSTToolsReplyHow to convert Ordinal (Julian) Date to Calendar DateOne possibility is to add the ordinal number of days to a base date, then format the results appropriately:select cast(cast(date'2000-12-31' + 032 as format 'mm/dd') as char(5));
34206 Jan 2009 @ 10:01 PSTDatabaseReplyLeft-over spool table foundOne other thought: A database restart removes ALL spool files - so there is a chance that forcing a restart could make encountering "left-over" spool less frequent. It won't actually fix anything,...
34106 Jan 2009 @ 08:51 PSTDatabaseReplyLeft-over spool table foundLeft-over spool is always a bug. And the problem is seldom (never?) with the query that gets the 2667 error; as the name implies, some prior transaction did not properly clean up its spool usage. S...
34005 Jan 2009 @ 02:11 PSTDatabaseReplyLogin using BTEQYou can't. You have to fix your hostname-to-IP resolution (hosts file, DNS, etc.) so that TDPIDcop1, TDPIDcop2, ..., TDPIDcop(N) all point to IP addresses on the same system, and TDPIDcop(N+1) is n...
33904 Jan 2009 @ 02:41 PSTDatabaseReplyLOW CONFIDENCE HIGH CONFIDENCE OF QUERIESSee SQL Reference: Statement and Transaction Processing for a chapter on "Interpreting the output of EXPLAIN", including a section on "EXPLAIN confidence levels".
33803 Jan 2009 @ 12:16 PSTDatabaseReplyLogin using BTEQA likely explanation: The same TDPID, but with more COPs, is defined to point to a different Teradata system (in your hosts file or nameserver/DNS). That's easy enough to check: "ping TDPIDcop2" (o...
33730 Dec 2008 @ 12:48 PSTDatabaseReplyTPT errorYou have to "escape" the embedded quotes by doubling them. For example:SelectStmt VARCHAR 'SELECT ......AND ATTRIB.ENTITY_DB_STATUS_ON_SNAPSHOT = ''C''...;'
33628 Dec 2008 @ 12:41 PSTDatabaseReplyReg Syntax error 3706Those are ODBC escape sequences for date constants. The DBMS does not recognize that syntax, but if you are using a tool that requires its use, the ODBC driver can parse the query and translate it ...
33511 Dec 2008 @ 02:03 PSTDatabaseReplyHow to confirm Teradata VersionDBCInfo reports both the PDE "VERSION" and DBMS "RELEASE". Prior to TD12, the VERSION string has a "V2R." prefix while the RELEASE string does not. The general format of the release number is the s...
33409 Dec 2008 @ 10:30 PSTToolsReplybteq runfile quit problemIf BTEQ switches back from the .RUN file to the primary input, you will get the "warning" message. There is no way to avoid that. But note that the warning does NOT change ERRORLEVEL value, nor doe...
33309 Dec 2008 @ 02:50 PSTToolsReplybteq runfile quit problemERRORLEVEL is the "severity" assigned to the Teradata Database ERRORCODE returned for the most recent SQL request. A "client-side" BTEQ warning or error doesn't change the ERRORLEVEL, though it may...
33208 Dec 2008 @ 11:35 PSTToolsReplySecuring passwords in Fastload, Multiload, etc in UNIXIn ascending level of difficulty:You can put the LOGON statement in a separate file and use .RUN command in your scripts to invoke it.You can implement a CLI Logon User Exit (C program) to intercep...
33106 Dec 2008 @ 05:49 PSTAnalyticsReplyCastLooks like a similar issue. In most cases (e.g. ODBC / SQL Assistant) the client is responsible for formatting the output. If you want the DBMS to do it, CAST to [VAR]CHAR.Any of the following shou...
33002 Dec 2008 @ 06:47 PSTAnalyticsReplyCastOr more generally:specify the formatting to be used for conversions to/from external character form, then tell Teradata to do the conversion.SELECT CAST(CAST(dateCol AS FORMAT 'MM/YYYY') AS CHAR(7)...
32927 Nov 2008 @ 11:06 PSTDatabaseReplySelecting multiple rows using Stored ProcTo return a result set, you declare the cursor WITH RETURN, OPEN the cursor, and leave it open when the procedure exits. You don't CLOSE it, and often won't FETCH from it either. And as mentioned, ...
32826 Nov 2008 @ 11:03 PSTDatabaseReplyHow to sum records where a particular value changes within a grouping?You renamed the column, so change the PRIMARY INDEX claus for the volatile table to say SorceClaimID.
32720 Nov 2008 @ 11:49 PSTToolsReplyHow to test the odbc connectivity on SolarisCheck the README file. There is a sample application named "adhoc" included with the ODBC install.
32619 Nov 2008 @ 08:39 PSTDatabaseReplyError with Case statement - expected something between the ‘end’ keyword and “)”Your first example should be OK (assuming you also balance the outer parentheses):(CASE WHEN c.c_pym_det = 'FAC' THEN 'Assisted Living - NH'WHEN c.c_pym_det = 'PHC' THEN 'Assisted Living - HC'else ...
32518 Nov 2008 @ 01:32 PSTDatabaseReplyError with Case statement - expected something between the ‘end’ keyword and “)”The error message could be better... Your outer parentheses are not balanced, plus you have invalid syntax for the inner CASE:... case pyd.c_pym_det when c.c_pym_det = 'FAC' then ...You can either ...
32417 Nov 2008 @ 03:07 PSTTrainingReplyVersion 12 certificationEarlier this year, Teradata had indicated that the next version of exams would be based on TD13.0 (and that was reflected on the web page). But recently they decided to do certification at TD12.0 a...
32316 Nov 2008 @ 12:25 PSTDatabaseReplyTeradataIn the context of this question about EXPLAIN wording, "residual conditions" would be any additional filtering (beyond the join terms, or index access criteria, etc.) that will be applied "on the f...
32215 Nov 2008 @ 10:22 PSTToolsReplyRelease Lock - LOAD Operator - TPTUse the same LOAD definition but change the data producer (e.g. Data Connector operator) to send an empty file to the LOAD operator.

Pages