#DateForumTypeThreadPost
17114 Jun 2007 @ 11:43 PDTDatabaseReplyGROUP BY and WITH...BY clauses may not contain aggregate functions ?True. If you want the "empty return" behavior, you can use GROUP BY just as long as the expression is not a simple integer constant. That case has special meaning in Teradata. You could use a non-...
17013 Jun 2007 @ 11:35 PDTDatabaseReplyGROUP BY and WITH...BY clauses may not contain aggregate functions ?When you say "GROUP BY 1", the 1 refers to the first expression in the SELECT list, namely COUNT(*), which is why you get this error. If all the expressions are aggregates you can just omit the GRO...
16909 Jun 2007 @ 12:44 PDTToolsReplyQueue on CPU and Resusage TableNo, this would be processes (which might be AWTs) waiting in the OS dispatcher queue for their next CPU time slice. It's not directly related to messages waiting for an AWT to pick one up and start...
16806 Jun 2007 @ 11:23 PDTThird Party SoftwareReplyV2R6 EXAMSLogical next move would be to actually release Teradata 12.0, and some time after that to modify the exams to reflect the new feature / function.
16706 Jun 2007 @ 11:20 PDTToolsReplyFSP=0 and MloadYes, it will attempt to allocate a new cylinder. If the number of free cylinders on the AMP approaches zero that could trigger minicylpack.
16605 Jun 2007 @ 07:47 PDTToolsReplyFSP=0 and MloadNo, it doesn't fail. MLoad into a populated table ignores FSP (uses free space if there is any).
16502 Jun 2007 @ 09:58 PDTDatabaseReplyTeradata Space and CylindersA "cylinder" is a group of logically contiguous sectors in the Teradata hashed filesystem. See the manuals, e.g. Database Administration, for details.
16402 Jun 2007 @ 09:43 PDTToolsReplyQueue on CPU and Resusage Table(ProcReadySum / CollectIntervals) should give you an "average CPU queue depth" by node by log interval. Or SUM(ProcReadySum)/SUM(CollectIntervals) it you want to aggregate...
16330 May 2007 @ 11:00 PDTAnalyticsReplyAll virtual circuits are currently in useHow many IIS instances, and how many IP addresses / gateways is each using for Teradata connections? That's more likely to be the bottleneck than number of PEs.Are you using specific IP address, a ...
16230 May 2007 @ 10:43 PDTConnectivityReplytrying to connect to SQL 2005 DTSNot Teradata specific, but did you set PersistSecurityInfo property to True for the connection?
16130 May 2007 @ 10:36 PDTDatabaseReplyRequired the book TERADATA ORANGE BOOK : Partition Primary Index UsageOrange Books can be downloaded from Teradata @ Your Service.
16018 May 2007 @ 03:20 PDTDatabaseReplyDates In Decimal FormatInteger arithmetic is cheaper than string manipulation or FORMAT conversion:SELECT CAST((1000000+(IntDate MOD 100)*10000+IntDate/100) AS DATE)FROM (SELECT CAST(112207 AS INTEGER)) x(IntDate);Or if ...
15914 May 2007 @ 10:51 PDTToolsReplyMissing recordsYou say you selected FASTLOAD? FastLoad always quietly eliminates totally duplicate rows. If you really need to load duplicate rows to a MULTISET table you should use some other method, e.g. MultiL...
15814 May 2007 @ 10:47 PDTDatabaseReplyCollect stats index vs multiple columns: advantages?If there is a corresponding index, the action taken by the database is identical regardless of which syntax you use. The only time it matters is if you first collect stats on multiple columns and l...
15709 May 2007 @ 10:30 PDTConnectivityReplyTIMESTAMP in UDFDid you look at the supplied sqltypes_td.h? TIMESTAMP is a struct rather than a simple type...
15608 May 2007 @ 11:38 PDTDatabaseReplyout of spoolEach user has a spool space limit, stated as a system-wide limit but enforced as a proportional limit on a per-AMP basis. "No more spool space" does not mean that there is no free space left on the...
15508 May 2007 @ 11:23 PDTDatabaseReplyFastload via Teradata ClientTry :start_date (date, format'yyyymmdd')etc.
15419 Apr 2007 @ 12:23 PDTToolsReplyCreating a new TableAnd you generally should also specify a PI, otherwise it will default to NUPI on the first column only.
15316 Apr 2007 @ 09:51 PDTDatabaseReplyPrior week from current dateOr if you care about the time of day WHERE ORDER_CREATE_DT >= CURRENT_TIMESTAMP - INTERVAL '7' DAY
15209 Apr 2007 @ 01:34 PDTDatabaseReplynot able to release mload lockYou should always attempt the RELEASE MLOAD before you drop anything. That way if you get 2572 you can decide if you want to restart the MLOAD and allow it to complete or if you really want to abor...
15103 Apr 2007 @ 11:11 PDTConnectivityReplyUnable to find compiler for CREATE FUNCTIONSort of... The help file on the demo CD says you need VS / VC++ 6.0, but does not give details as to why or what you might do if you don't have that exact version available.
15003 Apr 2007 @ 11:43 PDTConnectivityReplyUnable to find compiler for CREATE FUNCTIONI believe the V2R6.1 demo is still looking specifically for Visual C++ / Visual Studio 6.0 registry keys. See this thread for a possible workaround: http://www.teradataforum.com/teradata/20040720_1...
14903 Apr 2007 @ 11:27 PDTUDAReplyEncryption or masking of data at DB Level!!!!Masking can be done with a view. Encryption would require a UDF; there are third-party vendors that partner with Teradata to provide such features.
14829 Mar 2007 @ 01:41 PDTUDAReplyNeed information on end of life support for Teradata V2R6.01.00.00Log on to Teradata @ Your Service and you'll find the current "maintenance schedule" under the Roadmaps heading.You don't say what exactly you mean by "end of life"; but for V2R6.1.0, the answer wo...
14723 Mar 2007 @ 12:21 PDTConnectivityReplylibmqmcs.so missingThose libraries are part of WebSphere MQ client install. Teradata's MQ Access Module is an interface between IBM's client code and Terdata's utilities.

Pages