#DateForumTypeThreadPost
3813 Feb 2014 @ 08:17 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?DBC generally is very busy to all internal important activities of teradata. so better touch those tables as less as possible. you can see the explain plan of a create table below. you can observe...
3713 Feb 2014 @ 08:07 PSTTeradata ApplicationsReplyGetting a Error in BTEQ ImportIn the using clause why f3 and f4 are defined as char (40). Can you try making them varchar(40) .
3613 Feb 2014 @ 08:02 PSTDatabaseReplyMulti column comparisionoh..ok.. thank you.
3513 Feb 2014 @ 08:00 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?Drop and Create tables are DDL and they require Data dictionary intervention. (Inserting many rows in correspondig dictinary tables). So better write a bteq in such way to check the existance of t...
3411 Feb 2014 @ 06:48 PSTDatabaseTopicMulti column comparisionI have a requirement to do a multicolumn comparision with harcode values. as below - select col1, col2 from table where (col3,col4)  in ((1,2),(3,4)) ; --comparing two sets of values th...
3311 Feb 2014 @ 06:24 PSTDatabaseReplyTruncate a decimal field without roundingThanks Carlos. Your solution is very optimized and solved my problem .
3211 Feb 2014 @ 06:14 PSTDatabaseReplyhow to get decimal value with no roundingThanks saeed.. Carlos's solution worked for me. Thanks Kishor for suggestion .
3111 Feb 2014 @ 04:54 PSTDatabaseTopichow to get decimal value with no roundingHi, I have a requirement to get the decimal value with no rounding for a comparision purpose. when i use format and cast it is defaultly rounding. Ex:  if decimal value is 23.456, i need th...
3007 Feb 2014 @ 06:27 PSTToolsReplyMload - execute a file in batch mode, invalid statement was foundIn the demo version of TD 13.0 use below process. start->run->type 'cmd'  ==> gives you dos command prompt. At the prompt use your mload command such as - c:\> mload <...
2907 Feb 2014 @ 06:14 PSTGeneralReplyTeradata Learning MaterialsYou can gothrough below basic video to understand why teradata is suitable for Datawarehousing and it's features. Then can follow instructiond by Raja to have a good start - http://www.yo...
2807 Feb 2014 @ 06:10 PSTToolsReplyBTEQ and the Commit statementBy default in BTEQ every statment is auto commit. untill we specify .set session transaction ANSI before loggin. By seeing your script you didn't use ANSI mode so it should be defualt BTET and...
2707 Feb 2014 @ 05:47 PSTDatabaseReplySpecifying partition names for a PPINo. this option don't exist.
2631 Jan 2014 @ 04:37 PSTDatabaseReplyAutomation - Cycle through lookupIt is a new info for me. So, if we use "then =1"  would it run the same statment again if activitycount =0? in this case it is a MSR so it would run all the statments again and...
2531 Jan 2014 @ 03:17 PSTTrainingReplyTeradata View Point MaterialHi Santosh, Please try this web publication by Teradata- http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1091_111A/ch18.20.01.html   --Sri
2431 Jan 2014 @ 03:10 PSTDatabaseReplySql helpCan't understand completely.  In your final select you have a,b,c...sum().  and in the example outpu you show only 2 columns col1 and col2. can you explain what you mean by null grou...
2330 Jan 2014 @ 06:33 PSTDatabaseReplyFORMAT option in create tableYour format works fine while storing. In SQL assistant the format won't work by default in select statment. We have to explicity convert the column to varchar. In your case please try below S...
2230 Jan 2014 @ 04:11 PSTDatabaseReplySpool space and Temp space allocationsHi Dieter, do  Spool and tempspaces are unused permspace ? So only the upper limits we specify for spool and temspace for the users. Both are shared by all users if it is available under th...
2129 Jan 2014 @ 03:31 PSTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10Please try sol.  in the link - http://forums.teradata.com/forum/tools/sql-assistant-not-able-to-define-odbc-data-source-through-teradata-sql-assistant-v-13-11
2028 Jan 2014 @ 02:45 PSTDatabaseReplyAutomation - Cycle through lookupHi Dieter, I got a question in your explained approach. I know we can repeat statement for particular number times or with * till end of the imported file. Can we repeat a set of statments till ...
1928 Jan 2014 @ 02:27 PSTTrainingReplyTeradata advance training/guidance for certificationIn my opinion, spreading knowledge would help Teradata to expand the business. Teradata should give all the materials, Online documents for free to all people and can increase certification costs....
1822 Jan 2014 @ 03:36 PSTTrainingReplyTeradata DBA Traninig in Hyderabad?Thanks Prashant for your inputs!! It would help, as I am planning to take up DBA very soon. Regards, Sri.
1722 Jan 2014 @ 03:11 PSTToolsReplyTeradata SQL Assistant 7.2 install on Windows 7As 7.2 version is of 32 bit, it is not compatible to 64 bit windows 7.  You can try Sqlassistant 13.10. It is latest and good in features.   -Sri
1622 Jan 2014 @ 02:53 PSTDatabaseReplyCast-DATEThank you very much Dieter. It really helps !!! Thanks Sai for your input.  
1521 Jan 2014 @ 11:22 PSTDatabaseReplyWhich is efficient?I mean in the explain plan - the spool and number of steps required in both the ways.
1421 Jan 2014 @ 11:21 PSTDatabaseReplyWhich is efficient?Hi Prateek, In my opinion the first option is good. As you have restricted the number required columns from table b. The spool and the other resources consumed will be less. Can yo...

Pages