#DateForumTypeThreadPost
222811 Sep 2013 @ 01:44 PDTDatabaseReplyHow to find table size and index size using Ferret utilityHi Sharib, COLLECT DEMOGRAPHICS is usually quite close to the actual size (but i doesn't include Fallback size), i use a query like this to get a percentage for each SI: SELECT dd.Datab...
222711 Sep 2013 @ 01:29 PDTDatabaseReplyDDL Statement , Dynamic SQL in a FOR cursor LOOP -SQLCODE 3772There's no way to do this in an ANSI mode SP.  If you can't switch to TD mode there's a workaround: Don't EXECUTE the DDLs, but insert all of them into a Volatile Table addin...
222611 Sep 2013 @ 01:16 PDTDatabaseReplySpecial Characters in Teradata  If you know which characters are not special it's easy: CHAR_LENGTH(oTranslate(your_column, 'abcdefghijklmnopqrstuvwxyz','') > 0 indicates special characters.  ...
222511 Sep 2013 @ 01:11 PDTDatabaseReplyHow to calculate moving sums within variable size windows?The RANGE syntax is Standard SQL but unfortunately it's not implemented in Teradata. So Vlad's solution is complicated, but probably the only one (if you actually need this for each row in...
222411 Sep 2013 @ 12:58 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADHi Srini, you have to add more details. If the target table is empty a FastLoad will be the fastest way, otherwise it depends...   Dieter
222311 Sep 2013 @ 10:50 PDTDatabaseReplyVolatile Table Use, Scope, & Ownership within Stored ProceduresThere's no way to find out which VTs exist within your current session using dbc tables. Only "HELP VOLATILE TABLE;" will return that info, but it's not allowed within a SP. The...
222211 Sep 2013 @ 10:19 PDTDatabaseReplyAutomatic script to change PI in case of high SkewHi Saran,  i doubt a script like that exists. Choosing a PI without knowledge about the data plus join and access paths will not automatically result in better performance. You should start ...
222111 Sep 2013 @ 10:12 PDTDatabaseReplyWhy the Optimiser does not run these STATS in parallel ?Only OLAP functions with the same PARTITON/ORDER BY can be calculated in a single step and your ROW_NUMBERs got the same ORDER BY (which is just a dummy order, btw), but different PARTTION. It'...
222030 Aug 2013 @ 10:17 PDTDatabaseReplyTitile Stacking?This is/was used for reports in BTEQ, two slashes in the TITLE result in a linebreak, you can do the same using AS: select 'bla' as "long//column//title"; *** Query complet...
221930 Aug 2013 @ 07:39 PDTDatabaseReplyCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form???Based on the error message this seems to be a SELECT, could you show it (or at least the column names/aliases used)?   Dieter
221830 Aug 2013 @ 05:16 PDTDatabaseReplyIs this the casting error?You might check the avg_depth of the missing rows if it's close to zero:  < 0.0000005 will be rounded to 0   SAS might use FLOAT arithmetics, so you could try avg...
221730 Aug 2013 @ 03:18 PDTToolsReplyMload - upsert scenario when Target row updated by multiple source rowsHi Cheeli, MLoad will simply apply all INSERTs/UPDATEs to the target row in the correct order. If the target table is SET and a duplicate row is inserted or an update results in a duplicate row it...
221630 Aug 2013 @ 02:47 PDTDatabaseReplyExtracting Domain Names from EMAIL_TXT FieldWha's your TD release? In TD14 there's a built-in INSTR to find the #2 dot for the SUBSTRING or REGEXP_SUBSTR, before that you might check what UDFs have been installed. Otherwise it'...
221530 Aug 2013 @ 02:32 PDTDatabaseReplyA question concerning LIKEHi Gwenael, are there trailing blanks in PK1 or PK2, are they defined as CHAR or VARCHAR? The LIKE might also return wrong rows, when PK1 is not fixed length, e.g. 'abcd-1' LIKE 'abc&...
221430 Aug 2013 @ 02:21 PDTDatabaseReplyVTT vs GTTHi Raja, an you elaborate on that? There shouldn't be any difference between GTT and VT.   Dieter
221329 Aug 2013 @ 01:49 PDTDatabaseReplyHow Can User Change Password?Hi Usmans, every user can change his own password, there's no right needed for that. Only if you want to change the password of another user you'll nedd the DROP USER right.   Dieter
221229 Aug 2013 @ 01:43 PDTDatabaseReplyDBC maintenanceYou run it using a BTEQ script submitted by your company's scheduling tool, this might be a simple cron job or CONTROL-M or UC4 or whatever.   Dieter
221129 Aug 2013 @ 10:58 PDTToolsReplyKeeping idle connections alive!  This is no setting in SQLA. But your DBA might automatically disconnect idle sessions (although 3 minutes is quite short)   Dieter
221029 Aug 2013 @ 10:55 PDTDatabaseReplyInvalid session mode error for Store ProcedureA SP must be executed in the same session mode used during creation. You can set the session mode explicitly, e.g. BTEQ -> .SET SESSION TRANSACTION BTET/ANSI" ODBC -> Options .NET -&...
220929 Aug 2013 @ 10:52 PDTGeneralReplyCan anyone give me link where i can get teradata 14.10 express software for windowsTD14.10 Express is not yet released. And when it will be available there will be no Windows version as Teradata only runs on Linux since TD14.   Dieter
220829 Aug 2013 @ 01:42 PDTDatabaseReplyDBC maintenanceAFAIK there are no "official" standard scripts (but when you ask your Teradata PS they can probably provide you with some). The process is similar to DBQL when you want to keep a history...
220729 Aug 2013 @ 01:19 PDTDatabaseReplyBig table - very big table joinHi Debu, #1: if there are statistics on the join columns you should trust the optimizer to pick the best plan #2: no, Teradata rarely uses SIs for joins (unless it's a very small subset of th...
220629 Aug 2013 @ 01:18 PDTDatabaseReplyVTT vs GTTWell, a VTT is local to your session and other users are connected to different sessions...... ehm... no   Dieter
220528 Aug 2013 @ 02:35 PDTDatabaseReplyCollect stats with DML statements in InformaticaHi Nishant, when BT/ET is used the session is running in Teradata mode. So each request is a standalone transaction unless you use BT/ET. If it's actually BT;COLLECT STATS;ET; you might simpl...
220428 Aug 2013 @ 02:31 PDTToolsReplyProblem to import a delimited text file in teradata tableThere should be no  EOF # END of MultiLoad and you don't have to define the new line                 .FIELD NewLine * VARCHAR(1); &nbs...

Pages