11 | 28 Feb 2013 @ 06:14 PST | Database | Reply | Will 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.
|
10 | 27 Feb 2013 @ 04:54 PST | Teradata Applications | Reply | inserting string value in to table | The 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 ... |
9 | 26 Feb 2013 @ 05:02 PST | Database | Reply | Command Help : Alter table modify column | Pretty Simple.
ADD command would be used to alter the datatype of the existing field.
ALTER TABLE <DatabaseName>.<TableName>
ADD <ExistingColumnName> <New Data ... |
8 | 26 Feb 2013 @ 04:57 PST | Database | Reply | I 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.
... |
7 | 17 Sep 2012 @ 03:39 PDT | General | Reply | File export from BTEQ | Much 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... |
6 | 29 Feb 2012 @ 06:23 PST | General | Reply | Which 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.... |
5 | 29 Feb 2012 @ 05:40 PST | Tools | Reply | Update and Insert inside a CASE |
You cannot use insert and update in case statement!!
You have to use stored procedure/macros to achieve this!!
|
4 | 29 Feb 2012 @ 04:18 PST | Database | Reply | translate 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
|
3 | 01 Nov 2010 @ 12:00 PDT | UDA | Reply | SQL 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... |
2 | 31 Oct 2010 @ 11:25 PDT | UDA | Reply | alter table modify primary index to unique primary index | Hi 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... |
1 | 30 Oct 2010 @ 01:37 PDT | Database | Reply | 10065 WSA E HostUnreach | I 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... |