#DateForumTypeThreadPost
277822 May 2014 @ 08:06 PDTToolsReplyNeed Help in Teradata FunctionsHi Satya, what's your TD release? For this task there's a STRTOK function In TD14 (which is a bit easier to use than a  regular expression or INSTR): STRTOK(col, '|',...
277722 May 2014 @ 08:01 PDTDatabaseReplyRecommendation on varhar - char columnsCHAR(n) always need exactly n bytes for LATIN or n*2 bytes for UNICODE while VARCHARs need 1 or two bytes for each character stored. But VARCHARs also need two byte additional overhead (a word indi...
277619 May 2014 @ 01:04 PDTToolsReplyTeradata Express 7z file complaining of corrupted sda.vmdkI've seen similar errors when trying to extract to a FAT32 filesystem, after extracting the first two GBs :-)
277519 May 2014 @ 01:02 PDTDatabaseReplyfast load quotes fieldHi John, yep, you're using a 13.10 FastLoad against a 14.10 TD, which is definitely causing that problem. The solution is simple: upgrade FastLoad, simply ask your DBA, he should support this...
277419 May 2014 @ 12:39 PDTDatabaseReplyfast load quotes fieldHi John, you said you're using TD14, but did you check your FastLoad version if it supports DELIMITER/QUOTE? SHOW VERSIONS; should return 14, too.
277316 May 2014 @ 08:07 PDTDatabaseReplyOutput of script will be a set of select queriesHi Arindam, when you work with Oracle you need to have some knowledge of the basic metadata views :-) ALL_TAB_COLUMNS is similar to dbc.ColumnsV
277216 May 2014 @ 02:58 PDTGeneralReplyInstallation of Teradata on LinuxHi Achyuth, for testing purposes there's only the TD Express VM, so you have to install VMWare Player. Btw, the VM runs the same OS as the "real" TD, Suse Enterprise Linux 11.
277116 May 2014 @ 02:26 PDTDatabaseReplySingle slot in throttle for multiple requestsHi Asim, the parser and so TASM work on a REQUEST level, so the only way to get all ten Inserts in a single unit of work in TASM is a Multi Statement Request.      
277015 May 2014 @ 05:59 PDTDatabaseReplyHow to calulate Skew on Join IndexHi Peter, you're welcome, I know it's confusing :-) COLLECT DEMPGRAPHICS FOR mytable INTO myDatabase; where myDatabase is the name of the database where DataDemographics has been creat...
276915 May 2014 @ 04:09 PDTDatabaseReplyHow to calulate Skew on Join IndexHi Peter, you don't specify the table name (always DataDemographics), it's the databasename, where DataDemographics is created :-)
276815 May 2014 @ 12:30 PDTDatabaseReplyFind position of a character in a stringHi Sangeeta, it's not failing when you copied it exactly :-) If you're not on TD14 (STRTOK function) i'm promoting the Ebay functions again: http://developer.teradata.com/blog/madmac...
276715 May 2014 @ 12:22 PDTGeneralReplyHow do I split a column between quantity and unit of measureIf you can install a UDF (talk to your DBA) the eCStrSpn from Ebay will be helpfull: eCStrSpn(size,'0123456789.') will return the position of the last digit, based on that you can eas...
276614 May 2014 @ 02:08 PDTDatabaseReplyNumeric or non-numeric valuesI just remembered the Ebay UDFs, there's a eIsDecimal UDF which should be exactly what you need:  http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs
276514 May 2014 @ 01:47 PDTDatabaseReplyVertical pivotingHi Kim, "up to 250", lets assume only 25 in average * 27,000,000 = 675,000,000 rows, when it's finally up to 8 times as much you get a few billion rows a day, ouch. But this should ...
276414 May 2014 @ 12:15 PDTGeneralReplyStats can be collected on Global temporary tables but not on volatile table why?You must be runing a quite old version. This restriction has been removed in TD13. 
276314 May 2014 @ 12:11 PDTDatabaseReplyVertical pivotingHi Kim, what's the exact definition of that table and how many values are returned per row in average? Can you show the current explain of both versions?
276214 May 2014 @ 11:38 PDTToolsReplyTPT script : syntax error at "VARCHAR"; It's UserPassword instead of Password.
276114 May 2014 @ 11:28 PDTDatabaseReplyVertical pivotingHi Kim, assuming this is a one time load you might split the data in multiple parts ('a' to 'e', 'f' to 'j', etc) and repeat the query for each part. What's th...
276014 May 2014 @ 07:46 PDTDatabaseReplyVertical pivotingHi Kim, for a "couple hundred million" rows recursion is not really recommended :-) I posted a recursive query for that some time ago, the last query should avoid the spool problem (and...
275914 May 2014 @ 07:20 PDTDatabaseReplyHow to calulate Skew on Join IndexHi Peter, you don't need any special access right (beside SELECT on the base table)  to submit a COLLECT DEMPGRAPHICS. But the result is inserted into the DataDemographics table, wh...
275814 May 2014 @ 04:58 PDTToolsReplyTPT script : syntax error at "VARCHAR"; Should be a different error :-) You need to escape the single quotes names within your INSERTs, too, e.g. ('INSERT INTO tduser.Source_Emp_Table (1,''joe'');'), &nbs...
275714 May 2014 @ 04:55 PDTDatabaseReplyHow to calulate Skew on Join IndexHi Peter, if you need this for a "what if this was my new PI" you have to use the HASHAMP calculation, although skew on JIs is of less concern as they might prefer performance over distr...
275614 May 2014 @ 04:37 PDTDatabaseReplycreating C UDF - issue with float outputI'm not a C-programmer, but when you define the result datatype as FLOAT within the C-code and as DECIMAL(38,9) within the CREATE FUNCTION this will never match.
275513 May 2014 @ 06:40 PDTGeneralReply default character set in teradataCould you please post new questions as a new topic? You need to use ALTER TABLE, the syntax is a bit weird as you actually modify the definition of an existing column: ALTER TABLE tab ADD colna...
275413 May 2014 @ 05:10 PDTDatabaseReplyNumeric or non-numeric valuesWhat's your TD release? In TD14 there are regular expressions, e.g. this will return 1 for any kind of decimal like ' 24', '-23.66', '+2.98' regexp_instr(trim(col), ...

Pages