#DateForumTypeThreadPost
1901 Apr 2014 @ 06:08 PDTConnectivityReplyODBC.INI Just note from my experience with ODBC..... There are many vendors of ODBC , some of them are providing default drivers for major databases by default, even with bundled drivers for each database ...
1804 Feb 2014 @ 04:42 PSTToolsReplyTeradata Parallel Transporter Wizard 14.10 IssueHi there,  we tryed TPT Wizard and I see that the *.cmd is relating to such old *.jar files (from 'java\lib' as well from 'jdbc\lib') ...  So i do not understand why: 1...
1724 Jan 2014 @ 06:14 PSTCloud ComputingReplyNo internet connection in VMWAREHi gents, I see lot of users are having very same issue. Can't connect from/to vmware machine. Can't reach internet and so on. 1.when using TD secure connection (ie anyconnect, ciscovpn, ...
1617 Jan 2014 @ 05:34 PSTDatabaseReplywhich standard is used for REGEX regular expression functions in TD14.10I tried to find out what standard TD14.10 is using, i just found it is ANSI SQL 2008 compliant.  Which i found have to be POSIX standard for ERE.  I checked other vendors (Oracle) and th...
1513 Dec 2013 @ 02:49 PSTAnalyticsReplyWhy UV in MLOAD?That's true, but you might have a "MARK" option at use in your mload script, so in that case ET/UV tables are nice to have for later analyze. 
1426 Nov 2013 @ 04:53 PSTConnectivityReplyProblem with server name Hi, try search around the forums here: http://forums.teradata.com/forum/connectivity/teradata-jdbc-exception http://forums.teradata.com/forum/connectivity/connection-timeout-problem-driver-versi...
1325 Nov 2013 @ 01:29 PSTConnectivityReplyProblem with server name Hi, the main info from the java exception(s) is this:  Caused by: java.net.UnknownHostException: testServer Which actually means, you are trying to reach server 'testServer' which is...
1206 Nov 2013 @ 05:02 PSTConnectivityReplyODBC call failed error - windows 7 64 bit machineHi mates, when posting something leading to an error, post the error message, so we can dig out what is the root cause. From the writings it seems, you have some issues with client tools/libraries...
1106 Nov 2013 @ 03:31 PSTToolsReplyHow to pass return code of a mload to shell scriptAny command executed on shell will lead to $? to be filled with exit status of the last command. After you can test it and branch it, in your envelope script ... for example like this ... mload &l...
1030 Oct 2013 @ 03:13 PDTThird Party SoftwareReplyHow to configure email sending from Teradata VMWare Linux box?Hi there is installed 'postfix'. So what you need is to check configuration(mx entries, smtp server) and start-up the daemon. After that, your 'mailx -s "subject" "user@...
922 Oct 2013 @ 05:36 PDTTeradata StudioTopicMultistatement execution vs performanceHi all, this is not about error/issue, more-like it is about hint/note for future improvements. When there is prepare phase for testing, we have to drop several tables/databases and load them wit...
820 Sep 2013 @ 01:26 PDTConnectivityReplyInformatica 9.1.0 64 bit AIX and TPT 14I think you kind of mix PATH(for binaries) and LD_LIBRARY_PATH/LIBPATH(for libraries). Also to get working ODBC on AIX you probably need to define $ODBCINI variable, pointing to correct one. Inform...
726 Aug 2013 @ 07:51 PDTTeradata StudioReplyTD Studio Data Source Explorer - Table Column order is inverted?I am running TDS 14.02 on WinXP(32bit) with JRE 1.7.xx(32bit) connecting via jdbc with TMODE=Teradata TDS 14.10 on Windows7(64bit) with JRE 1.7.xx(64bit) connecting via jdbc with TMODE=Terad...
630 Jul 2013 @ 07:04 PDTDatabaseReplyTables with MLPPI requires much more space than the same one with PPI - why?When using PPI/MLPPI, rows get bigger by 2 or 8 bytes (this depends on total count of created partitions , subpartitions are internally just partitions) ; 2Bytes when <= 65535 ; 8Bytes when >...
501 Feb 2013 @ 07:01 PSTGeneralReplyWhy does it feel like Teradata is years behind?I am not trying to be so smart. But there is always positive and negative aspects of a design of database engine. And you just mentioned all those "not our competitors" why not speak abou...
410 Aug 2012 @ 10:26 PDTDatabaseReplyWhat is the Equivalent Function of TRUNC for Date in Teradata?? In TD there is no TRUNC, but you can download UDF functions, to get 'popular' Oracle's, including 'TRUNC' .... http://downloads.teradata.com/download/extensibility/terada...
310 Aug 2012 @ 10:16 PDTDatabaseReplyWhat is the Equivalent Function of TRUNC for Date in Teradata?? There are three different dataypes in Teradata/Standard SQL:  - DATE, just the date - TIME, just the time, optionally WITH TIME ZONE - TIMESTAMP, date plus time, optionally WI...
209 Aug 2012 @ 01:06 PDTThird Party SoftwareReplyInformatica and Teradata I tried to find LM_44128 in several infa.docs(version 811, 861,901HF2), but no luck. Very same with LM_44142. Only LM_36320 is there, but this one is a bit common.  Anyway LM more like ...
129 Jul 2012 @ 02:11 PDTConnectivityReplyNot able to create/connect to new Database Hi there, this might help http://forums.teradata.com/forum/connectivity/odbc-connection-error-specified-driver-could-not-be-loaded ... and you might consider to use Teradata instead ...