269 | 15 Nov 2013 @ 06:47 PST | Tools | Reply | Utilities interacting with mload | The Teradata Database server-side utility qrysessn does not "interact" with the TTU client-side utility MultiLoad.
Google provides the following definition for "interac... |
268 | 14 Nov 2013 @ 08:56 PST | Tools | Reply | Utilities interacting with mload | Mload is a utility. It does not interact with any other utilities.
|
267 | 13 Nov 2013 @ 06:45 PST | General | Reply | JDBC Driver 12.0 Compatibility | Regarding application server support, we typically wait until support is requested by a customer for a new version of an application server.
|
266 | 12 Nov 2013 @ 06:47 PST | General | Reply | JDBC 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... |
265 | 08 Nov 2013 @ 06:39 PST | General | Reply | JDBC Driver 12.0 Compatibility | Teradata 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 ... |
264 | 04 Nov 2013 @ 06:49 PST | General | Reply | Querybanding in Oracle,SQL server,Db2 | The 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... |
263 | 01 Nov 2013 @ 01:20 PDT | Tools | Reply | Multi 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... |
262 | 01 Nov 2013 @ 06:43 PDT | Database | Reply | errors "[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... |
261 | 01 Nov 2013 @ 06:35 PDT | Tools | Reply | Multi 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?
|
260 | 31 Oct 2013 @ 03:03 PDT | Tools | Reply | Multi 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... |
259 | 31 Oct 2013 @ 02:51 PDT | Database | Reply | errors "[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... |
258 | 31 Oct 2013 @ 08:46 PDT | Database | Reply | errors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]" | >>> this exception began to appear more and more frequently
Which exception exactly?
|
257 | 31 Oct 2013 @ 06:55 PDT | Database | Reply | Query band in Macros | Generally 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... |
256 | 30 Oct 2013 @ 06:46 PDT | Extensibility | Reply | Java UDF and Socket (TCP/UDP) Connections | If 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... |
255 | 30 Oct 2013 @ 06:41 PDT | Connectivity | Reply | JDBC Connection from Oracle 11g Java Stored Procedure | First, 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... |
254 | 29 Oct 2013 @ 10:49 PDT | Tools | Reply | Multi 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... |
253 | 29 Oct 2013 @ 06:51 PDT | Extensibility | Reply | Java UDF and Socket (TCP/UDP) Connections | Depending 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.
|
252 | 25 Oct 2013 @ 06:41 PDT | Tools | Reply | Multi 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
 ... |
251 | 24 Oct 2013 @ 06:35 PDT | Database | Reply | Query 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.
... |
250 | 23 Oct 2013 @ 10:03 PDT | Database | Reply | Problems using LIKE ANY on TD 13.1 | The 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 ... |
249 | 23 Oct 2013 @ 09:39 PDT | Tools | Reply | Multi 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.
|
248 | 23 Oct 2013 @ 09:35 PDT | Connectivity | Reply | Hibernate, blob and large files | bchalal,
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... |
247 | 21 Oct 2013 @ 06:41 PDT | Connectivity | Reply | Hibernate, blob and large files | The Teradata JDBC Driver Engineering team is investigating your issue. We will reply again after our investigation.
|
246 | 21 Oct 2013 @ 06:38 PDT | Connectivity | Reply | Unable 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... |
245 | 18 Oct 2013 @ 01:13 PDT | Connectivity | Reply | Hibernate, blob and large files | 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 idea to use t... |