#DateForumTypeThreadPost
1019 Aug 2013 @ 12:10 PDTDatabaseReplyPrimary key and Primary index on a same columnHello Sachin, When you specify Primary Kay keyword inside create table, Teradata will be default consider as a Unique Primary Index. So in addition, if you specify another non unique primary inde...
912 Aug 2013 @ 01:46 PDTDatabaseReplyhelp me to group the recordssel ID,TYPE,MIN(STDT),MAX(ENDT) FROM TABLE GROUP BY 1,2 Regards, Chinmay Athavale  
804 Jul 2013 @ 11:11 PDTDatabaseReplyCASESPECIFIC What is its purpose?Hello, It seems that you are working in ANSI mode. Please not that any comparison in 'ANSI' mode is case sensitive by default, whereas Teradata mode is case insensitive. I checked your SQ...
724 Jun 2013 @ 10:07 PDTGeneralReplyinterview helpHello, Could you please mail them at: bolearning@gmail.com    
605 Jun 2013 @ 11:24 PDTDatabaseReplyAbout renaming a columnHello Kbos, Your syntax is also working fine at my end. I could rename column name with data using your synax. Regards, Chinmay
508 Apr 2013 @ 09:35 PDTDatabaseReplyCast from CHAR(20) to SMALLINTHello Sachin, I tried the syntax provided by you and it worked for me: sel name,cast (cast(name as char(6)) as smallint) from delta Regards, Chinmay Athavale
412 Feb 2013 @ 01:31 PSTToolsReplyMultiLoad instead of FastLoadThank you Dieter :-)
307 Feb 2013 @ 09:16 PSTToolsTopicMultiLoad instead of FastLoadHi All, I have got a question regarding usage of FastLoad and MultiLoad. As per my understanding and Teradata Manuals, FastLoad can only be used while loading a table for first time (Initial load...
224 Sep 2012 @ 04:53 PDTDatabaseReplyStored Procedure ErrorThank You QAKiani....it worked for me Regards, Chinmay  
120 Sep 2012 @ 10:43 PDTDatabaseTopicStored Procedure ErrorHello All, Doing some hands on stored procedure. I have created below procedure (relatively simple) but it is giving me weird error. Below are the details: Environment: Teradata 13.10 using...