#DateForumTypeThreadPost
282820 Jun 2014 @ 12:26 PDTGeneralReplyhow to eliminate duplicate records in a file while loading into the target table without using fastloadIs your target table SET or MULTISET? Is there a UPI or NUPI? What are you going to do with those records, INSERT them into the target? INSERTs into SET tables will never load duplicate rows, bu...
282719 Jun 2014 @ 01:01 PDTTeradata ApplicationsReplyConverting TimeStamp into DateDid you check Explain/DBQL why it's slow? Compare Explains with/without cast, it might be a bad plan due to loosing statistics on the casted column. You can also add one day to "Posting D...
282619 Jun 2014 @ 12:50 PDTAnalyticsReplyQualify and group by statement conflictBoth queries are not your actual queries (using keywords DATE and COUNT as column names), so it's hard to tell why it's failing. The common coding error: When OALP and GROUP BY is mixed w...
282518 Jun 2014 @ 02:00 PDTDatabaseReplyqueryloggingSince TD13 there's a command to get the effective rules, this might be what you want: SHOW QUERY LOGGING ON username
282416 Jun 2014 @ 03:21 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverThe manual for ODBC 13.10 is from Aug 13, 2010, five years later than 03.05 :-)
282316 Jun 2014 @ 07:37 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverBetter read manuals matching your release, ODBC Version 03.05 is almost 9 years old, in our computer age that's pre-historic :-) NoScan disabled means the driver will replace ODBC functions wi...
282216 Jun 2014 @ 06:31 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverWhere did you read In Windows, this option is called "DisableParsing", I only found an entry (DSN Settings for Third-party Applications) which reads "Disable Parsing" ...
282116 Jun 2014 @ 04:00 PDTDatabaseReply3883 errorIf it's not in QueryLog you have to check the session information to find out who submitted it and try to get more info from this person/aapplication. dbc.dbqlrulesV holds the info about QryLo...
282016 Jun 2014 @ 03:49 PDTDatabaseReplyQuery to Delete all the records in a table in TeradataDon't delete in batches. If the delete is slow it's probably because it needs a Full Table Scan or there's secondary indey maintenance. If you split it into 25 deletes wil require FTSs...
281916 Jun 2014 @ 03:43 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverYou didn't say that you're using a connection string. There's no DisableParsing ODBC option, this is just the name in the ODBC Administrator GUI. Within a connection string or od...
281816 Jun 2014 @ 03:24 PDTDatabaseReplyTD 14 MVCMVC on TIME and TIMESTAMPS is new in 14.10 (before only NULLs can be compressed), but you can compress INT in any release. In your case it's probably one of the old fake time columns, just use ...
281715 Jun 2014 @ 12:16 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverMaybe TD Administrator overrides the "Disable Parsing" setting, try SQL Assistant instead.
281615 Jun 2014 @ 10:16 PDTAnalyticsReplySELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword.Hi Sasha, you can't do a SQL function like this in Teradata. SQL UDFs are limited to simple calculations like those you can do in the SELECT list, but no kind of  Scalar Subquery or simi...
281515 Jun 2014 @ 05:45 PDTDatabaseReplyHelp with error Syntax error: expected something between the beginning of the request and the 'DECLARE' keyword"No, Teradata doesn't allow variables outside of Stored Procedures and most DBAs don't allow end users to create SPs (due to possible usage of cursors and loops, which are really bad (= proc...
281415 Jun 2014 @ 05:37 PDTData ModelingReplyCreating a table of a given size filled with random numbersYes, this is exactly the same query. WITH is mainly usefull if you need to use the same Derived Table multiple times. Otherwise it's just by habit, Teradata only supported the WITH syntax in ...
281314 Jun 2014 @ 03:12 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverIf you checked "Disable Parsing" the ODBC driver should not modify your query.  Do you run this query in SQL Assistant? Which release? If it's old there might be an "Allow ...
281214 Jun 2014 @ 01:55 PDTGeneralReplySpool errorCan you do a HELP/SHOW STATS, too? Number of rows and estimates don't match, is this the actual Explain?
281114 Jun 2014 @ 02:59 PDTDatabaseReplyProblem with ANSI TIME type and ODBC driverYour query should work as-is, did you check if col1 in your target table is actually defined as TIME?  Otherwise it's probably not related to ODBC, it might be due to an implicit typecast...
281013 Jun 2014 @ 07:13 PDTDatabaseReplyHelp with select * from, select count(*) from a table with 411,412,220,990 rowsCan you show what you did so far? Plus the table DDL? If this is an important task and you keep running out of spool you might conact your DBA to increase it.
280911 Jun 2014 @ 10:53 PDTData ModelingReplyCreating a table of a given size filled with random numbers WITH cte (n) AS ( SELECT day_of_calendar AS n FROM sys_calendar.CALENDAR WHERE n BETWEEN 1 AND 1000 ) SELECT (t1.n -1) * 1000 + t2.n ,RANDOM(1,100) FROM cte AS t1, cte A...
280811 Jun 2014 @ 09:40 PDTDatabaseReplyDate CaclucationsYou add 11 months to 2014-06-30 which results in 2015-05-30. This is correct based on Teradata's algorithm, but different from Oracle, ADD_MONTHS is no Standard SQL :-) You need to find the f...
280711 Jun 2014 @ 04:27 PDTDatabaseReplyIdentify Partition Column(s) DBC.ColumnsV.PartitioningColumn = 'Y' :-)
280611 Jun 2014 @ 04:22 PDTViewpointReplyviewpoint softwareThere's no standalone Viewpoint software, it's always preinstalled as an appliance. Some of the TD Express downloads include Viewpoint, you just have to assign more RAM to the VM and start...
280511 Jun 2014 @ 03:46 PDTAnalyticsReplyHow to handle exceptions 'Call failed' in procedure? Hi Frank, are those errors already catched by exception handlers in the sub-procedures?    Only unhanded exceptions are propagated to the calling procedure.   ...
280411 Jun 2014 @ 02:35 PDTDatabaseReplyneed syntax for for last 2 years dataHi Santanu, of course LAST_DAY should be preferred if it exists on your system. LAST_DAY was added in TD14, before it might be implemented as a C-UDF or SQL UDF 

Pages