#DateForumTypeThreadPost
26915 Nov 2013 @ 06:47 PSTToolsReplyUtilities interacting with mloadThe Teradata Database server-side utility qrysessn does not "interact" with the TTU client-side utility MultiLoad.   Google provides the following definition for "interac...
26814 Nov 2013 @ 08:56 PSTToolsReplyUtilities interacting with mloadMload is a utility. It does not interact with any other utilities.
26713 Nov 2013 @ 06:45 PSTGeneralReplyJDBC Driver 12.0 CompatibilityRegarding application server support, we typically wait until support is requested by a customer for a new version of an application server.
26612 Nov 2013 @ 06:47 PSTGeneralReplyJDBC Driver 12.0 Compatibility@wmmiteff, you are correct. Teradata JDBC Driver 12.0 and 3.3 are not listed on the Teradata JDBC Driver Supported Platforms matrix because they are not supported.     Only supported s...
26508 Nov 2013 @ 06:39 PSTGeneralReplyJDBC Driver 12.0 CompatibilityTeradata JDBC Driver 12.0 is no longer supported.   The Teradata JDBC Driver Supported Platforms matrix is published here on Developer Exchange. It shows which Teradata JDBC Driver releases ...
26404 Nov 2013 @ 06:49 PSTGeneralReplyQuerybanding in Oracle,SQL server,Db2The JDBC API Specification refers to this kind of database feature as "Client Info". The Teradata JDBC Driver implements the JDBC API Client Info feature using the underlying Teradata Da...
26301 Nov 2013 @ 01:20 PDTToolsReplyMulti load through java application.I just examined the Teradata Database SQL Reference / Data Definition Language / ALTER TABLE command, and I do not see any syntax for changing a table from SET to MULTISET.   As an alternati...
26201 Nov 2013 @ 06:43 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"You're making progress -- you have obtained a root-cause exception that represents a database error.   Errors 1338 and 1339 are both generic errors from the Teradata JDBC Driver that ind...
26101 Nov 2013 @ 06:35 PDTToolsReplyMulti load through java application.I'm not sure what you are asking. Are you asking whether it is possible to change an existing SET table to be a MULTISET table?
26031 Oct 2013 @ 03:03 PDTToolsReplyMulti load through java application.>>> I’d to try to load my 36 million records from CSV file too – one question if I have duplication records – how I can handle it?   JDBC FastLoad CSV uses the Ter...
25931 Oct 2013 @ 02:51 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"The Error 1339 is a generic error code that indicates a problem occured. Your application needs to walk the SQLException chain to obtain the root-cause exception. (This is what Todd Walter was sugg...
25831 Oct 2013 @ 08:46 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]">>> this exception began to appear more and more frequently   Which exception exactly?
25731 Oct 2013 @ 06:55 PDTDatabaseReplyQuery band in MacrosGenerally speaking, a command must be classified as a DDL command if it changes any database objects. This relates to how SQL requests are parsed. A DDL command must be the last (or only) command i...
25630 Oct 2013 @ 06:46 PDTExtensibilityReplyJava UDF and Socket (TCP/UDP) ConnectionsIf your query is SELECT transform(column) FROM table, then your "transform" UDF will be called once per row. Make sure there are multiple rows in the table, then your UDF will be called m...
25530 Oct 2013 @ 06:41 PDTConnectivityReplyJDBC Connection from Oracle 11g Java Stored ProcedureFirst, the Oracle Database server-side JVM for Oracle Java Stored Procedures is not one of the supported environments for the Teradata JDBC Driver.   Having said that, this problem correspon...
25429 Oct 2013 @ 10:49 PDTToolsReplyMulti load through java application.>>> Teradata Studio Express has Load/Teradata Load functionality then you do right click on table.   Teradata Studio Express uses the Teradata JDBC Driver for its load and unload fu...
25329 Oct 2013 @ 06:51 PDTExtensibilityReplyJava UDF and Socket (TCP/UDP) ConnectionsDepending on your query, a scalar UDF might execute only once, for example: SELECT MyUdf('foo') That would explain why you only see one UDP connection at a time.
25225 Oct 2013 @ 06:41 PDTToolsReplyMulti load through java application.>>> FastLoad ... big concern to load 36M at a time. Also we have foreign key constraints and some logic - I mean that there is a chance have error/exception during process data  ...
25124 Oct 2013 @ 06:35 PDTDatabaseReplyQuery band in Macros>>> allow both session and transaction query bands when they're hardcoded but only transaction query bands when parameterized?   That behavior is not specific to macros.  ...
25023 Oct 2013 @ 10:03 PDTDatabaseReplyProblems using LIKE ANY on TD 13.1The LIKE ANY predicate is expected to work. I just tested your example CASE expression on Teradata Database 13.0, 13.10, 14.0, and 14.10 and I received the correct results on all those versions of ...
24923 Oct 2013 @ 09:39 PDTToolsReplyMulti load through java application.No change since my comment a year ago. The MultiLoad protocol is not supported by the Teradata JDBC Driver at the present time; however, it is still on our product roadmap.
24823 Oct 2013 @ 09:35 PDTConnectivityReplyHibernate, blob and large filesbchalal, Do not use connection parameter CLIENT_CHARSET=cp936 in conjunction with CHARSET=utf8. You are very likely to corrupt your data by doing that.   Generally speaking, it is a bad ide...
24721 Oct 2013 @ 06:41 PDTConnectivityReplyHibernate, blob and large filesThe Teradata JDBC Driver Engineering team is investigating your issue. We will reply again after our investigation.
24621 Oct 2013 @ 06:38 PDTConnectivityReplyUnable to connect to Teradta Express 13 via JDBC Are you running your program on Linux? If the "Incomplete LAN message header: read 0 bytes" error occurs when running on a Linux machine, then the most likely cause is the "Slow Lo...
24518 Oct 2013 @ 01:13 PDTConnectivityReplyHibernate, blob and large filesDo not use connection parameter CLIENT_CHARSET=cp936 in conjunction with CHARSET=utf8. You are very likely to corrupt your data by doing that.   Generally speaking, it is a bad idea to use t...

Pages