#DateForumTypeThreadPost
415309 Feb 2016 @ 04:44 PSTDatabaseReplyMultiple Evaluation versions of TDThe main difference is the VMWare software, you need a full vSphere ESXI for TVME and just Player/Fusion for TDE. Additionally TVME allows more AMPs (RAM/disks) while TDE is 2 AMPs only, thus...
415209 Feb 2016 @ 02:50 PSTTeradata ApplicationsReplyHow to install Teradata on UBUNTUThere's only a pre-installed VM running Teradata on Suse SLES 10/11.
415108 Feb 2016 @ 01:24 PSTDatabaseReplyQuestion about "regexp_replace"I wouldn't expect much difference, most of the CPU is probably used by the search. There are some differences between Oracle & Teradata regex, Teradata supports both lookahead (?=...) ...
415008 Feb 2016 @ 12:59 PSTPrivate Forum
414908 Feb 2016 @ 12:42 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?I never needed to set one specific value in an array (In fact I hardly used them at all), but it seems like this SET array[x] syntax is not supported outside of a SQL Update. You can set all strin...
414808 Feb 2016 @ 07:38 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?You need to GRANT UDTUSAGE ON SYSUDTLIB TO novatd WITH GRANT OPTION;   Regarding alternatives, if PL-SQL utilizes non-set-based syntax like cursors processing data you will notice that ...
414708 Feb 2016 @ 05:33 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?You need to grant the rights to the database where the SP is created in (or change the SECURITY option), this is the same for Views/Macros. But you might not need an array at all, there's a ni...
414608 Feb 2016 @ 03:49 PSTDatabaseReplyFind Only DuplicatesIf you need to delete the duplicate rows the easiest way should be a SELECT DISTINCT into a new table, drop/rename. But there should be a logical Primary Key for this table, so you might also have...
414508 Feb 2016 @ 03:43 PSTDatabaseReplyPatitioning expressionHi Abhi, both should be similar, resulting in daily partitions. But you should limit the upper date to something like 2030 and add an another partition for your "until changed". Otherwi...
414408 Feb 2016 @ 03:28 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?Arrays in Teradata must be defined/created before you can use them, I know that's annoying. If "SYSUDTLIB.array_strings" doesn't match your needs you must CREATE a new array...
414308 Feb 2016 @ 03:17 PSTDatabaseReplyAlternative to Oracle's packagesNo packages in Teradata. The closest to "one single entity" would be a database (which is a schema actually).
414208 Feb 2016 @ 03:12 PSTDatabaseReplyAfter Initial BLC LoadingThe file system will notice that existing data blocks are compressed and compress new data, too. But when the table is truncated (DELETE ALL) there are no existing blocks and new data will be compr...
414108 Feb 2016 @ 02:49 PSTToolsReplyTDLOADERAs the name implies tdload aka Easy Loader is a loading tool, there's no export to a flat file, use a TPT Export instead.
414008 Feb 2016 @ 02:43 PSTDatabaseReplyHow to write (CURRENT DATE - 1 YEAR) in teradata?Eight months are not always 241 days, so the calculation should be based on your logic.
413908 Feb 2016 @ 02:41 PSTDatabaseReplyQuestion about "regexp_replace"Your regex is greedy, you need to change it to  '(.*? )(A[0-9])(.*)' Btw, if you really need to return the first An only why don't you switch to REGEXP_SUBSTR? SELECT R...
413807 Feb 2016 @ 09:57 PSTGeneralReplyTeradata perm space release issueTwo possible reasons come to mind: - It's a Temporal Table, all rows were closed - ONLINE ARCHIVE was used, but not switched off. Check using dbc.ArchiveLoggingObjsV.  
413703 Feb 2016 @ 01:46 PSTDatabaseReplyCreate Table Using SELECT Statement With Default User and DateYou can add constraints to the CREATE like CREATE TABLE TABLE_TEST (NAME, LOAD_USER CASESPECIFIC DEFAULT USER, LOAD_DATE DEFAULT CURRENT_TIMESTAMP(6) ) AS (SELECT 'Mickey Mouse&...
413603 Feb 2016 @ 01:42 PSTDatabaseReplySelect Failed 2666 Invalid date suppliedThere's no need for CASTs, better use DATE/TIMESTAMP literals: and cast(A.asof_DT as date) between DATE '2016-01-01' AND DATE '2016-01-31' or simplified to: and A.asof...
413503 Feb 2016 @ 01:37 PSTDatabaseReplyDECODE Does Not Trap Divide by Zero ErrorDECODE is not built-in, but a UDF. It's probably not following the same rules as a CASE, i.e. seems to calculate everything before deciding which value to return. The only workaround might be ...
413402 Feb 2016 @ 12:08 PSTDatabaseReplyQuery running for more than 16 hrs for insertion operationI fully agree with VandeBergB that your UPIs are really bad & this might be a reason for bad performance, but it's definitely not Duplicate Row Checks, for UPIs there's hardly more than...
413328 Jan 2016 @ 08:16 PSTDatabaseReplySubstr - End of Line, Count backwards onText and NumbersOf course you need 5 to get the last 6 characters: 'aa1234:bb5678' char[char_length] = '8' char[char_length - 1] = '78' char[char_length - 2] = &#...
413227 Jan 2016 @ 11:20 PSTGeneralReplyvirtual machine performanceAdding AMPs would not help, as you still got the same CPU/IO/RAM, just divide it by more AMPs. I assume you're limited by IO, does Explain show "not be cached in memory"? Do you run...
413127 Jan 2016 @ 03:03 PSTGeneralReplyReplace View - expected something between the word...You should add the actual error. dayofweek & dayofmonth are no valid Teradata SQL functions, but ODBC syntax. The ODBC driver replaces them (if "Disable Parsing" is switched of...
413027 Jan 2016 @ 02:49 PSTDatabaseReplySubstr - End of Line, Count backwards onText and NumbersCHARACTERS/CHAR_LENGTH returns the length of the string, i.e. SUSBSTRING(str FROM CHAR_LENGTH(str)) starts at the last character and now you count 6 characters back.
412924 Jan 2016 @ 04:13 PSTDatabaseReplyQuery running for more than 16 hrs for insertion operationWhat's the PI of the target table, maybe a SET table plus many rows per value? Which step is the one consuming most of the resouces, did you check QryLogStepsV?

Pages