#DateForumTypeThreadPost
1402 Dec 2015 @ 11:46 PSTTeradata StudioReplyNumber of sessions logged on for one connection in Teradata studioThanks fgrimmer !!
1301 Dec 2015 @ 05:12 PSTTeradata StudioTopicNumber of sessions logged on for one connection in Teradata studioHello, I wanted to know if there is a way to limit the Number of sessions logged on for one connection in Teradata studio. Since I have noticed that if a userA logs in using teradata studio,...
1220 Aug 2015 @ 05:01 PDTDatabaseReplyIncreased Spool Space Utilization after UpgradeWould be worthwhile to check if you do have any missing/stale stats which might cause a different query plan for the same query .
1122 Jun 2015 @ 01:33 PDTExtensibilityReplyXPATH query Hi Folks, Just following up, does anyone have a working example of a query using SYSXML.XPATH_SHREDV function ?  
1018 Jun 2015 @ 03:16 PDTExtensibilityTopicXPATH query Hi, I have installed xml services for teradata 14.00, however i am getting a function does not exists error for SYSXML.XPATH_SHREDV function and I believe its because there may be something wrong ...
926 Apr 2013 @ 09:00 PDTDatabaseReplyODBC TO UTF8go to ODBC DSN, configure, at the bottom of the window you will have a drop down for "session character set" where you can set it up to utf8.   Cheers HP
826 Apr 2013 @ 08:55 PDTDatabaseReplyFind the value of the latest datehow about select top 1 Event_Date from table cheers HP
726 Apr 2013 @ 08:35 PDTUDAReplypulling all the tables and Views not using in prod since from long time in teradata will only createdate serve your purpose ?
626 Apr 2013 @ 08:27 PDTConnectivityReplyODBC Socket Error in some Informatica SessionsI was finally able to get the reason, it was due to a bad switch (Network), where in we were having pack loss. the issue was resolved when the switch bios was upgraded. Thanks HP
522 Feb 2013 @ 04:56 PSTConnectivityTopicODBC Socket Error in some Informatica SessionsHello,   Since past one month, we are getting the error below in some of our informatica sessions during the daily load.  013-02-22 02:11:10 : ERROR : (15655 | PRE-SESS) : (IS | IS_NAM...
427 Jul 2012 @ 11:24 PDTGeneralReplyCopy DB with ArcMain I am getting the same error, However there is a workaround to this, which is prepare the arc script with tablenames, instead of dbname. Please let me know if anyone has figured this one out ....
326 Feb 2012 @ 11:12 PSTDatabaseReplymillisecond part is stripped from time(6) column Hi Ulrich,   Yes the above query works for me in bteq, however i am not able to see the same results in sql Assistant. the millisecond part is not visible in sql assistant. ...
225 Feb 2012 @ 05:30 PSTDatabaseReplymillisecond part is stripped from time(6) column Hi Ulrich, Thanks for your reply,  My requirement is to load TIME datatype, and not the timestamp,   so if you try the script below, does it work for you   --d...
124 Feb 2012 @ 11:49 PSTDatabaseTopicmillisecond part is stripped from time(6) column Hi Experts, I am trying to load a column of datatype time(6), however when I load it with say value like 20:59:57.154   i get only 20:59:57 when i select and the millisecond...