346 | 08 Jan 2009 @ 09:50 PST | Connectivity | Reply | Connecting To Teradata using ODBC in .NET | For 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... |
345 | 08 Jan 2009 @ 08:48 PST | Connectivity | Reply | Connecting To Teradata using ODBC in .NET | While 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... |
344 | 07 Jan 2009 @ 09:34 PST | Database | Reply | Remove characters after '-' in a string | SUBSTRING(myField FROM 1 FOR POSITION('-' IN myField)-1) |
343 | 06 Jan 2009 @ 08:49 PST | Tools | Reply | How to convert Ordinal (Julian) Date to Calendar Date | One 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)); |
342 | 06 Jan 2009 @ 10:01 PST | Database | Reply | Left-over spool table found | One 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,... |
341 | 06 Jan 2009 @ 08:51 PST | Database | Reply | Left-over spool table found | Left-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... |
340 | 05 Jan 2009 @ 02:11 PST | Database | Reply | Login using BTEQ | You 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... |
339 | 04 Jan 2009 @ 02:41 PST | Database | Reply | LOW CONFIDENCE HIGH CONFIDENCE OF QUERIES | See SQL Reference: Statement and Transaction Processing for a chapter on "Interpreting the output of EXPLAIN", including a section on "EXPLAIN confidence levels". |
338 | 03 Jan 2009 @ 12:16 PST | Database | Reply | Login using BTEQ | A 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... |
337 | 30 Dec 2008 @ 12:48 PST | Database | Reply | TPT error | You have to "escape" the embedded quotes by doubling them. For example:SelectStmt VARCHAR 'SELECT ......AND ATTRIB.ENTITY_DB_STATUS_ON_SNAPSHOT = ''C''...;' |
336 | 28 Dec 2008 @ 12:41 PST | Database | Reply | Reg Syntax error 3706 | Those 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 ... |
335 | 11 Dec 2008 @ 02:03 PST | Database | Reply | How to confirm Teradata Version | DBCInfo 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... |
334 | 09 Dec 2008 @ 10:30 PST | Tools | Reply | bteq runfile quit problem | If 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... |
333 | 09 Dec 2008 @ 02:50 PST | Tools | Reply | bteq runfile quit problem | ERRORLEVEL 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... |
332 | 08 Dec 2008 @ 11:35 PST | Tools | Reply | Securing passwords in Fastload, Multiload, etc in UNIX | In 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... |
331 | 06 Dec 2008 @ 05:49 PST | Analytics | Reply | Cast | Looks 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... |
330 | 02 Dec 2008 @ 06:47 PST | Analytics | Reply | Cast | Or 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)... |
329 | 27 Nov 2008 @ 11:06 PST | Database | Reply | Selecting multiple rows using Stored Proc | To 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, ... |
328 | 26 Nov 2008 @ 11:03 PST | Database | Reply | How 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. |
327 | 20 Nov 2008 @ 11:49 PST | Tools | Reply | How to test the odbc connectivity on Solaris | Check the README file. There is a sample application named "adhoc" included with the ODBC install. |
326 | 19 Nov 2008 @ 08:39 PST | Database | Reply | Error 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 ... |
325 | 18 Nov 2008 @ 01:32 PST | Database | Reply | Error 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 ... |
324 | 17 Nov 2008 @ 03:07 PST | Training | Reply | Version 12 certification | Earlier 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... |
323 | 16 Nov 2008 @ 12:25 PST | Database | Reply | Teradata | In 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... |
322 | 15 Nov 2008 @ 10:22 PST | Tools | Reply | Release Lock - LOAD Operator - TPT | Use the same LOAD definition but change the data producer (e.g. Data Connector operator) to send an empty file to the LOAD operator. |