#DateForumTypeThreadPost
54631 Mar 2014 @ 06:04 PDTDatabaseReplyCALLing a dynamically created SP name.CALL is not allowed as a dynamic SQL statement within a Stored Procedure. You would need to construct the 'CALL sp_loadtablename' statement on a client platform (e.g. an ETL server) a...
54531 Mar 2014 @ 05:25 PDTCloud ComputingReply TDExpress14.10.00.02_Sles11_40GB.7z TDFor IDs/passwords, see the intro document. http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player   As for 64-bit support, the hardware must be c...
54427 Mar 2014 @ 09:12 PDTGeneralReplyRounding off in TeradataThere are many different approaches to "rounding", especially when it comes to values that are precisely halfway between two values in the desired result precision - see http://en.wi...
54324 Mar 2014 @ 12:49 PDTTeradata ApplicationsReplyError Code: 2796 MLoad MARK MISSING DELETEAs the message says, you issued a DELETE for a row that was missing (no row matched the WHERE condition). By default, this is considered an error and is "marked" or logged to the err...
54224 Mar 2014 @ 12:38 PDTDatabaseReplyArcmain table load progress while copy/restore lockingTry the VERBOSE run-time option in ARC to periodically report row counts. The qrysessn utility can also be used to display details on I/O done by the child sessions.
54124 Mar 2014 @ 11:58 PDTDatabaseReplyHelp with creating a Case within an In statment within a Case Based on your statement of the intent: Case When (CASE WHEN Food_Type IN ('Green Apple','Red Apple') Then 'Apple' ELSE Food_type END)   In ('Apple...
54018 Mar 2014 @ 09:23 PDTToolsReply“Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS” running bteq on AIXMost often, this is due to a network error of some sort which allows the initial logon handshake (very short messages) to succeed but data transmission (longer messages) fa...
53918 Mar 2014 @ 08:35 PDTDatabaseReplyCalculating day number of the year for a dateIn TD14.0 and later, use td_day_of_year() function
53814 Mar 2014 @ 12:59 PDTToolsReplyTerradataParallelTransporter-Load errorI haven't used this JNI / C++ approach, but I suspect backslashes will still need to be doubled within in the resulting script; you may need to enter four in a row in DirectoryPa...
53713 Mar 2014 @ 01:21 PDTDatabaseReplyAdding days to TIMESTAMP WITH TIMEZONE columnIn the first case, just use Start_Date + Count_Days * INTERVAL '1' DAY.   In the second, you need to say you want the time zone, i.e. CAST(... AS TIMESTAMP WITH TIME ZONE)
53613 Mar 2014 @ 01:08 PDTToolsReplyBTEQ in Windows EnvironmentDepending on how you are installing the software and what version, these components / dependencies may be handled more or less automatically. Shared ICU Libraries for Teradata (typically bundled w...
53505 Mar 2014 @ 12:29 PSTDatabaseReplyRoles and Implicit SELECT AccessYes, SELECT must be granted in order to have access to read the data.
53405 Mar 2014 @ 12:26 PSTDatabaseReply3754: Precision Error Float type constant or during implicit conversionsIf you try to compare a character field with a numeric field, the Teradata default is to implicitly convert both to FLOAT. Look at the DDL (e.g. do SHOW for the above statement) and figure out...
53305 Mar 2014 @ 12:21 PSTToolsReplyRe: Delete Syntax in MLOADIn a standard BEGIN [IMPORT] MLOAD, the DELETE statement must specify values for the PI with equality condition, just as an UPDATE would. Or you can use BEGIN DELETE MLOAD and non-PI equality WHERE...
53225 Feb 2014 @ 03:11 PSTDatabaseReply*** Warning: EOF on INPUT stream.It's strictly an informational message, letting you know that BTEQ has switched back to reading commands from stdin. Just ignore that the text contains the word "warning".
53130 Jan 2014 @ 08:47 PSTDatabaseReplySupporting Chineese charaters in TeradataYou can use CHAR2HEXINT() function to determine what is actually being stored for the column. Verify that the expected Teradata UNICODE character values are present. If not, you will need to c...
53029 Jan 2014 @ 03:01 PSTConnectivityReplyJDBC Hebrew SupportTo properly support Hebrew, the data should be stored as CharacterSet UNICODE, and both loads and query tools should specify an appropriate Session Character Set (NOT specify/default to ASCII). Yo...
52929 Jan 2014 @ 01:50 PSTDatabaseReplySELECT * - failing due to column access controls?http://www.teradata-partners.com/PARTNERS_User_Group/Enhancement_Requests/
52828 Jan 2014 @ 09:29 PSTDatabaseReplyGet query metadata without running itSince this is a program using embedded SQL, have you looked at PREPARE (ODBC SQLPrepare method)?
52728 Jan 2014 @ 09:20 PSTDatabaseReplySupporting Chineese charaters in TeradataNote that both the load and the query sessions must specify an appropriate client character set. Often it is best to use UTF16 (or UTF8 if data is mostly LATIN numbers and letters) for qu...
52628 Jan 2014 @ 09:03 PSTDatabaseReplySELECT * - failing due to column access controls?As you discovered, "SELECT *" looks for an access rights row for 'All' columns. The "*" is not expanded to a list of column names until after the access rights chec...
52528 Jan 2014 @ 08:58 PSTDatabaseReplyUrgent : Latin to Unicode character conversion- Please helpAre you certain the data you want was actually stored in the LATIN column? It may have been translated to error replacement '1A'xc on loading. Verify what is actually stored using CHARTOHEX...
52416 Jan 2014 @ 02:40 PSTConnectivityReplyWhich Teradata drivers support data encryption?UseDataEncryption=Yes
52315 Jan 2014 @ 07:47 PSTDatabaseReplyNew Features in Teradata 14For list & short descriptions of new features, check the "Release Summary" manuals for TD14.0 and intervening releases (TD13.10 in this case).  
52215 Jan 2014 @ 07:39 PSTConnectivityReplySqoop Import from Teradata with 30 lines of SQL query using –query is failingYes, but it can't be after GROUP BY. Try something like: ... BETWEEN 0 AND 1 ) AND \$CONDITIONS GROUP BY ...

Pages