#DateForumTypeThreadPost
84614 Jan 2016 @ 10:38 PSTDatabaseReplyComparing two tablesAs Dieter said (years ago): MINUS / MINUS ALL will always spool / redistribute / sort both tables. If you code a NOT EXISTS, the optimizer will take advantage of the PI being the same an...
84514 Jan 2016 @ 10:07 PSTDatabaseReplyEmergency: Question about function from_bytes and to to_bytesTo avoid being treated as negative, just add leading zero byte: from_bytes('00'xb||hash_column,'base16')
84413 Jan 2016 @ 12:49 PSTDatabaseReplyRestore a backup taken with Teradata ABU on another serverCOPY using each of the four data files, one at a time, specifying NO BUILD for the first three.
84313 Jan 2016 @ 12:45 PSTDatabaseReplyOLAP functionsOrdered Analytical Functions (sometimes called OLAP functions) operate over an ordered set of rows and/or results depend on the previous row. Examples include RANK or running SUM (a...
84213 Jan 2016 @ 12:39 PSTDatabaseReplySelect all text after specific characterSELECT SUBSTRING(col FROM POSITION('@' IN col)+1)
84112 Jan 2016 @ 01:19 PSTConnectivityReplyQuerying an Oracle database from a Teradata queryNo. TD15.0+ supports FOREIGN SERVER / FOREIGN TABLE grammar, but you still need to install the QueryGrid / USL components to be able to make a connection. Alternatively, TPT (Teradata Parallel Tra...
84011 Jan 2016 @ 09:45 PSTDatabaseReplyHow to find boundaries of rotating year in teradataThere is no 31 September, and it would be hard to determine exactly how you are defining "average date" with only one example. For instance, what happens when there are an even numbe...
83911 Jan 2016 @ 09:06 PSTToolsReplyIssue with importing CLOB data using BTEQWith INDICDATA, the file is expected to be in "FastLoad format" with binary length fields and NULL indicator bits at the start. And since you have not said otherwise, BTEQ will expect the...
83811 Jan 2016 @ 08:14 PSTConnectivityReplyQuerying an Oracle database from a Teradata queryTeradata sells an optional product that provides connectivity to Oracle databases. For 14.10 / 15.0 it is called "Unity Source Link", though going forward it will be referred to as &...
83708 Jan 2016 @ 09:33 PSTDatabaseReplyError in Procedure: Query Failed. Refer to result column in History for details.In the earlier post, instead of the SET with a subquery: SELECT MAX(V_MONTH) INTO :MAX_DATE FROM DB_TEMP.HISTORIAL_DATA;   I'm not clear on how your question is a "similar iss...
83608 Jan 2016 @ 09:09 PSTDatabaseReplyBTEQ Export truncating CLOB column valueOUT (or INOUT) parameters in a SP require special handling by the client. I don't think you can export a LOB that way. But you can return LOBs via a Dynamic Result Set.
83507 Jan 2016 @ 01:54 PSTDatabaseReplyError: LOBs are not allowed to be hashedWhat sort of details? The Teradata hash function does not accept LOBs as arguments; but The Teradata implementation of certain operations depends on having a hash value - so LOBs...
83407 Jan 2016 @ 10:19 PSTDatabaseReplyError -2513 DataWhat are the data types for C.GU_PRIMARY_NAME,A.SLA_BUSINESS_RULE_CLASS_CD,A.SLA_BUSINESS_RULE_NAME? Are any of them VARCHAR with excessive max length (perhaps much greater than any ...
83307 Jan 2016 @ 10:09 PSTDatabaseReplyBTEQ Export truncating CLOB column valueYou are correct. Support for exporting LDOs in BTEQ was introduced in TTU15.0. You must use LARGEDATAMODE, INDICDATA, and DEFERTRANS as in example 8. Why did you .SET INDICDATA OFF in your script?...
83206 Jan 2016 @ 11:07 PSTDatabaseReplyBTEQ Export truncating CLOB column valueBTEQ can IMPORT LOB data over 64K using "AS DEFERRED", but cannot EXPORT it. (LARGEDATAMODE only works if you are displaying data to stdout in "hex dump" format, not i...
83106 Jan 2016 @ 10:14 PSTDatabaseReplyTeradata Free Version/ ExpressTeradata Studio (or Studio Express) is a client tool. Teradata Express for VMWare Player is the database. Information on both can be found in the Downloads section of this site. For assistance wit...
83006 Jan 2016 @ 10:09 PSTToolsReplyTPT Number of instances vs load tasksSessions from parallel instances of a LOAD operator definition will all have the same LSN and will be treated as a single load task on the database side. Instances provide ...
82906 Jan 2016 @ 09:59 PSTDatabaseReplyISO calendar : previous week number issue There are no supplied functions that take yyyyww as an argument. But since we know 04 Jan is always in week 1, we can derive a DATE that we know must fall in week yyyyww: ...
82805 Jan 2016 @ 04:45 PSTDatabaseReplyGetting a unique value for VARCHAR field.Assumption #3 is correct - the hash function is not invertible. Assumption #2 is incorrect. It is possible (though mildly unusual) for two different input values to yield the same hash (...
82705 Jan 2016 @ 04:31 PSTDatabaseReplyregexp_replace woesSUBSTRING function requires FROM and optionally FOR keywords inside the parentheses; to use commas instead, change to SUBSTR function. But note that the third argument is a length and not the...
82604 Jan 2016 @ 04:32 PSTTeradata ApplicationsReplyPerformance tuning questionHave you considered an index on (SRC_SYS_ID, SRC_TRAN_ID)? Maybe a single-table join index that includes ROWID?
82504 Jan 2016 @ 04:13 PSTDatabaseReplyUpdate with two joinsUPDATE Extr FROM FROM ndeshpande.VW_ClickPref_URLExtract AS Extr,      pfocusvw.event AS ev,      pfocusvw.EVENT_ATTRACTION AS atr SET URL_Attraction...
82404 Jan 2016 @ 04:05 PSTDatabaseReplyFastLoad Job LSNThe control session is logged on first, so it has the lowest session ID.
82331 Dec 2015 @ 10:35 PSTConnectivityReplypassword expired ado and vb6You would need to detect the SQLSTATE T3032 / native 3032 warning and execute the MODIFY USER statement using the initial connection. Then you could either continue to use the connection or cl...
82231 Dec 2015 @ 10:15 PSTGeneralReplyDate Conversion Issue, from String to DATEIf the temp table VARCHAR column DATECOL contains valid date values in precisely the yyyy-mm-dd format, then CAST(DATECOL AS DATE FORMAT 'yyyy-mm-dd')

Pages