#DateForumTypeThreadPost
247827 Dec 2013 @ 05:02 PSTDatabaseReplyextending MLPPI tablesBefore TD14 there's a specific rule for changing the definition of sub-partitions on a populated table: You can only add a partition when you also drop a partition, i.e. the number of partitio...
247727 Dec 2013 @ 04:48 PSTDatabaseReplyTable PartitionDid you try to run you query on a table with data in it? According to your explain the table is empty.
247627 Dec 2013 @ 04:45 PSTDatabaseReplyTeradata Dbase Error:5758Hi Swathi, why do you need all those TRIMs? Do you have leading blanks in your data or non matching data types? With TRIM you're simply not matching the PI of the target table.  
247527 Dec 2013 @ 04:42 PSTDatabaseReplyFetching the data for thelast quarter datesWhat's your TD release? In 14 there's Oracle's TRUNC: WHERE datecol BETWEEN TRUNC(ADD_MONTHS(CURRENT_DATE,-3), 'Q'), TRUNC(CURRENT_DATE, 'Q') - 1 Before it's ...
247427 Dec 2013 @ 04:35 PSTDatabaseReplyInserting to a table incrementallyWhy do you want to load in bunches of 100.000 rows? This will be (potentially much) slower than loading all rows in a single step.
247324 Dec 2013 @ 06:42 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0Hi Raja, this only relates to LATIN vs. UNICODE, of course they hash differently and thus you can't get PI-to-PI joins. But algorithmic compression doesn't change the charset, only the sto...
247224 Dec 2013 @ 04:46 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0Hi Khurram, TransUnicodeToUTF8 works for any UTF16 character, but if there's a lot of Latin chars it simply compresses better: Most of the Latin chars are stored in one byte in UTF8 while som...
247124 Dec 2013 @ 04:43 PSTAnalyticsReplyCall a macro from a stored procedure?Hi Ratnam, yes, if it's the only statement. Of course you could have tried that easily on your own :-)
247024 Dec 2013 @ 03:47 PSTDatabaseReplyTop FunctionHi Ratnam, SAMPLE (RANDOMIZED ALLOCATION) returns a truely random result while TOP n (without PERCENT/ORDER BY) simply returns the first n rows found on a single AMP (or multiple AMPs). SAMPLE is ...
246923 Dec 2013 @ 10:01 PSTToolsReplyTPT API, TimeStamp(0)There's no binary represenation for TIMESTAMPs, it must be a CHAR. "TPT API Programmer Guide", chapter 9 "Converting TIME, TIMESTAMP, and INTERVAL Data Types": http://www....
246822 Dec 2013 @ 03:55 PSTDatabaseReplyDual Systems/fallback/replication?Hi Nishant, "Fallback" is definitely wrong, this is just protection from hardware failure. Of course "Journal Tables" might be used to rollback from a wrong load, but this is ...
246722 Dec 2013 @ 03:33 PSTDatabaseReplyON and WHERE clause for JoinsIn the SQL DML manual there's a lot about placing Outer Join conditions in ON vs. WHERE. This also includes a rewrite of an old article from the Teradata Review magazine as a case study. ...
246621 Dec 2013 @ 07:33 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0 Only version 14 can store UTF8 on disk This is obviously wrong. But the first two sentences are correct :-)  
246521 Dec 2013 @ 04:24 PSTToolsReplyBTeq date issueWhat's the existing format? You can see it when you do a SHOW TABLE or a SELECT FORMAT(tablename.Date_issue);
246420 Dec 2013 @ 08:28 PSTToolsReplyBTeq date issueA DATE doesn't have a format, it's just formatted for display, internally it's an integer. If you run that query in SQL Assistant there's a setting how to format dates, BTEQ doesn&...
246320 Dec 2013 @ 06:32 PSTDatabaseReplyFinding the table size alone?There's a quite unknown COLLECT DEMOGRAPHICS command (to be used by Index Wizard or Visual Explain) which estimates the size of each subtable per AMP. You don't need a full Query Capture D...
246219 Dec 2013 @ 08:41 PSTConnectivityReplyConnecting to Teradata.netHi Raja, WITH SUM is not an OLAP query, it's a proprietary syntax for BTEQ reports which doesn't return a tabular result set and therefore can't be displayed in an answer set grid.
246119 Dec 2013 @ 07:57 PSTDatabaseReplyjoining two tables using SUBSTRThis will also return a row for 'CH' matching 'CHG', you have to change it slightly: SEL * FROM tb1 a , tb2 b WHERE ','||b.cntry_code||',' LIKE '%,'||TRI...
246019 Dec 2013 @ 07:49 PSTDatabaseReplyAccount Strings - AGHi Geeta, i don't know if there's a limit, but i don't think so.  Hopefully there's a pattern, so you can easily map account strings to PG based on wildcards in TDWM.
245919 Dec 2013 @ 07:43 PSTConnectivityReplyConnecting to Teradata.netHi Raja, the create works for me using SQL Assistant plus dotNet. If it's a SLECECT AND CONSUME it must be a plain select without any WHERE/JOIN/GROUP/ORDER. Without CONSUME you can do whatev...
245819 Dec 2013 @ 05:54 PSTDatabaseReplytwo similar tables - very different import speedEach record is less than 500 bytes and adding 10 bytes shouldn't cause any difference, strange. Without more info it's hard to say what caused this. Is this repeatable? 300.000 rows in 30 ...
245719 Dec 2013 @ 05:32 PSTConnectivityReplyConnecting to Teradata.netHi Raja, if you don't show the actual query it's hard to tell, but it looks like you wrote CREATE QUEUE TABLE xxx instead of CREATE TABLE xxx, QUEUE
245619 Dec 2013 @ 05:28 PSTDatabaseReplySpool space issueYou should check the spool usage of an individual query based on QueryLog.  Those functional users like BO normally get an insane amount of spool to be able to run multiple reports in paralle...
245519 Dec 2013 @ 03:15 PSTDatabaseReplyLock row for access : In insert-SelectHi Binayak, as there's no actual lock on a view it's always passed to the table. Simply Explain your query.
245419 Dec 2013 @ 12:02 PSTDatabaseReplyQuestion on Stored procedureQ1: of course. CREATE PROCEDURE is not part of the default rights granted to a user, it must be granted explicitly by the DBA. Q2: of course not. There are seperate rights for all CREATEs Q3: yes...

Pages