296 | 01 Sep 2008 @ 01:35 PDT | Connectivity | Reply | DLL installation | LENGTH is an ODBC function not a SQL function. The corresponding SQL function is the ANSI-standard CHARACTER_LENGTH (or Teradata extension CHARACTERS).For the ODBC driver to translate LENGTH "under... |
295 | 29 Aug 2008 @ 06:00 PDT | Database | Reply | DBC.DBQLogTbl V12 | Use FirstRespTime. The actual "last response packet sent to host" time was not being captured in earlier releases; LastRespTime was nearly aways reported as being either the same as FirstRespTime o... |
294 | 29 Aug 2008 @ 03:22 PDT | Database | Reply | How to fetch only the first character from a word using FORMAT option | SELECT SUBSTRING(LEAD_SRC FROM 1 FOR 1) FROM ITO_LEAD_F |
293 | 22 Aug 2008 @ 10:31 PDT | Database | Reply | can we create a schema under a database in teradata? | Teradata's DATABASE/USER concept can be considered similar to Oracle's SCHEMA. Any Teradata USER is also a DATABASE, but not all DATABASEs are USERs. An entire Teradata "system" (sometimes referred... |
292 | 22 Aug 2008 @ 10:15 PDT | Database | Reply | uncommited read | Use LOCKING ROW FOR ACCESS prefix in Teradata to obtain essentially the same behavior as WITH UR suffix in DB2. Or for either database, you can set your driver/connection options. |
291 | 22 Aug 2008 @ 10:12 PDT | Database | Reply | RUNSTATS simmilar in TERADATA | SQL statement - COLLECT STATISTICS - not a separate utility. |
290 | 21 Aug 2008 @ 12:04 PDT | Connectivity | Reply | Problems compiling simple UDF (plusudf). | I see this forum is stripping the header filename in "angle brackets" from the required #include directive. Depending on the path, you may be able to use double quotes. At least this way it should ... |
289 | 19 Aug 2008 @ 12:13 PDT | Connectivity | Reply | Problems compiling simple UDF (plusudf). | May not solve your problem, but that's not a valid prototype for a Teradata UDF. Needs to be something like this (for scalar function with default parameter style TD_GENERAL):#define SQL_TEXT Latin... |
288 | 15 Aug 2008 @ 05:20 PDT | Connectivity | Reply | SQL Server Integration Services (SSIS) and Timeout Errors | You need to set the TdCommand.CommandTimeout property, which applies to query execution.The TdConnection.ConnectionTimeout property only applies to the process of making the connection (logging in). |
287 | 13 Aug 2008 @ 10:41 PDT | Database | Reply | Statistics in Teradata | Teradata Documentation / Manuals http://www.info.teradata.com |
286 | 12 Aug 2008 @ 08:56 PDT | Third Party Software | Reply | ODBC connection problem - MS Query and Excel | In the Teradata ODBC driver configuration, Advanced options, try selecting "Custom Catalog Mode". |
285 | 09 Aug 2008 @ 03:39 PDT | Database | Reply | skew factor | They are complementary measures.Parallel Efficiency is the ratio (Avg/Max) which ranges from near 0 to 1; it's usually scaled to a percentage (multiplied by 100) and displayed as 0% to 100%.Skew Fa... |
284 | 01 Aug 2008 @ 11:52 PDT | Database | Reply | Using INETERVAL With CASE Statement | So add parentheses:CASE WHEN grp_prpkg_exp_dt = '9999-12-31' THEN (CAST('2007-12-31' AS DATE) - grp_prpkg_eff_dt MONTH(4)) ELSE (grp_prpkg_exp_dt - grp_prpkg_eff_dt MONTH(4)) END AS num |
283 | 01 Aug 2008 @ 11:45 PDT | Tools | Reply | Collect Statistics | Include the keyword TEMPORARY in front of the table name to collect statistics on a materialized instance of a GTT.If you "collect stats" on the base GTT definition (without TEMPORARY), it effectiv... |
282 | 31 Jul 2008 @ 11:18 PDT | Database | Reply | convert string to date format | Select cast('July 22, 2007' as date format 'M4BDD,BY4');Note that 'July 4, 2007' would NOT be valid with this format, though 'July 04, 2007' would be. Teradata does not have any format specifier th... |
281 | 29 Jul 2008 @ 11:46 PDT | Tools | Reply | COALESCE in FastLoad Script | How about using MultiLoad instead? That would support COALESCE. |
280 | 24 Jul 2008 @ 11:36 PDT | Connectivity | Reply | Trying to set up ODBC connection | Some uninstall did not work properly. Search your hard drive for multiple copies of the terasso.dll file and remove old ones manually. |
279 | 22 Jul 2008 @ 03:51 PDT | Database | Reply | Implementing Fallback.... | One other note: MODIFY ... AS FALLBACK "at the database level" only means FALLBACK will become the default for any new CREATE TABLE in that database. You would still need to individually ALTER eac... |
278 | 26 Jun 2008 @ 10:00 PDT | UDA | Reply | Date format | Teradata does not have FORMATs that permit single-digit month or day.You can use INMOD or AXSMOD to reformat the input records "on the fly" to be acceptable to Teradata.Or you can load as VARCHAR a... |
277 | 26 Jun 2008 @ 09:51 PDT | Tools | Reply | MLOAD script error. | LAYOUT describes the input file, not the table. If you use VARTEXT, all the fields must be declared VARCHAR in the layout. |
276 | 26 Jun 2008 @ 09:46 PDT | Tools | Reply | Fastload: Incorrect number of bytes returned from a File Read | .set record vartextAlso the DEFINE describes the input file, not the table. In particular, if you use VARTEXT all DEFINE fields must be declared VARCHAR. The values will be translated to internal f... |
275 | 11 Jun 2008 @ 10:44 PDT | Database | Reply | Time format of FirstRespTime (DBQLogTbl) | SQL Reference: Data Types and LiteralsYour question was actually about Output FORMAT Phrases for a TIMESTAMP field, but you might also want to refer to the section documenting the TIMESTAMP Data Ty... |
274 | 10 Jun 2008 @ 11:52 PDT | Database | Reply | Time format of FirstRespTime (DBQLogTbl) | The latter: 51 centiseconds = 510ms |
273 | 06 Jun 2008 @ 02:55 PDT | Tools | Reply | Teradata Warehouse Builder? | See the documentation for "Teradata Parallel Transporter" (current name for what was TWB). The LOAD operator uses the FastLoad protocol for initial load to empty tables, but with a different "wrapp... |
272 | 26 May 2008 @ 09:32 PDT | UDA | Reply | Mload Login Error | If password contains characters other than letters, numbers, and underscore then it must be "quoted" when put in the LOGON statement text. Quotes are not needed when responding to a prompt, or when... |