#DateForumTypeThreadPost
210324 Jul 2013 @ 01:30 PDTDatabaseReplyInstalling and Enabling Query Logging in Teradata Express 13 VMware VersionHi Vince, you don't need to install query logging, you just have to switch it on using BEGIN QUERY LOGGING. Check the Database Administration manual for details on DBQL including housekeeping...
210224 Jul 2013 @ 09:55 PDTAnalyticsReplyDate format transferHi Jason, based on the internal storage of a date in Teradata you should use this: cast(20130701 - 19000000 as date)   Of course you should store a date in a DATE not in an INTEGER t...
210124 Jul 2013 @ 09:53 PDTDatabaseReplyChange columns orderYou can't do that. Why do you think you need it? Teradata is a Relational database and the order of columns has no relevane in Relational Model. You might simply change the 1:1 view for this ...
210024 Jul 2013 @ 09:47 PDTDatabaseReplyImmediately exit a query if a condition is verifiedOooops, V2R6.1 is quite old, the optimizer started to resolve CURRENT_DATE in a later version. You say you can't use BTEQ, but how is the query scheduled then?   Dieter
209924 Jul 2013 @ 07:42 PDTDatabaseReplyImmediately exit a query if a condition is verifiedWhat's your TD release? "(CURRENT_DATE - DATE '0001-01-01') MOD 7 = 0" should be the same as "1=0" Could you post output of explain? Dieter 
209824 Jul 2013 @ 06:47 PDTDatabaseReplyImmediately exit a query if a condition is verifiedAdd a condition based on current_date: WHERE (your current conditions) AND (CURRENT_DATE - DATE '0001-01-01') MOD 7 = 0 When you check Explains you'll still get some RETRIEVE/JOIN ...
209720 Jul 2013 @ 02:05 PDTConnectivityReply.NET Data provider - Canonical functions support Hi Sundar, sorry that i asked such a basic thing, but some people don't really read documentation :-) IMHO it should be in Teradata.Client.Provider, what if you try any other function from th...
209620 Jul 2013 @ 12:51 PDTConnectivityReply.NET Data provider - Canonical functions support Hi Sundar, i'm not a .NET programmer, but when i looked at the link you provided i found  For example, to execute a .NET Framework 4.0 supported EndsWith(SearchString, TargetString) f...
209519 Jul 2013 @ 04:26 PDTPrivate Forum
209419 Jul 2013 @ 04:24 PDTViewpointReplyHow can users abort their own queries without being able to abort anyone else's?There recently was a thread on this topic on the TeradataForum: http://www.teradataforum.com/teradata/20130606_124329.htm   Dieter
209319 Jul 2013 @ 04:22 PDTDatabaseReplyAccess rights to see UDF source code in SHOW FUNCTIONHi Matthias, are you trying to SHOW some of the built-in functions like oREPLACE? They never show source code as they're not complied on the system, they're supplied in a pre-compiled lib...
209219 Jul 2013 @ 03:58 PDTDatabaseReplyCross tab - PivotThere's no place like sysindexes in Teradata which keeps the rowcount. You need to run multplie SELECTs like SELECT (SELECT COUNT(*) FROM tab1) as cnt1, (SELECT COUNT(*) FROM tab2)...
209119 Jul 2013 @ 03:53 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesHELP COLUMN databasename.viewname.*;   Dieter
209019 Jul 2013 @ 03:51 PDTData ModelingReplyModeling for NUPI and USI combinationHi Raja, choosing the PI is mainly based on joins (plus WHERE-conditions, but these can be covered by a secondary index, too) Only if the PK is actually the most frequent join path you should imp...
208919 Jul 2013 @ 03:46 PDTDatabaseReplyRelation between Statistics and Indexes on a tableHi Mahesh, this is just a misleading error message, it should be rephrased to match the error for single column statistics:  "6956 Column xxx has statistics and cannot be dropped or mod...
208819 Jul 2013 @ 03:08 PDTDatabaseReplyBTEQ in ANSI modeHi Mahesh, how did you call that script? There's STDOUT and STDERR, seems like there was a problem with your logon script, which is send to STDERR.   Dieter
208719 Jul 2013 @ 01:55 PDTDatabaseReplyGet all the counts of the tables in the particular database into a tableHi KVB, this topic has been covered several times, you might use: a cursor plus Dynamic SQL in a Stored Procedure to get the exact count simply extract it from the stats if the count...
208619 Jul 2013 @ 01:32 PDTDatabaseReplyImplementing SCD type 2 using ANSI Merge in teradataHi John, you can't do that using a single TD MERGE, you would need an INSERT plus an UPDATE for WHEN MATCHED, which is not supported. But this is exactly why TD added Temporal tables :-) &nb...
208519 Jul 2013 @ 01:25 PDTTeradata StudioReplyTotal and Subtotal Aggregate Function not workingThis is no simple aggregation, the WITH aggregate syntax returns rows plus intermediate aggregates. It's only supported in a REPORT run in BTEQ.   Dieter
208414 Jul 2013 @ 04:28 PDTDatabaseReplyCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form???  Your tablename is probably too long, when you check http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABIIEAG you'll find JDBC FastLoad c...
208313 Jul 2013 @ 04:50 PDTDatabaseReplyno data condition with dynamic result setHi Jeff, i don't know if it's possible to use a NOT FOUND handler for a dynamic cursor, but your 2nd cursor should never work as an UPDATE can't be used for OPEN, you have to use Dynam...
208213 Jul 2013 @ 02:34 PDTToolsReplyTPUMP for Active Ware housing Hi Nishant, as TPT uses the same protocols as the standalone load tools both support Access Modules the same. I can't remember exactly in which release those AMs have been introduced , but fo...
208112 Jul 2013 @ 04:46 PDTDatabaseReplyHow to spell out numeric value in English words by select query.You can :-) http://developer.teradata.com/node/182312     Dieter
208012 Jul 2013 @ 02:44 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Hi Sai, if it's between 1 and 9999:   TO_CHAR((x-1900)*10000+101 (DATE) ,'yyyysp')   Dieter
207912 Jul 2013 @ 02:32 PDTAsterReplyguide for aster clientIt's the same place as any Teradata docu: http://www.info.teradata.com/AsterData/eBrowseBy.cfm   Dieter

Pages