20 | 06 Jul 2016 @ 02:27 PDT | Database | Reply | Decimal Value | Thanks Carlos.... Also, is this the default format of Decimal data type to store the value
Thanks,
Vinay |
19 | 05 Jul 2016 @ 11:48 PDT | Database | Topic | Decimal Value | Hi,
I created a column with datatype Decimal(15,2) and when I store the value 0.00 in that column, its storing as .00. So, is there any way to store my value 0.00 as it is in ... |
18 | 15 Dec 2015 @ 12:53 PST | General | Reply | Insert is taking so much time | Thanks for your reply Bjorn. I'm using multiset table only and when I checked for skewing, it's not skewed.
|
17 | 13 Dec 2015 @ 10:00 PST | General | Topic | Insert is taking so much time | Hi,
I'm running a insert query which inserts data in 30 iterations. After 16 iterations the record count in the target table is 3 billion. The 17th iteration is taking alomst 7 ho... |
16 | 08 Oct 2015 @ 01:42 PDT | General | Reply | Tuning the SQL query | Hi,
This is the explain plan I got:
1) First, we lock a distinct QA_RMAP_1."pseudo table" for read on a
RowHash to prevent global deadlock for
... |
15 | 14 Sep 2015 @ 09:44 PDT | General | Topic | Tuning the SQL query | Hi,
I have a multiset volatile table having 10k records and a table having 5 billion records. I have to create a multiset volatile table by inner joining these two tables. But, the qu... |
14 | 19 Aug 2015 @ 09:30 PDT | Tools | Topic | Fastload Script without Drop and Create table | Hi,
In our fastload script, actually we are dropping the Table and again creating it.
Sample :
.logon tdpid/tduser,tdpassword
Drop table dbname.tblname
Drop table dbname.errtblname1
Drop ... |
13 | 14 Jul 2015 @ 10:31 PDT | General | Topic | Concatenating null with a value | Hi,
I have a null column and I'm concatenating that null column with a column has some values. But my output is null. Is there any way to overcome this?
Thanks,
Vinay.
|
12 | 03 Jun 2015 @ 11:45 PDT | General | Topic | Average value difference in BTEQ and Teradata SQL Assistant. | Hi,
I'm running a query to find the average in BTEQ and its datatype is Decimal(10,2). If my original result value is 51.5065, BTEQ returns the value as 51.50 and when I run the same q... |
11 | 28 May 2015 @ 11:46 PDT | Database | Topic | Finding Leap year in Teradata | Hi,
Is there any built-in function to find Leap year in teradata?
Thanks,
Vinay.
|
10 | 16 Apr 2015 @ 04:21 PDT | General | Topic | Is it possible to do arithmetic operations inside SUBSTR? | Hi,
In my Teradata script, I'm using SUBSTR(columnname,1,(character_length(columnname)-4)). But, I'm getting the error as "2662 SUBSTR: string subscript out ... |
9 | 06 Mar 2015 @ 07:56 PST | Tools | Reply | TPT Loading | Thanks Steve. I tried with the sample data of 10 records having the date value as 05JAN2003, but all these 10 records were sent to Error file.
--Vinay.
|
8 | 04 Mar 2015 @ 11:04 PST | Tools | Reply | TPT Loading | Hi Dieter,
I'm using 15.00 version and when I specify this in define schema, I got this error.
TPT10674 Error: Unrecognized MONTH string in data row.
My input file data is like 05J... |
7 | 04 Mar 2015 @ 05:29 PST | Tools | Topic | TPT Loading | Hi,
I'm trying to load data from External delimitted file using TPT. One of my columns in the delimitted file contains the as '24FEB2015'(DDMONYYYY) format. I need ... |
6 | 01 Mar 2015 @ 09:03 PST | Tools | Reply | BTEQ field separator. | Ya now its working fine..... Thanks for your help Fred and Satyanarayana.....
|
5 | 27 Feb 2015 @ 05:35 PST | Tools | Topic | BTEQ field separator. | Hi,
In my BTEQ statement, I'm selecting two columns of a table and using this statement .SET SEPARATOR "|" and I'm exporting the output to local file. When I check that file only one column ... |
4 | 28 Jan 2015 @ 03:47 PST | General | Topic | Is it possible to use accented i in TPT text delimiter? | Hi,
I'm using delimitted file as a source to Teradata. In my TPT script, when I mention the Text delimitter as accented i, it is not working. So, is it possible to ... |
3 | 30 Dec 2014 @ 10:27 PST | General | Topic | Loading data from Netezza table to Teradata table using TPT | Hi,
Is it possible to load the data from Netezza table to Teradata table using TPT script?
Thanks,
Vigneshwar.
|
2 | 18 Dec 2014 @ 08:21 PST | General | Reply | Running Teradata Script in Unix | Thanks for your help Raja.
And one more clarification is it possible to write this in TDSQL?
|
1 | 18 Dec 2014 @ 03:18 PST | General | Topic | Running Teradata Script in Unix | Hi,
I'm new to Teradata. We can run the Netezza SQL in Unix by using "nzsql" command.
nzsql -host hostname -u username -pw password -db Databasename -c "... |