#DateForumTypeThreadPost
5909 Aug 2010 @ 10:19 PDTDatabaseReplyCharacter field Cleanup routinesWhat character are you trying to remove with '1A'XC? '0A'XC is CR whereas '1A'XC is SUB (substitute) and appears unacceptable in a LATIN character set.
5803 Aug 2010 @ 06:15 PDTDatabaseReplyNumeric overflow occurred during computation?The explanation for your first example can be found in the SQL Reference: Functions and Operators on page 47 and footnote 7 on page 48. I will try my best to summarize my interpretation here: I...
5703 Aug 2010 @ 05:38 PDTDatabaseReplyFREE copy of a Fully functional Teradata Database Demo CDSettu, try here: http://www.teradata.com/t/teradata-express/
5602 Aug 2010 @ 07:16 PDTDatabaseReplyCharacter field Cleanup routinesA UDF would probably be the best option for an in-database solution. The Oracle UDF library (available for download from Teradata's main website) may contain some string manipulation functions that...
5502 Aug 2010 @ 06:53 PDTDatabaseReplySQL HistoryFlavien, the point was your client's DBA (unless that's you) should be doing that already if they are using DBQL to log the systems query workload. Then using views of the DBC DBQL tables you shoul...
5429 Jul 2010 @ 11:46 PDTGeneralReplyTeradata Load UtilitiesThanks for the clarification Mark about the availability of only patched versions of Teradata software on Teradata @ Your Service.
5327 Jul 2010 @ 09:20 PDTDatabaseReplyHow to monitor Database Diskspace UsageFirst, your database may continue to show there is space available even though an attempt to insert records into a table fails with inadequate space. The first AMP to reach its perm limit will resu...
5227 Jul 2010 @ 09:07 PDTDatabaseReplySQL HistoryThe recommended practice is for DBQL data to be regularly moved to a historical database that is designed to facilitate analytical queries of the data (e.g. compression and multilevel PPI) and purg...
5127 Jul 2010 @ 08:55 PDTGeneralReplyTeradata Load UtilitiesYou will need an account and sufficient privileges set by your site administrator on Teradata's At Your Service in order to download them. There is a link available on Teradata's homepage under the...
5014 Jul 2010 @ 12:07 PDTDatabaseReplyJoin where second table has dupes!Try this: INSERT INTO STORY_OUT_TMP SELECT FROM STORY_OUT O INNER JOIN CSA C ON C.Cust_ID = O.Cust_Id AND C.Cust_Typ = O.Cust_Typ AND C.Field_Nm = 'PARTY_NAME';
4913 Jul 2010 @ 11:59 PDTDatabaseReplyReg Database viewAt a very high level: (1) A view database can be created with no (or very little) perm space. (e.g. MyViewDB) (2) Create your views as REPLACE VIEW MyViewDB.View1 AS SELECT ... FROM .... ; (3)...
4813 Jul 2010 @ 11:08 PDTDatabaseReplyIndex Privilege on DBC tablesNot permissible with DBC.Accessrights without likely involving GSC. DBC does not have the necessary permissions to grant itself the rights needed to perform the GRANT to the role in questions. ...
4713 Jul 2010 @ 10:47 PDTToolsReplymloading of single table with multiple fileGood to know Carlos. Thanks!
4613 Jul 2010 @ 06:24 PDTToolsReplyfastload insertion You should be able to do the date manipulations in the FastLoad script. Have you tried: INSERT INTO target VALUES (:Field1, :Field2, :Date1, ADD_MONTHS(:Date1, 2), CASE WHEN EXTRACT MONTH FROM :...
4513 Jul 2010 @ 06:20 PDTToolsReplymloading of single table with multiple fileMultiple .IMPORT commands should be handled sequentially.
4412 Jul 2010 @ 06:55 PDTDatabaseReplyPlease help me with the sum functionYou can do a Group Sum using the SUM() OVER(PARTITION BY Product_ID) window aggregate. However, your example indicates that the Total_Sales Column is a Cumulative Sum. The derivation to Sum(Total_S...
4312 Jul 2010 @ 06:11 PDTDatabaseReplyDay-to-Day DBA TaskAlex those tasks are common across database platforms. However, Teradata DBA's generally do not have to concern themselves with operating system level tasks, file segments, index (de)fragmentation,...
4212 Jul 2010 @ 06:00 PDTDatabaseReplyHelp Neeed: conditional execution in macroIf tab1 and tab2 are related and can be joined you may be able to use a CASE statement to handle this inside your macro: SELECT CASE WHEN :ID = 2 THEN tab1.col1 ELSE tab2.col1 END AS col1_ ,...
4102 Jul 2010 @ 06:16 PDTDatabaseReplytable size without indexesIndex space is included in the DBC.TableSize. The exact formulas for calculating index sizes are found in Chapter 15 of the Database Design manual. Can can use (8 * Table Cardinality) to get a roug...
4002 Jul 2010 @ 05:29 PDTDatabaseReplyimprove peformance by using functions instead of coalesceAre you qualifying on the result of the COALESCE? SELECT COUNT(*) FROM view WHERE dt_1 = DATE '1980-01-01' The trouble with the SQL statement above is that the optimizer may not have leverag...
3902 Jul 2010 @ 05:22 PDTDatabaseReplyProblem getting sample records using "top"Have you tried SAMPLE? While TOP is designed for speed it may be overloading a single (or a couple) AMP causing your spool to skew by going to a few AMPs to get the data. SAMPLE would almost ce...
3802 Jul 2010 @ 05:15 PDTDatabaseReplyImport Teradata Backup in to SQL ServerI would have to agree with Dieter on this one. There is a SQL Sever connector from a third party available to facilitate data migrations between the two environments or you could export the dat...
3730 Jun 2010 @ 10:49 PDTDatabaseReplyHow to make a dump in Teradata ?The DUMP accessright allows the user the ability to issue the ARCHIVE command in ARCMAIN. DUMP is an alias to ARCHIVE. So to answer your question as written, you would use the ARCMAIN utility to...
3630 Jun 2010 @ 09:07 PDTDatabaseReplyDnoeth...Need help!!While not as fast as the "fast" option, you could build a FastExport that builds your MultiLoad script for you to save some development time. Then you simply have to write the SELECT statement for ...
3530 Jun 2010 @ 08:52 PDTDatabaseReplyCollect StatsGoogle "dieter noeth stats view" (dnoeth here on these forums) and you will find some very handy SQL that can be used to create your own stats maintenance routine. With it you can easily identify w...

Pages