#DateForumTypeThreadPost
245318 Dec 2013 @ 11:59 PSTDatabaseReplySpool space issueAccording to Standard SQL FROM is processed before WHERE in theory, but all optimizers try to push the WHERE-conditions into the join, thus they're are practically done before or during th...
245218 Dec 2013 @ 01:54 PSTTeradata StudioReplyUnable to parse simple query: version 14.10.01There's no YEAR function in Teradata or Standard SQL. Depending on some ODBC settings this might still run (the ODBC driver replaces it with valid Teradata SQL), but it will fail if when it...
245118 Dec 2013 @ 09:07 PSTDatabaseReplyJoining tables on fields with varying lengthsI would strongly recommend to change the join-condition to a less resource-consuming and easier-to-understand INNER JOIN TABLE B ON A.ACCT_NB = TRIM(LEADIMNG '0' FROM B.ACCT_NUM) In fac...
245018 Dec 2013 @ 06:30 PSTDatabaseReplyJoining tables on fields with varying lengthsYou don't have to care about CHARs or VARCHARs, because trailing spaces simply don't matter, e.g. '0123' and '0123        ' compare equal. But the leadi...
244917 Dec 2013 @ 09:47 PSTAnalyticsReplyWhy FastLoad Does not support NUSI ?IMHO there's no need for FastLoad to support NUSIs as the target table must be empty and you can easily add an index after load. Regarding MLoad: you can load 5 tables with 32 NUSIs each using...
244817 Dec 2013 @ 09:40 PSTConnectivityReplyMac/OSx TTU or CLI Target or Release Dates? Hi Michael, i just checked the patch server and found a "MacOSX Suite" with an availability date of yesterday :-)
244717 Dec 2013 @ 08:24 PSTDatabaseReplyMultiple Grand TotalsHi Bill, almost any reporting tool should be able to do what you want, but why changing it when it suits you? I just wondered because such BTEQ reports used to be printed directly on that nice gr...
244617 Dec 2013 @ 08:18 PSTDatabaseReplyObjectUseCountCollectRateAll dbscontrol options are described in detail in the Utilities Volume 1 manual: Changes Take Effect After the DBS Control Record has been written.
244516 Dec 2013 @ 11:24 PSTTeradata ApplicationsReplyLimit on a table@Raja: Temporal will not help in that case as deleting rows will not remove them from the table, but update them to closed.   @Sankalp:  How do you determine which rows to be moved? I...
244416 Dec 2013 @ 11:00 PSTDatabaseReplyMultiple Grand TotalsHi Bill, there's only one grand total. But when you need multiple aggregates on the same level you can simply delimit them by comma: with sum(RACK_UNITS)(title 'Total Rack Units:')...
244315 Dec 2013 @ 11:58 PSTDatabaseReplyDelete or Drop a table if it already existsYou can't do that in SQLA 12, you have to use BTEQ instead or maybe unchecking "Stop query execution if an SQL error occurs" in the query options helps.
244215 Dec 2013 @ 11:55 PSTDatabaseReplyWhy teradata does not give access to statistics views in dbc by default?What is your TD release? You can always get detailed stats for a table using HELP STATS table plus HELP STATS table COLUMN xy up to 13.10 and SHOW STATS VALUES ON table in 14. Which system views ...
244115 Dec 2013 @ 11:51 PSTDatabaseReplyHow to go last week of end date ?Did you reading/answer the old post instead of opening a new one? Why do you use a very old version, 12.0.0.03, which is definitely no production system? dayofweek is based on a week starting on ...
244015 Dec 2013 @ 10:50 PSTDatabaseReplyFastLoad lock TypeIt's not an exclusive lock, but a special lock in the table header preventing any SQL access until it's release by an END LOADING.
243915 Dec 2013 @ 10:46 PSTDatabaseReplySyntax error: expected something between '(' and the 'current_date' keyword.When you're on TD13.10 you can use a SQL UDF, otherwise simply use the calculation: REPLACE FUNCTION WEEK_BEGIN(cdate DATE) RETURNS DATE SPECIFIC week_begin_DA RETURNS NULL ON NULL INPUT ...
243815 Dec 2013 @ 10:39 PSTAnalyticsReplyWhy UV in MLOAD?Hi Sankalp, of course the UV table is needed and any errors in this table will not pause the job (ERRLIMIT is only for the ET table).  This is a cut&paste from the MLoad manual: The sec...
243715 Dec 2013 @ 10:32 PSTDatabaseReplyHow to grant UPDATE to DBC on DBC.IDCol Tables?Hi Kawish, all important system tables are secured, nobody including DBC has rights to INSERT/UPDATE/DELETE/DROP them. This is done to protect the system from getting damaged. There's no...
243613 Dec 2013 @ 05:59 PSTDatabaseReplyvproc typesHi Raja, may i know what is the 6th type? I thought there are only 5 :-) AMP, PE, GTW, RSG and TVS. Type 6 and 7 are currently not used.
243513 Dec 2013 @ 04:25 PSTDatabaseReplyDelete or Drop a table if it already existsHi koushiksaha83, the article is called "What's new in Teradata SQL Assistant 13.10" and you're SQLA version is 12 :-)
243413 Dec 2013 @ 04:22 PSTDatabaseReplyfind Percentage select apple, 100 * count(*) / sum(count(*)) over () from a group by apple  
243312 Dec 2013 @ 02:31 PSTAnalyticsReplyRound Up and Round to Nearest?Hi jprakash025, did you actually read the answer to your post two days ago asking the same question?
243212 Dec 2013 @ 09:51 PSTDatabaseReplySyntax error: expected something between '(' and the 'current_date' keyword.There's no dayofweek function in SQL, you probably run this query from SQL Assistant using ODBC and the ODBC driver replaced it with valid Teradata SQL, but this is not done in Derived Tables o...
243110 Dec 2013 @ 05:26 PSTDatabaseReplyUTF -8 or UTF-16?Hi Nishant, UNICODE in Teradata is always stored as UTF-16, i.e. two bytes per character. In 13.10 there's COMPRESS USING TransUnicodeToUTF8 DECOMPRESS USING TransUTF8ToUnicode to change inte...
243007 Dec 2013 @ 02:19 PSTDatabaseReplyDefault date column not aligning in xcelHi uco, the sample data is not from a file created by BTEQ, a FORMAT 'DD/MM/YYYY' will never create single digit month/day values. When you import the data into Excel it will automat...
242907 Dec 2013 @ 02:13 PSTAnalyticsReplyMerge Joining on non-indexed column.There's no situation where a Merge join is unavoidable :-) Merge Join is only one possible way for the optimizer to do a join, there are always others like Product or Hash Join. But stats on ...

Pages