#DateForumTypeThreadPost
77127 Nov 2015 @ 01:22 PSTDatabaseReplyNodes TypesThe term "application node" is an older name for what is now generally called a Teradata Managed Server. It is a server provided by Teradata that is not running Teradata databas...
77027 Nov 2015 @ 10:15 PSTCloud ComputingReplyTeradata 15.10.0.7 Express Vmware: Viewpoint fails to add Teradata accountYou need to have a System defined for monitoring (via the Viewpoint Admin portlet) before you can add TD accounts on that system to any user profile.
76927 Nov 2015 @ 09:55 PSTExtensibilityReplyMD5 Message Digest UDFCorrect syntax is "replace function databaseName.hash_md5 ..." but you can't add user-defined functions to TD_SYSFNLIB. You could use SYSLIB.
76825 Nov 2015 @ 09:58 PSTToolsReplyFast load IssueYou will need the commas also, but didn't even get that far. While the reference to "'WITH' keyword" is confusing, the 3706 error is because your BEGIN LOADING command d...
76724 Nov 2015 @ 12:39 PSTDatabaseReplystring contains an untranslatablePlease start a new topic for a new question. The column must be defined as UNICODE. Both the load and the query should use UTF8 or UTF16 session character set. Other than that, double check how th...
76624 Nov 2015 @ 12:11 PSTDatabaseReplySQL user defined function in TeradataPlease start a new topic for a new question. In both cases, the answer is no. A SQL UDF definition must be a SQL expression, and NOT a SQL statement; it may not contain even a scalar subquery.
76524 Nov 2015 @ 12:07 PSTDatabaseReplyHow to get started using TeradataUsers are encouraged to download client drivers from http://downloads.teradata.com  The license terms are displayed when you click on the link to download the driver. (Drivers are also includ...
76418 Nov 2015 @ 03:14 PSTConnectivityReplyProblems using SET QUERY_BAND from ODBCSo sSQL contains both the SET QUERY_BAND and the SELECT, i.e. it's a multi-statement request?   Then don't include BEGIN TRANSACTION / END TRANSACTION. Just use SET QUERY_BAND ... FO...
76318 Nov 2015 @ 03:05 PSTDatabaseReplyMultiple DDL/Grant statements inside ProcedureIn ANSI mode, SP cursors are not "holdable". Is using Teradata mode with implicit auto-commit feasible? Maybe as a workaround you could use a Queue Table and instead of fetchin...
76218 Nov 2015 @ 07:30 PSTDatabaseReplyError : 2644 : No More room in database DBCDid you check distribution of free space per AMP in DBC?  
76118 Nov 2015 @ 07:19 PSTDatabaseReplyStarting in Teradata - ROLE/USER/PRIVILEGES/AUTHENTICATION - please helpTo filter the objects the user can see, several steps would be needed: Be sure the optional "X views" are installed: DBC.DatabasesVX, DBC.TablesVX, DBC.ColumnsVX, DBC.TableSi...
76013 Nov 2015 @ 01:07 PSTTeradata ApplicationsReplyUTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10''This error means there is something other than spaces between the semicolon and the end of the line. The 25 represents the relative character position within the script line that contains the offen...
75904 Nov 2015 @ 02:10 PSTToolsReplyDifference in Aquisition phase of Mload & FastLoadIn both cases, an entire data block from the client is sent to an AMP, which immediately de-blocks the data, builds individual rows, and sends each row to the appropriate t...
75802 Nov 2015 @ 11:11 PSTToolsReplyDifference in Aquisition phase of Mload & FastLoadIn FastLoad Phase 1, blocks of data are sent to arbitrary AMPs which deblock the data, compute the rowhash, and send each row to the proper destination AMP. So "redistribution" is pa...
75727 Oct 2015 @ 09:37 PDTDatabaseReplyNodes TypesThey are similar. They don't affect overall system capacity other than max sessions allowed. AMP-less / PE-only are two names for the same thing. These are server nodes connected via BYNET but...
75627 Oct 2015 @ 11:43 PDTDatabaseReplyWork Around for Top N SubQuery in Stored ProcedureDECLARE C1 CURSOR FOR S1; PREPARE S1 FROM SQL_STMT1; OPEN C1; FETCH C1 INTO Check_TEMP; CLOSE C1; Rather long-winded, but this is how to retrieve the value from dynamic SQL.
75523 Oct 2015 @ 03:48 PDTConnectivityReplyadodb connection error - Not enough information to log onTry adding "Persist Security Info=true;" to your connection string.  
75422 Oct 2015 @ 04:48 PDTDatabaseReplyRegular Expression Brackets not working in BTEQThanks for starting a new thread. Look at the EBCDIC characters in Hex. What values do you see for the special characters? There are multiple variations of EBCDIC and square brackets in parti...
75322 Oct 2015 @ 04:12 PDTDatabaseReplyTimestamp upation issueWARNING - Do not change TimeDateWZControl value without reviewing all the implications carefully and talking it over with Teradata support.  
75222 Oct 2015 @ 04:05 PDTToolsReplyTPT sessions are left behind?The Terminate() call cleaned up the sessions on the client, but the database never saw that request because you were blocking network traffic. By default, the Teradata gateway should send sta...
75120 Oct 2015 @ 11:54 PDTDatabaseReplySAS connect Teradata and executeWORK is a reserved word. If the Teradata database name is WORK, you need to quote it: "WORK".TESTE_TERA If WORK is some SAS object, you can't refer to it in a pass-through EXECU...
75020 Oct 2015 @ 11:51 PDTDatabaseReplyError in Procedure: Query Failed. Refer to result column in History for details.Double-click on the history and look at the actual error message. I presume this is a portion of the stored procedure? You can't use a SELECT within a SET. Use SELECT INTO syntax in...
74920 Oct 2015 @ 11:44 PDTDatabaseReplyMload using "WITH RECURSIVE" on teradataYou can't do SELECT within an MLOAD, so no.
74820 Oct 2015 @ 11:42 PDTDatabaseReplyHow to find SQL Server Blocking?You might have better luck posting SQL Server questions in a Microsoft-related forum, rather than a Teradata database forum.
74719 Oct 2015 @ 11:57 PDTDatabaseReplyTeradata Error 9936: The user does not have access to zoneWhich user? Is it the invoker of the SP, the creator of the SP, or the owner of the SP?

Pages