#DateForumTypeThreadPost
39414 Nov 2014 @ 06:55 PSTDatabaseReplyJDBC connectivityYou don't need to use a PreparedStatement for that SQL request, because it does not contain any question-mark parameter markers (and, in fact, you cannot use parameter markers in a DDL command ...
39307 Nov 2014 @ 06:54 PSTDatabaseReplyTransaction aborted by Administrator or operation staff Error 3110 means that the user aborted their own query, that they were running. It does not mean that a user aborted some other user's query.   DBQL records the username of the user...
39206 Nov 2014 @ 09:11 PSTDatabaseReplyOracle numeric data type equivalent on Teradata.Here is what the Teradata Database Reference / SQL Data Types and Literals / Chapter 3 Numeric Data Types / NUMBER Data Type section says:   "Calculations for the NUMBER data type are g...
39106 Nov 2014 @ 09:01 PSTExtensibilityReplyCalling Web ServicesMany organizations have their Teradata Database system behind a firewall so that neither inbound nor outbound Internet connections are possible.   The Google Geocoding API uses HTTP or HTTPS...
39006 Nov 2014 @ 08:13 PSTDatabaseReplyTransaction aborted by Administrator or operation staff Error 3110 "The transaction was aborted by the user" means the end-user or the client application aborted the transaction, not an administrator.   This can occur in a variety ...
38930 Oct 2014 @ 09:24 PDTDatabaseReplylength of a stringWhy did you ask for help with SQL Server in a Teradata forum?
38829 Oct 2014 @ 10:30 PDTGeneralReplyIs Teradata good for Operational Online ApplicationsTeradata does have customers with web-based Java applications that use the Teradata JDBC Driver to query the Teradata Database, and consistently achieve subsecond query response time.   As u...
38729 Oct 2014 @ 10:10 PDTGeneralReplypom file for maven projectBy the way, Teradata JDBC Driver 12.00.00.105 is very old (about 6 years old) and is no longer supported. Please consider switching to a newer version of the Teradata JDBC Driver.
38629 Oct 2014 @ 10:06 PDTGeneralReplypom file for maven projectThe Teradata JDBC Driver must be obtained from Teradata directly, for example, from here on Developer Exchange.  We do not make the Teradata JDBC Driver available from any public Maven reposit...
38524 Oct 2014 @ 09:20 PDTUDAReply[Performance] how to avoid parsing time when executing macro via JDBC As Ulrich said, that's a complex query in the macro. And the macro parameters are reused several times throughout the query, so the query can't be tested on its own outside of the macro. &...
38423 Oct 2014 @ 11:53 PDTConnectivityReplyHow to call a Teradata stored procedure using openJPA?FYI -- that is a macro, not a stored procedure. Regarding your question...   You can obtain the current database name by executing the HELP SESSION command.   Please refer to my blog ...
38322 Oct 2014 @ 09:27 PDTUDAReply[Performance] how to avoid parsing time when executing macro via JDBC Please post the DDL to create the macro.
38220 Oct 2014 @ 09:43 PDTDatabaseReplyIssue : All virtual circuits are in useCarlos, That text is from the Teradata Database Reference book "Database Administration". Thank you for reporting the error in that text. I created defect DR 174049 against that boo...
38120 Oct 2014 @ 09:20 PDTDatabaseReplyIssue : All virtual circuits are in useSandeep, It's too difficult to troubleshoot the 8024 error in a forum thread. It might be caused by a variety of reasons, even a Teradata Database Gateway defect. If you're a customer...
38017 Oct 2014 @ 09:27 PDTDatabaseReplyIssue : All virtual circuits are in useAnd by the way, a few years back I created an RFC against the Teradata Database Gateway -- GTW RFC 138835 "At logon time DBS Gateway should prefer On-Node PE for the session"   Tha...
37917 Oct 2014 @ 09:21 PDTDatabaseReplyIssue : All virtual circuits are in use@Sandeep,   Regarding: "It means that connection with one IP connect to the PEs on that Node only ?"   The answer is No. The way it works is that connections is one IP addre...
37809 Oct 2014 @ 10:54 PDTDatabaseReplySQL STORED PROCEDURES SQL SECURITY INVOKER OPTIONI agree that the documentation indicates that your REPLACE PROCEDURE command should fail in your scenario.   Your profile says that you're with Overstock.com. I recommend that you open a...
37707 Oct 2014 @ 06:50 PDTDatabaseReplyView with a dynamic table in FROM clause (without using Java or C)?I assume that these tables contain error messages, or some other kind of text that is displayed for the user?   It would be simpler to use a single table, and distinguish each row in the tab...
37603 Oct 2014 @ 06:49 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousIf you include the NUMBER column in your query, you get an error. If you omit the NUMBER column from your query, it works OK. It seems clear that the problem is due to a lack of NUMBER data type su...
37502 Oct 2014 @ 06:39 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousIf an application executes a query that returns a NUMBER data value from the Teradata Database while using an old version of the Teradata JDBC Driver that does not support the NUMBER data type, the...
37429 Sep 2014 @ 06:49 PDTDatabaseReplySend mail from a stored procedureYou cannot send mail from a SQL stored procedure, or from a macro.   You can send mail from a External Stored Procedure written in either C or Java. There is an example showing how to send m...
37324 Sep 2014 @ 10:10 PDTExtensibilityReplyerror when compiling Java UDFYour Parser class has a package statement at the top: package ua_parser;   You will need to specify the fully-qualified package+class name in the EXTERNAL NAME clause of the CREATE FUNCTION...
37223 Sep 2014 @ 12:16 PDTConnectivityReplyReading Clob column using teradata JDBC is too slowReading each CLOB value requires a separate round-trip message exchange between the Teradata JDBC Driver and the Teradata Database.   If your application must read all the the character data...
37117 Sep 2014 @ 11:38 PDTConnectivityReplyJDBC LDAP connection with encrypted passwordQuestion: The problem here is that the password is being sent out over the network as plaintext. Is there a way to make this connection so that the password is encrypted?   Answer: The cred...
37016 Sep 2014 @ 12:44 PDTGeneralReplyAre a tables columns accessible as a CSV list in DBC?If you want to select all columns from a table, you don't really need the column names.   You can simply do: SELECT * FROM MyDatabase.MyTable   The same is true for INSERT stateme...

Pages