#DateForumTypeThreadPost
2006 Jul 2016 @ 02:27 PDTDatabaseReplyDecimal ValueThanks Carlos.... Also, is this the default format of Decimal data type to store the value Thanks, Vinay
1905 Jul 2016 @ 11:48 PDTDatabaseTopicDecimal ValueHi,      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 ...
1815 Dec 2015 @ 12:53 PSTGeneralReplyInsert is taking so much timeThanks for your reply Bjorn. I'm using multiset table only and when I checked for skewing, it's not skewed. 
1713 Dec 2015 @ 10:00 PSTGeneralTopicInsert is taking so much timeHi,    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...
1608 Oct 2015 @ 01:42 PDTGeneralReplyTuning the SQL queryHi,   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 ...
1514 Sep 2015 @ 09:44 PDTGeneralTopicTuning the SQL queryHi,    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...
1419 Aug 2015 @ 09:30 PDTToolsTopicFastload Script without Drop and Create tableHi, 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 ...
1314 Jul 2015 @ 10:31 PDTGeneralTopicConcatenating null with a valueHi, 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.  
1203 Jun 2015 @ 11:45 PDTGeneralTopicAverage 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...
1128 May 2015 @ 11:46 PDTDatabaseTopicFinding Leap year in TeradataHi, Is there any built-in function to find Leap year in teradata?   Thanks, Vinay.
1016 Apr 2015 @ 04:21 PDTGeneralTopicIs 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 ...
906 Mar 2015 @ 07:56 PSTToolsReplyTPT LoadingThanks 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.
804 Mar 2015 @ 11:04 PSTToolsReplyTPT LoadingHi 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...
704 Mar 2015 @ 05:29 PSTToolsTopicTPT LoadingHi,     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 ...
601 Mar 2015 @ 09:03 PSTToolsReplyBTEQ field separator.Ya now its working fine..... Thanks for your help Fred and Satyanarayana.....
527 Feb 2015 @ 05:35 PSTToolsTopicBTEQ 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 ...
428 Jan 2015 @ 03:47 PSTGeneralTopicIs 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 ...
330 Dec 2014 @ 10:27 PSTGeneralTopicLoading data from Netezza table to Teradata table using TPTHi,   Is it possible to load the data from Netezza table to Teradata table using TPT script?   Thanks, Vigneshwar.
218 Dec 2014 @ 08:21 PSTGeneralReplyRunning Teradata Script in UnixThanks for your help Raja. And one more clarification is it possible to write this in TDSQL?
118 Dec 2014 @ 03:18 PSTGeneralTopicRunning Teradata Script in UnixHi,    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 "...