#DateForumTypeThreadPost
34421 May 2014 @ 06:46 PDTDatabaseReplyinsert into views using fast load utilityIf you attempt to use FastLoad to insert data into an updatable view, you will get Teradata Database Error 3853 'ViewName' is not a table.
34320 May 2014 @ 12:33 PDTDatabaseReplyProblem inserting byte dataThe built-in function TO_BYTES was introduced in Teradata Database 14.0 and it provides conversion from a VARCHAR value consisting of hexadecimal digits to a VARBYTE value. (It can also do other co...
34220 May 2014 @ 06:39 PDTConnectivityReply[TeraJDBC 15.00.00.15] [Error 1178] [SQLState HY000]Are you a customer? We need to gather your DDL, sample data, and your Java code to reproduce the problem. It's easiest to do all that when you open a customer service incident.
34119 May 2014 @ 01:44 PDTDatabaseReplyUser Request To NODE MappingThe Bynet handles both intra-node and inter-node communication, and hides the details from the PE code.   When the PE determines that it must send a message to a particular AMP to do some wo...
34019 May 2014 @ 11:31 PDTDatabaseReplyUser Request To NODE MappingBynet is not involved for incoming SQL requests transmitted from a client application to the PE.   When a client application logs on to the Teradata Database, it establishes a session with...
33919 May 2014 @ 10:49 PDTDatabaseReplyUser Request To NODE Mapping>>> Does every user request coming to Teradata sent to each of the 50 Nodes ? No.   >>> But, how Teradata engage the Node, cause there seems to be no way for Teradata to k...
33819 May 2014 @ 10:34 PDTConnectivityReply[TeraJDBC 15.00.00.15] [Error 1178] [SQLState HY000]What version of the Teradata Database are you using?   There was a Teradata Database bug that caused a failure similar to the one you are reporting -- DBS DR 166595 (JDBC Exception is thrown...
33716 May 2014 @ 09:15 PDTGeneralReplyFunction overloading or Generic Functions in UDFsWith the CS option in the EXTERNAL NAME clause, the source file is transmitted from client to server, and compiled on the server. The server manages the object file that was output from the compile...
33616 May 2014 @ 08:49 PDTDatabaseReplyTop n FunctionAs Dixxie said, you must specify an ORDER BY clause to get predictable, repeatable results with the TOP n clause.   Your rows are stored on different AMPs, and the query is processed in para...
33516 May 2014 @ 08:46 PDTGeneralReplyNumber of bytes-BIGINTThe NUMBER data type is the only variable-length numeric data type.   All the other numeric types are fixed size: BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL, and FLOAT.
33416 May 2014 @ 08:26 PDTDatabaseReplyC UDF compiled with CS optionWith the CS option, the UDF source code is transmitted from the client to the server, and compiled on the server. No compiler is needed on the client side.
33313 May 2014 @ 06:38 PDTGeneralReply default character set in teradataIn addition to the server character set that Dieter discussed, there is: - a session character set that is used to encode and decode character data that is sent over the wire between the Teradata ...
33212 May 2014 @ 01:56 PDTDatabaseReplyTeradata vs oltpThe Teradata Database's locking behavior is the primary challenge for an OLTP style application. Be wary of adding threads, because that may increase lock contention, and make things worse. Try...
33112 May 2014 @ 01:44 PDTToolsReplyLOAD utilities in PROCYou cannot use the load utilities from inside a stored procedure. Also, you cannot load global temp tables or volatile tables.
33012 May 2014 @ 06:48 PDTGeneralReplyFunction overloading or Generic Functions in UDFsYes, function overloading is supported for UDFs written in C.
32912 May 2014 @ 06:46 PDTConnectivityReplysetSavePoint exceptionSavepoints are not supported by the Teradata Database. The Teradata JDBC Driver cannot provide Savepoint support because the Teradata Database does not support Savepoints.
32808 May 2014 @ 08:38 PDTDatabaseReplyRecommendation on varhar - char columnsVARCHAR is better than fixed-width CHAR with respect to the Teradata wire protocol.   (1) Null CHAR values will consume the entire width of the fixed-width CHAR value when they are sent over...
32707 May 2014 @ 08:40 PDTConnectivityReplyQuerying Teradata from JavaScript/jQuery?Client-side JavaScript code cannot use JDBC directly. You may want to use something like Jongo, which is a REST-to-JDBC gateway. https://github.com/Eldelshell/jongo   Your client-side JavaS...
32606 May 2014 @ 08:16 PDTToolsReplyTeradata v 14.10 and TTU v 13.10TTU product support for "forward" Teradata Database releases varies by TTU product, so you need to consult the release notes for each TTU 13.10 product that you are interested in using wi...
32501 May 2014 @ 11:50 PDTDatabaseReplySELECT Failed 2665: Invalid DateThe error message is correct. Those are character literals that are not in a valid date format.   You should use DATE literals instead: BETWEEN DATE '2013-01-01' AND DATE '2014-0...
32425 Apr 2014 @ 09:53 PDTGeneralReplyUsing odbc API in Teradata UDF's written in C>>> use SQLDriverConnect() to connect to a database and use SQLExecDirect() to execute the SQL queries and fetch their result using the SQLBind() and SQLFetch() functions using the ODBC AP...
32324 Apr 2014 @ 06:46 PDTGeneralReplyUsing odbc API in Teradata UDF's written in CNo, ODBC is not supported for use in a UDF. Actually, no SQL requests are supported in a UDF -- neither CLI nor JDBC are supported in a UDF.   SQL requests using the "default connection...
32223 Apr 2014 @ 06:30 PDTDatabaseReplySYSEXECSQLHave you considered using a Java Stored Procedure instead?   With a Java Stored Procedure, all the SQL statements are "dynamic", and the SQL request text can be up to approximately...
32122 Apr 2014 @ 12:32 PDTDatabaseReplySYSEXECSQLSQL string literals are limited in length to a maximum of 31000 bytes, according to the Teradata Database Reference / SQL Data Types and Literals.   What is your goal? For example, are you t...
32022 Apr 2014 @ 06:49 PDTDatabaseReplyGENERIC JDBC and Teradata DatabasesAre you referring to Teradata Studio's "New Connection Profile" dialog box, with "Generic JDBC" and "Teradata Database" options in the list?   You may be co...

Pages