#DateForumTypeThreadPost
1005 Feb 2015 @ 11:16 PSTDatabaseReplyRounding: Result of division being forced to .000Hi, You can acheive this by increasing the decimal digits, and casting either numerator or denominator to decimal, instead of casting the fraction. select ((CUPDAct/CAST(CityDelHrsAct AS DECIMA...
905 Feb 2015 @ 10:46 PSTDatabaseReplyMulti-Table Insert StatementsHi, You will need to create a stored procedure to acheive this in Teradata. create procedure my_proc() begin for st1 as cur cursor for ( select account_no ...
805 Feb 2015 @ 09:58 PSTDatabaseReply[Teradata Database] Numeric overflow occurred during computation.Unable to get catalog string. Connection StringHi, It should be  count(cast(a.userid as bigint)) But, it is strange that your table has only 468 records, and you are getting this error! May be your "tblDate" is huge? Rega...
705 Feb 2015 @ 09:51 PSTDatabaseReply expected something between the word 'xx' and ','.Unable to get..Hi, I think you are trying something like this..? select a12.xx xx, a12.bb bb from (select a11.zz xx, CASE WHEN substr(a11.zz, 2, 1) between '0' and '9' THEN substr(a11.z...
621 Jan 2015 @ 11:12 PSTDatabaseReplyTPT Table Load /**************************************************************/ /* */ /* Teradata Parallel Transporter ...
521 Jan 2015 @ 11:09 PSTDatabaseReplyTPT Table LoadHi, While creating your TPT load table, you have not explicitly specified the primary index column. In this case, Teradata takes the first column as primary index. As such, your TPT load table is ...
418 Jan 2015 @ 02:56 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsHi,   #Option 1 Since you are dynamically generating unique values in UPI column, it is better if you can re-create your table by defining UPI column as an identity column. However, the nu...
317 Jan 2015 @ 11:35 PSTDatabaseReplyTPT Table LoadHi, Is your TPT load table defined as a NoPI table? If not, is the primary index on TPT loaded table same as the primary index on final table? Make sure that the values you are trying...
210 Jan 2015 @ 04:22 PSTDatabaseReplyHow to create a loopYes, the query that Deiter has posted will work. I was just about to correct my query from 1 preceding to unbounded preceding select year_column ,week ,product_A ...
110 Jan 2015 @ 03:57 PSTDatabaseReplyHow to create a loop select         year_column        ,week        ,product_A        ,...