#DateForumTypeThreadPost
82818 Oct 2010 @ 12:17 PDTDatabaseReplyWhy do we need integer datatypesHi Manu, it's better to have more choices available :-) Differences which come to mind: - integers are truncated, but decimals are rounded, e.g. select 2/3 vs. select 2./3. - the range of val...
82718 Oct 2010 @ 12:11 PDTTeradata ApplicationsReplyRESET keyword in Teradata 12 CertificationIf this a TD12 course, then it's a bug. Dieter
82618 Oct 2010 @ 12:10 PDTCloud ComputingReplyTeradata DBMS is in bad state in TD Express 12 images (40GB as 1TB) There's a new version (12.0.03.14) of the Linux TD12 Express available, which should fix that problem: http://downloads.teradata.com/download/database/teradata-express-12-0-for-vmware-player-40-...
82517 Oct 2010 @ 03:44 PDTGeneralReplyMaximum number of AMPS possible in Teradata version 12 and above ??? Hi Sakthi, in fact the maximum number of AMPs is even much less than 16k, because PEs and Gateways are also VProcs. AFAIK the largest systems currently got about 3000 AMPs, so there's still som...
82417 Oct 2010 @ 03:27 PDTDatabaseReplyParallel apply Hi Lakshmi, ODBC is the worst connection type for that scenario. Your 3rd party tool should at least support "array inserts" to submit batches instead of single row inserts. If you use multipl...
82317 Oct 2010 @ 03:06 PDTTeradata ApplicationsReplyRESET keyword in Teradata 12 CertificationIt's not from the TD12 course notes, this is TD13 syntax :-) Dieter
82213 Oct 2010 @ 12:30 PDTDatabaseReplyWhere are Stored Procedures stored ?SPs are compiled into DLLs (Windows) or Shared Objects (Unix), those objects are stored within the owning database. As it's fallback, you always see two AMPs with the same permspace size. And ...
82113 Oct 2010 @ 12:18 PDTDatabaseReplyProblems with "WITH(NOLOCK"Hi Ramiro, you don't need to repeat the row lock, it just: LOCKING ROW FOR ACCESS Select A.* from TABLE_1 A LEFT OUTER JOIN ( Select * From TABLE_2 ) B ON A.FIELD = B.FIELD Dieter
82007 Oct 2010 @ 11:57 PDTDatabaseReplyParse Views to Tree StructureI don't know much about the MDS, but there's documentation available: http://www.info.teradata.com/templates/eSrchResults.cfm?txtrelno=&nm=Teradata%20Meta%20Data%20Services&srtord=Desc&txtttlkyw...
81907 Oct 2010 @ 11:50 PDTDatabaseReplyDecimal or VARCHAR Null handlingWhen you export "COALESCE(A.FIELD3,X'FF') (CHAR(06))" you can't use ".FIELD FIELD3 010 SMALLINT" for import, because the data types don't match. But why don't you use the built-in option to deal...
81807 Oct 2010 @ 11:42 PDTConnectivityReplyTeradata ODBC Install ErrorI don't know what to delete in registry, but you should use a newer ODBC driver (13.10 is available), they're backwards compatible. http://www.teradata.com/DownloadCenter/Forum90-1.aspx Diete...
81705 Oct 2010 @ 05:01 PDTDatabaseReplyPPIWithin a PPI table the old 8 byte rowid is no longer unique within the table, it's just unique within partition. But the 10 byte combination on partition number plus rowid is unique. The two ro...
81630 Sep 2010 @ 11:52 PDTCloud ComputingReplyTeradata DBMS is in bad state in TD Express 12 images (40GB as 1TB) Hi Alain, maybe the download is not available because of that problem :-) Before you BOOTed the amp, did you try to set the amp's status from FATAL to ONLINE? A BOOTed amp needs a TABLE REBU...
81530 Sep 2010 @ 11:28 PDTDatabaseReplyCollecting Stats after deleting all dataIt's the same reason as any stats, it tells the optimizer about the number of rows and helps producing a better plan. And there's almost no overhead collecting stats on a an empty table. But if...
81430 Sep 2010 @ 11:16 PDTDatabaseReplyAdding time feildsYou have to define the resulting datatype: select (endTime - startTime) hour to second Dieter
81327 Sep 2010 @ 10:16 PDTUDAReplyRank in TeradataIt's a Standard SQL function, which is available in most DBMSes. Just read the SQL Functions and Operators manual. Dieter
81227 Sep 2010 @ 10:14 PDTGeneralReplyDifference between Product Join and Cartesian Product JoinThere is no difference and there are no separate join strategies. Why do you think so? Dieter
81127 Sep 2010 @ 10:12 PDTToolsReplyUpdates for Express?I don't think there's a patch, but the Linux downloads are updated to 13.00.00.19 and 12.00.02.07 Dieter
81027 Sep 2010 @ 10:09 PDTCloud ComputingReplyTeradata DBMS is in bad state in TD Express 12 images (40GB as 1TB) Hi Alain, this is strange, i run the 40GB 12.0.2.7 Express without any problems. Did you check /var/log/messages for Teradata related info? You could try to set the fatal amp onine using vpr...
80924 Sep 2010 @ 05:50 PDTToolsReplyRemoving vowels in the columnSEL 'CUSTPGM-15962' as col, otranslate(col, '.' || otranslate (col,'.MU','.'), '.'); *** Query completed. One row found. 2 columns returned. *** Total elapsed time was 1 second. col ...
80824 Sep 2010 @ 04:35 PDTToolsReplyRemoving vowels in the columnWhat did you try exactly? And what didn't work? This is the typical approach to remove all other characters when you exactly know which chars to retain. Of course you might have to add the uppe...
80724 Sep 2010 @ 04:12 PDTToolsReplyRemoving vowels in the columnYou shouldn't try that without a UDF, because the code will look like: case when position(substring(first_name from 1 for 1) in 'bcdfghjklmnpqrstvwxyz') > 0 then substring(first_name from 1 ...
80622 Sep 2010 @ 02:02 PDTDatabaseReplyRecompiling all Stored Procedures???Hi JK, if you explain a SHOW PROCEDURE you'll see where the source code is actually stored. But there's no way to retrieve that information other than SHOW And if the SP was created using the W...
80522 Sep 2010 @ 01:47 PDTDatabaseReplyHelp creating Query select coalesce(t2.datavalue2, t3.datavalue3, 'unknown') from table1 as t1 left join table2 as t2 on ... left join table3 as t3 ... Dieter
80415 Sep 2010 @ 11:23 PDTDatabaseReplyHow to recover the data when it has been stored in fixed length by teradata ?This is similar to storing a varchar in a char column. You can try to remove the added HEX '00' using TRIM(TRAILING FROM col), hopefully there were no trailing 0 in your input data. And next ti...

Pages