All forum activity

#DateUserForumTypeThreadPost
5954431 Aug 2016 @ 06:14 PDTSGITDatabaseReplySet multiple variable in one case statement Could you elaborate on how a SP could do the above?
5954331 Aug 2016 @ 04:53 PDTromanowwTeradata StudioTopicNeed to reinstall Studio Express 15.10.1 (last working version): where to find it?I've read about the Teradata Patch Server but have no idea how to reach it.   Could anyone tell me where to find a version of Studio Express 15.10.1?   Steven
5954231 Aug 2016 @ 03:34 PDTAkshay.ShahaDatabaseReplyUpdating second row value to new column first rowHi,   Is RN column part of your table? If yes, then below query should do :   MERGE INTO tab A USING (     SELECT id , col2 FROM tab WHERE rn = 2 ) B (id,col2) ON (A.id ...
5954131 Aug 2016 @ 03:13 PDTdnoethDatabaseReplyequivalent function for Month(); DateAdd()Hi Patrick, the Standard SQL way would be EXTRACT(MONTH FROM col), but you better avoid functions on both sides of a comparison:  Where Date_attribut between TRUNC(CURRENT_DATE, 'mon&#...
5954031 Aug 2016 @ 02:36 PDTdnoethDatabaseReplyWhy does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop?Hi Subhayu,  you simply install the Teradata Client for Windows: TTU - Windows Install
5953931 Aug 2016 @ 02:03 PDTjabbarahmedGeneralTopicConverting varchar into timestampCan someone please give me the exact code to convert the following varchar data into a teradata recognised timestamp format. I have searched through existing topics but have not found an ...
5953831 Aug 2016 @ 12:47 PDTplechatDatabaseTopicequivalent function for Month(); DateAdd()Hello, i want my sql script to automatically query the last month (first to last day) in the database. Like if i am in august 2016 (the day doesn't matter), the query will pick all datas...
5953731 Aug 2016 @ 12:02 PDTvinolinConnectivityReplyhow to install teradata express edition on windows 7Can anyone clearly say the prerequisites software for installing teradata database in windows 7, 32 -bit and i used use that DB to store xml files inside the DB using java via netbeans is that poss...
5953630 Aug 2016 @ 11:58 PDTCarlosALDatabaseReplySet multiple variable in one case statement Hi. What does it mean "Teradata code"? bteq script? Stored Procedure? Other? CASE (SQL) won't work this way, maybe a SP will. Cheers. Carlos.
5953530 Aug 2016 @ 10:36 PDTJohannes VinkToolsReplyCan TTU 14.10 on Linux connect on a15.10 RDBMSInformatica 9.6.1 probably? Some story here. TTU 14.10 is 2 versions upward compatible (excluding new features in newer versions ofcourse). So 15.00 and 15.10 are supported, but 16.00 (not out yet)...
5953430 Aug 2016 @ 09:51 PDTsubhayuDatabaseReplyWhy does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop?Hi Dieter, That answers. Thanks! I was not aware that Teradata is not available for Windows. So what if we have a requirement for handshaking between a MSBI stack and Teradata? Say, TD needs to r...
5953330 Aug 2016 @ 07:07 PDTjingguoToolsReplyfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."Hi SteveF, Thanks for your reply. It works. Another questions: if I have the delimiter as "DEL" or ^P or 0x10, how do I write "SET RECORD VARTEXT"? Is there a mapping somewhe...
5953230 Aug 2016 @ 06:10 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityTom, what would be the next steps for this?  Is there another system I should be putting this request into?  How would I track when it is likely to be resolved and a patch provided?  ...
5953130 Aug 2016 @ 05:23 PDTgsTeradata StudioReplyViews the rows being transferred overFrancine,  Looks like you responded to my post but since I am new to the site, I don't see my post.  That is not the case, the file is deleted even when the load fails midway throug...
5953030 Aug 2016 @ 04:17 PDTfgrimmerTeradata StudioReplyViews the rows being transferred overRavindra, The file is created before loading and if Studio finds no errors then the empty error file is deleted.
5952930 Aug 2016 @ 03:55 PDTgsTeradata StudioReplyViews the rows being transferred overFrancine, I have similar issue while loading smaller files - I am unable to see the error file in the same directory.  As I alluded in my earlier post, it gets created beginning of load and d...
5952830 Aug 2016 @ 03:35 PDTgsTeradata StudioReplyConfigurer Data Transfer Error FilesDear All, Pardon any errors of omission or commission from my first post to a forum. Any help greatly appreciated. Followed Francine's advice with Teradata Studio version 15.10 - I specified ...
5952730 Aug 2016 @ 02:41 PDTGlassDatabaseReplyReplacing tableIf emp exists your query will fail. To replace , drop old first.   Rlgass
5952630 Aug 2016 @ 01:51 PDTCvinodhToolsTopicTDCH Export from HDFS timestamp issue.I am loading a file from HDFS into Teradata using Teradata Hadoop connector. All my records are getting rejected due to error code 6760 (invalid timestamp). All the timestamp fields are of format y...
5952530 Aug 2016 @ 11:40 PDTSGITDatabaseTopicSet multiple variable in one case statement Hello,    I am converting some SAS code to TD : In SAS you can set multiple variables within a single case statement. Can we do the same in TD? Thanks in advance if RFRL_SRC_CD = &#...
5952430 Aug 2016 @ 11:30 PDTGNSToolsTopicCan TTU 14.10 on Linux connect on a15.10 RDBMSHello,   I am working with an Informatica application where the most recent TTU supported is 14.10. The Teradata RDBMS will be upgraded to 15.10. Could you let me know if the  TTU and ...
5952330 Aug 2016 @ 11:04 PDTIvyuanToolsReplyFastExport Remove Binary/Indicator Values in Outmod Hi, There are some sample OUTMOD routines in Teradata FastExport manual(B035-2410) Appendix C. Thanks!  
5952230 Aug 2016 @ 10:47 PDTIvyuanToolsReplyError Table MloadHi, Here is related information on 2665: 2665 Invalid date. Explanation: This error occurs when date arithmetic is attempted on an invalid date. Generated By: AMP Steps. For Whom: End User....
5952130 Aug 2016 @ 10:33 PDTSGITDatabaseTopicReplacing tableHello,   In SAS if a new table A is created using the table A itself, the new table will overwrite the old. Can you pl let me know if same is the case in TD. -   create volatile ...
5952030 Aug 2016 @ 10:13 PDTmissgateAnalyticsReplyIS-NUMERIC functions I know is to late.   Regex could be a good option. Consider the value is not a number then a default value can set and the "SQLSTATE 22023 Invalid character x in number str...

Pages