#DateForumTypeThreadPost
17410 Sep 2008 @ 04:12 PDTAnalyticsReplyHiding a column from outputDefine a WITH query, derived table, or view containing the AGE derived column. You can then reference it in the case expression without including it in the select list of the main select.
17310 Sep 2008 @ 04:06 PDTDatabaseReplyERROR: 3812, positional assignment list has too few valuesThe 3218 error is a SQL syntax error. The target table (or column name list in the insert statement) has more columns than you specified values for.
17204 Sep 2008 @ 01:25 PDTDatabaseReplyhow to solve DBS CRASHED OR SESSIONS RESET problemPlease contact your Teradata support representative. A system crash is not usually a problem that can be solved by the user.
17122 Aug 2008 @ 06:05 PDTDatabaseReplyhow to write a function to retrieve random character from A TO ZTry this:SELECTCASE WHEN Rand = 1 THEN 'A'WHEN Rand = 2 THEN 'B'WHEN Rand = 3 THEN 'C'WHEN Rand = 4 THEN 'D'WHEN Rand = 5 THEN 'E'WHEN Rand = 6 THEN 'F'WHEN Rand = 7 THEN 'G'WHEN Rand = 8 THEN 'H'W...
17022 Aug 2008 @ 05:38 PDTDatabaseReplyTeradata AMP lock table overflowI believe you alluded to the remedy in your initial message in this topic. As a matter of application design, the number of locks held by a given transaction must be controlled.I don't know why th...
16920 Aug 2008 @ 01:38 PDTDatabaseReplyASCII Function in TeradataTeradata has no equivalent built-in function, but the "Oracle UDFs" package has that function. You can get it from the Teradata download center on www.teradata.com.
16815 Aug 2008 @ 09:42 PDTDatabaseReplyFormat QuestionThe ANSI CAST drops leading blanks. One alternative is to use the Teradata (non-ANSI) conversion specifier. In the example below, I applied a format to the decimal value to get leading blanks and...
16715 Aug 2008 @ 01:59 PDTDatabaseReplyHow to convert minutes to H:M:S formatThe form "INTERVAL 'string' MINUTE" is an interval literal. If you want to convert a character or integer type value, it seems that you need 2 casts. create table t1 (a int, b char(3)); *** Tabl...
16614 Aug 2008 @ 02:25 PDTToolsReplyIssues in MultiloadMultiLoad will attempt to load the duplicate records. What happens then depends entirely on whether the result violates any constraint, either explicit or implicit, that has been defined on the ta...
16514 Aug 2008 @ 02:15 PDTToolsReplyCan we invoke a BTEQ script from a BTEQ script?In addition to .RUN, you can use the .OS command to execute bteq or any other shell command. For example:.os bteq < my_bteq_script .os arcmain < my_archive_script
16414 Aug 2008 @ 02:09 PDTDatabaseReplyTeradata AMP lock table overflowYou won't find that documented in any of the customer manuals.
16314 Aug 2008 @ 02:01 PDTDatabaseReplyHow to convert minutes to H:M:S formatselect cast(interval '312' minute AS interval hour to minute); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. 312------ 5:12
16212 Aug 2008 @ 01:24 PDTDatabaseReply"Lost" Spool SpaceIt depends on what you consider significant. It could cause some queries to fail unnecessarily on a bogus "out of spool space" condition. My advice is to use UPDATESPACE to repair the accounting ...
16112 Aug 2008 @ 01:14 PDTUDAReplyData ConversionYour statement is syntactically correct. Evidently, the source column data does not parse correctly as a decimal string.
16011 Aug 2008 @ 02:05 PDTDatabaseReply"Lost" Spool SpaceIt's likely that you are seeing a discrepancy in the disk space accounting, where it does not accurately track actual disk usage. Bugs in the space accounting component have been found and fixed f...
15908 Aug 2008 @ 06:04 PDTDatabaseReplyHas anyone successfully installed Teradata Express 12 on XP SP3?You may be running into the infamous Windows DEP feature. Look in the Windows Event Log to see if a memory access exception was logged. Check out this URL for a detailed explanation of DEP:http:/...
15805 Aug 2008 @ 02:17 PDTToolsReplyhow to find sysdate and time valueTeradata also supports the ANSI/ISO standard SQL functions CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP.
15704 Aug 2008 @ 06:24 PDTDatabaseReplyTeradata AMP lock table overflowThe "lock table" (actually an in-memory data structure) has a fixed size of 2MB in each AMP. The total lock capacity of the system can be increased only by increasing the number of AMPs in the sys...
15630 Jul 2008 @ 01:40 PDTDatabaseReplyInteger Vs Varchar in joins - Performance ImpactIMHO, the cost difference between varchar and integer in comparing the column values would be miniscule. The cost of the join will be overwhelmingly dominated by other factors.
15528 Jul 2008 @ 01:17 PDTDatabaseReplyhow to clean a user's maxpermAdeel seems to be confusing MaxPerm with PeakPerm.You can change MaxPerm to anything you want using the MODIFY USER statement.
15425 Jul 2008 @ 02:03 PDTDatabaseReplyTeradata DUAL LOAD (architectue/Design) qustionAs I understand it, there is a Teradata product called Query Director product that could make the failover transparent to some users, but I don't think it can transparently redirect load jobs.The R...
15324 Jul 2008 @ 04:23 PDTDatabaseReplyTeradata DUAL LOAD (architectue/Design) qustionBy "shadow technology", I assume you mean a read-only mirror that is maintained directly out of the disk array system. Teradata does not currently support that kind of solution.Supported alternati...
15202 Jul 2008 @ 06:40 PDTTrainingReplyTeradata CDs for UNIX OSThe demo (a.k.a. Teradata Express Edition) is only available for Windows.http://www.teradata.com/t/page/180454/index.html
15117 Jun 2008 @ 11:57 PDTDatabaseReplyPermanent Journals need the spool space or the others?Permanent journals use permanent space.
15013 Jun 2008 @ 01:17 PDTDatabaseReplyrowkeyNo, rowkey is the rowid minus the uniqueness value. In the absence of a partitioned or value-ordered primary index, the rowkey is simply the row hash.

Pages