#DateForumTypeThreadPost
31204 Apr 2014 @ 02:55 PDTToolsReplyUSE OF SERIALIZE ON in TPumpIn a summary SERIALIZE option is used to synchronize the locking between multiple sessions. With this feature one session can lock/block all rows related to a certain PI(rowhash), so will avoiding ...
31104 Apr 2014 @ 12:15 PDTPrivate Forum
31004 Apr 2014 @ 12:09 PDTAnalyticsReplyCastThe syntax of the query seems fine. There seems to be some invalid data in the date column and thus failing the cast statement.
30903 Apr 2014 @ 04:17 PDTUDAReplyLoading Unicode data from Oracle to teradataIf I remember correctly, there are ODBC properties and change the encoding/character set and you can view the resultset in SQL Assistant. Its only the display problem becasue the SQLA is not able t...
30803 Apr 2014 @ 12:58 PDTGeneralReplyUnable to import data from notepad or csv fileYou using any Teradata utilities or importing from SQL Assistant directly?
30703 Apr 2014 @ 12:55 PDTPrivate Forum
30603 Apr 2014 @ 12:40 PDTPrivate Forum
30502 Apr 2014 @ 11:22 PDTUDAReplyUsing qualify and group by togetherI believe Group by and Qualify can be used together in a single query... You don't need to encapsulate in the subquery. your sequence of the clause is generating the error. This query should w...
30402 Apr 2014 @ 07:57 PDTGeneralReplyHow we can replicate Tables structures between 2 teradata servers ?I guess there is no direct way to compare the DDLs between two different TD servers. You can export the table definitions from both servers and using unix can find the difference in the DDLs. More...
30302 Apr 2014 @ 07:52 PDTGeneralReplyTeradata in any Retail Stores in AustraliaCheck the teradata website. You should be able to find something in the customer's list...
30202 Apr 2014 @ 07:50 PDTGeneralReplyConvert free text date to 'MMDDYYYY' format You can't do that in one simple SQL. You have to cast the text and there is only one format that you can define while casting.  You probably need to write some routine (SP or UDF) to get ...
30102 Apr 2014 @ 07:48 PDTGeneralReplyRun Derived table queryI think you mistyped the query as pa12 is not a valid query block, and thus your whole query is not a valid one! This is what pa12 looks to me from your above query where ((a12.DedID = 809 a...
30002 Apr 2014 @ 07:17 PDTDatabaseReplyRow logging into ET tableCan you share your fastload script?
29902 Apr 2014 @ 07:16 PDTDatabaseReplyHelp me to get the backup of ONLY DBC tables DDL (Not data).To recover from disaster you will need a lot more than the DDLs of dbc, but anyways you can do the dictionary tables archival using the arcmain utility and restore it when required. The below scri...
29802 Apr 2014 @ 06:59 PDTDatabaseReplyTo UNION OR Not to UNIONDid you try UNION ALL, It should be faster as there is no extra processing required to remove the duplicate rows which UNION does. You are already selecting unique rows from both the resultset (wor...
29717 Dec 2013 @ 03:34 PSTDatabaseReplyhelp required for a update scenarioConsidering you have a table that maintains the group and primary customer relationship within that group, you can execute the below mentioned query to get the desired results. CUSTMOER_GROUP shou...
29617 Dec 2013 @ 01:31 PSTDatabaseReplyWhy explain plan is so offThe optimizer doesn't always needs stats to give estimates. If full stats are collected and available, then the optimzer will give you realistic estimates, else if the full stats are not collec...
29515 Dec 2013 @ 10:02 PSTTrainingReplyteradata training What sort of learning you are seeking?
29415 Dec 2013 @ 09:55 PSTDatabaseReplyhelp required for a update scenarioSo basically what I understand is that you need to update certain customer groups data only if the primary customers data within that customer group exists... Is that correct?
29314 Dec 2013 @ 11:22 PSTGeneralReplyTeradata Certification re-take policyretake allowed after 21 days...
29214 Dec 2013 @ 11:05 PSTDatabaseReplyset table with sum vs multiset with no sumMy two cents... Consider the index selections is same for both set and multiset cases. The multiset would be faster as there is no extra processing even checking the duplicate rows is not required...
29114 Dec 2013 @ 10:17 PSTDatabaseReplyNumeric overflow computation errorBTW you are multiplying DECIMAL(8,4) * DECIMAL(3,3) * DECIMAL(5,2). So I think your result should be DECIMAL(16,9) or something like that. MAXDECIMAL flag in DBSControl also controls the maximum n...
29014 Dec 2013 @ 10:01 PSTDatabaseReplyNumeric overflow computation errorMay be you need to adjust the scale and precision dependin. You can refer the following article...   http://developer.teradata.com/tools/articles/how-many-digits-in-a-decimal   "...
28914 Dec 2013 @ 01:02 PSTDatabaseReplySyntax error: expected something between '(' and the 'current_date' keyword.Without looking at the data its difficult to understand what exactly is causing the issue. Share some sample data and expected output to better understand the problem in your query..
28814 Dec 2013 @ 12:58 PSTDatabaseReplyhelp required for a update scenarioReplace CUSTOMER_TEST with your table name and I hope the below query will work for you UPDATE TBLA FROM CUSTOMER_TEST TBLA, CUSTOMER_TEST TBLB, (SELECT CUSTOMER_ID FROM CUSTOMER_TEST WHERE CUS...

Pages