#DateForumTypeThreadPost
29601 Sep 2008 @ 01:35 PDTConnectivityReplyDLL installationLENGTH 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...
29529 Aug 2008 @ 06:00 PDTDatabaseReplyDBC.DBQLogTbl V12Use 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...
29429 Aug 2008 @ 03:22 PDTDatabaseReplyHow to fetch only the first character from a word using FORMAT optionSELECT SUBSTRING(LEAD_SRC FROM 1 FOR 1) FROM ITO_LEAD_F
29322 Aug 2008 @ 10:31 PDTDatabaseReplycan 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...
29222 Aug 2008 @ 10:15 PDTDatabaseReplyuncommited readUse 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.
29122 Aug 2008 @ 10:12 PDTDatabaseReplyRUNSTATS simmilar in TERADATASQL statement - COLLECT STATISTICS - not a separate utility.
29021 Aug 2008 @ 12:04 PDTConnectivityReplyProblems 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 ...
28919 Aug 2008 @ 12:13 PDTConnectivityReplyProblems 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...
28815 Aug 2008 @ 05:20 PDTConnectivityReplySQL Server Integration Services (SSIS) and Timeout ErrorsYou 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).
28713 Aug 2008 @ 10:41 PDTDatabaseReplyStatistics in TeradataTeradata Documentation / Manuals http://www.info.teradata.com
28612 Aug 2008 @ 08:56 PDTThird Party SoftwareReplyODBC connection problem - MS Query and ExcelIn the Teradata ODBC driver configuration, Advanced options, try selecting "Custom Catalog Mode".
28509 Aug 2008 @ 03:39 PDTDatabaseReplyskew factorThey 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...
28401 Aug 2008 @ 11:52 PDTDatabaseReplyUsing INETERVAL With CASE StatementSo 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
28301 Aug 2008 @ 11:45 PDTToolsReplyCollect StatisticsInclude 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...
28231 Jul 2008 @ 11:18 PDTDatabaseReplyconvert string to date formatSelect 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...
28129 Jul 2008 @ 11:46 PDTToolsReplyCOALESCE in FastLoad ScriptHow about using MultiLoad instead? That would support COALESCE.
28024 Jul 2008 @ 11:36 PDTConnectivityReplyTrying to set up ODBC connectionSome uninstall did not work properly. Search your hard drive for multiple copies of the terasso.dll file and remove old ones manually.
27922 Jul 2008 @ 03:51 PDTDatabaseReplyImplementing 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...
27826 Jun 2008 @ 10:00 PDTUDAReplyDate formatTeradata 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...
27726 Jun 2008 @ 09:51 PDTToolsReplyMLOAD script error.LAYOUT describes the input file, not the table. If you use VARTEXT, all the fields must be declared VARCHAR in the layout.
27626 Jun 2008 @ 09:46 PDTToolsReplyFastload: 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...
27511 Jun 2008 @ 10:44 PDTDatabaseReplyTime 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...
27410 Jun 2008 @ 11:52 PDTDatabaseReplyTime format of FirstRespTime (DBQLogTbl)The latter: 51 centiseconds = 510ms
27306 Jun 2008 @ 02:55 PDTToolsReplyTeradata 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...
27226 May 2008 @ 09:32 PDTUDAReplyMload Login ErrorIf 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...

Pages