#DateForumTypeThreadPost
1128 Feb 2013 @ 06:14 PSTDatabaseReplyWill volatile tables be dropped?As you said you have not mentioned the number of volatile tables you are trying to create in that SP. As far as i know, 64 volatile tables can be created at one time.     
1027 Feb 2013 @ 04:54 PSTTeradata ApplicationsReplyinserting string value in to tableThe Single quote after digit 9 is causing the issue becuse string terminates there due to that. Either remove it or add one more if one single quote is needed. Insert into Tab1 (Col1,COl2) Values ...
926 Feb 2013 @ 05:02 PSTDatabaseReplyCommand Help : Alter table modify columnPretty Simple. ADD command would be used to alter the datatype of the existing field.   ALTER TABLE <DatabaseName>.<TableName> ADD <ExistingColumnName> <New Data ...
826 Feb 2013 @ 04:57 PSTDatabaseReplyI need to add starbox comments to table DDL. Works with view DDL, but not table DDL.Hi Agrias,   I am not sure about the earlier versions, We are using 13.10, dbc.Tables stores last run of the definitions including the starbox comments in Request_Text Column.   ...
717 Sep 2012 @ 03:39 PDTGeneralReplyFile export from BTEQMuch appropriate way of doing this is to check the file if it exists.    -- If condition to check if the files exists; If it does then remove it. .OS IF [ -f directlry_Path/XYX.txt]; t...
629 Feb 2012 @ 06:23 PSTGeneralReplyWhich is better GROUP BY, DISTINCT or SET table Performance varies depending on the data. DISTINCT is better when the data is nearly unique. actually when distinct is used; the intermediate spool is sorted and discards the duplicates....
529 Feb 2012 @ 05:40 PSTToolsReplyUpdate and Insert inside a CASE You cannot use insert and update in case statement!! You have to use stored procedure/macros to achieve this!!
429 Feb 2012 @ 04:18 PSTDatabaseReplytranslate join on two conditions to a select statement   Here you go mate.   Select ID,Rep_date from emp qualify row_number() over (partition by id order by rep_date asc) = 1
301 Nov 2010 @ 12:00 PDTUDAReplySQL Query to modify a column datatype lenght.!!!Here is the solution To Modify the a column type, length or format, we use ADD function in Teradata ALTER TABLE Table_Name ADD Existing_Column_Name New_Data_Type(New_Length) Above query w...
231 Oct 2010 @ 11:25 PDTUDAReplyalter table modify primary index to unique primary indexHi Ramvenky, Here you have to consider few things. You can always change the UNIQUE PRIMARY INDEX to PRIMARY INDEX no matter the table is populated or not using the following statement ALTER...
130 Oct 2010 @ 01:37 PDTDatabaseReply10065 WSA E HostUnreachI was facing the same problem. Tried all the possibilities mentioned above. It didn't work out. I was unable to start Teradata Database Initiator service. Atlast i got to know that recently ins...