#DateForumTypeThreadPost
92818 Mar 2011 @ 09:58 PDTDatabaseReplyConvert DB2 date to Teradata date.Of course this also works in WHERE, but you have to use the correct format: CAST(b.beta_acct_open_dt AS DATE FORMAT 'ddMMMyyyy') Dieter
92718 Mar 2011 @ 01:40 PDTToolsReplyhow to select sessions,tenacity,sleep,checkpoint etc for fastload,multiload,tpump utilitiesOf course does increasing the number of sessions also increase performance. This mainly depends on the size of the system. As a general rule of thumb you define the number of sessions as a mult...
92618 Mar 2011 @ 01:39 PDTDatabaseReplyClarification. is it possible to create table using create/select with format clause from base table.You have to add the format to your create: CREATE MULTISET TABLE event_tmp (event_id FORMAT '--(37)9') AS (SELECT DISTINCT event_id FROM event ) WITH DATA PRIMARY INDEX (event_id); Btw, w...
92518 Mar 2011 @ 01:12 PDTAnalyticsReplyDynamic viewsOf course you can use a macro to pass dates into a select, this is exactly what they're made for: replace macro foobar (start_dte date, end_date date) as ( SELECT a.* FROM TABLE1, INNER JOIN T...
92416 Mar 2011 @ 01:45 PDTGeneralReplySET CHARSET IN MULTILOADThe charset is a runtime parameter: mload -c UTF8 If you need it for all/most jobs you should set it in the config file, mloadcfg.dat: CHARSET = UTF8 Dieter
92315 Mar 2011 @ 10:24 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youWhy do you think the NOT IN is causing a problem? It's just a where-condition. FastExport can't create VARTEXT, so the concat '|' is the right approach. But the final cast to char adds trailin...
92214 Mar 2011 @ 02:06 PDTDatabaseReplyTable size difference despite the same definition and dataThe documentation might be a bit misleading indeed. But your test result is strange. It's ok when i run it on my system. Looks like the internal housekeeping of the system table is lagging behind...
92114 Mar 2011 @ 01:42 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youYou wrote Outer Join, but the result is the same as an Inner Join, due to wrong join order and wrong where-condition. The optimizer is smart enough to recognize that and replaces outer with inner j...
92013 Mar 2011 @ 01:43 PDTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for youIn your first post you wrote about outer joining 2 tables, but your explains locks 8 tables and there's no outer join in it. Could you post the *original* query and explain. Did you check th...
91912 Mar 2011 @ 02:41 PSTAnalyticsReplywhat are my options in tuning this kind of query. In real life what worked best for you"Unless we run this extract at off peak hrs or ask other users to abort or borrow space from spool reserve, it spools out." "2646 No more spool space" or "2507 Out of spool space on disk"? I'...
91812 Mar 2011 @ 02:26 PSTToolsReplyClarrification required in bteq (.SET MAXERROR)..SET MAXERROR 0 is probably used to switch off automatic termination. But as the minimum errorlevel is 4 setting it to 1,2 or 3 works as expected. I usually do: .set errorlevel unknown seve...
91711 Mar 2011 @ 06:31 PSTDatabaseReplyTable size difference despite the same definition and dataIn addition to jimm's comment: Compress is only usefull for large table, but you're compressing a table with 71 rows on a system with approx. 80 AMPs. There's a table header of 1024 bytes on each...
91611 Mar 2011 @ 06:25 PSTToolsReplyFastload errorVarchar(255) looks like a dummy size, is the data from Access or Oracle? I've seen load file from Oracle with definition like this, load performance was horrible and the target table was much larg...
91510 Mar 2011 @ 07:56 PSTTrainingReplyTeradata 13Certification used to be renewed "every other major release". V2R3 - initial V2R4 - no new certification V2R5 - new V2R6 - no new certification TD12 - new TD13 - no new certification (probabl...
91410 Mar 2011 @ 07:53 PSTToolsReplyTTU 13.1Hi Paul, there's no TD13.10 version for PMon anymore (and no more TD Manager/TDWM). It's replaced by the Monitor Session portlet in Viewpoint. But you can still use PMon 13.00 to access TD13.1...
91310 Mar 2011 @ 07:49 PSTDatabaseReplyMacros and logging outputHi Mark, did you know, that all SQL contained in a macro is a Multi-Statement-Request and MSRs are treated as a single transaction? Do you actually want to run all those 40 macros as a single hug...
91208 Mar 2011 @ 02:58 PSTDatabaseReplyEliminate results if they are equal within a groupThis looks quite similar to your previous post? select * from tab qualify min(fctr) over (partition by id) max(fctr) over (partition by id) Dieter
91108 Mar 2011 @ 02:54 PSTDatabaseReplyNot utilizing the PPI....Since it's not an equi-join the best you might get would be an "enhanced by dynamic partition elimination". But the Ored condition will probably prevent this. Dieter
91008 Mar 2011 @ 02:49 PSTExtensibilityReplyDrop overloaded UDFhelp 'sql drop function'; or a quick look at the manuals reveals there's a DROP SPECIFIC FUNCTION Dieter
90908 Mar 2011 @ 02:42 PSTExtensibilityReplyCreating SQL UDF issuesThe first example runs without errors. SQL UDFs are available in TD13.10, seems you try to run it on TD13. But as this is the first release supporting SQL UDFs they're still limited, you can't ...
90808 Mar 2011 @ 01:59 PSTDatabaseReplyAbort all inactive user sessionsOf course you could write your own based on the PMon API or MonitorSession and AbortSession from syslib, but this is usually done using Teradata Manager or Viewpoint. Dieter
90708 Mar 2011 @ 01:26 PSTToolsReplyTeradata query parserIn dbc.QryLogObjects there's info about tables/columns used within a query, TD13.10 also populates the TypOfUse. Since TD13 there's a built-in facility to create an XML plan (and store it in DBQ...
90608 Mar 2011 @ 12:59 PSTDatabaseReplyComparing a column with itselfYour example result set shows ABCD123 , ABCDTYU ABCD123 , ABCD234 but why is this not also a valid row? ABCD234 , ABCDTYU How many rows might exist with the same n characters? Would thi...
90525 Feb 2011 @ 01:27 PSTDatabaseReplyERROR: [NCR] [Teradata DBMS] [TeraJDBC 03.01.00.103] Syntax error: expected something between '(' and the 'SELECT' keyword. ErroHi Vijay, Teradata doesn't support Scalar Subqueries in the select list before TD13. In most cases they have a bad performance and can easily replaced with an outer join. Your query doesn't ne...
90411 Feb 2011 @ 02:32 PSTDatabaseReplyMLPPI questionYou can't do what that, but monthly partitions are exactly what you need, why do you think your approach would perform better? The effort to scan "year 2010" in a table partitoned by month or ye...

Pages