#DateForumTypeThreadPost
460318 Aug 2016 @ 07:44 PDTUDAReplyCONVERT and DATEDIFF in TeradataFor difference in days it should be SELECT CURRENT_DATE - DATE '2016-08-20'
460218 Aug 2016 @ 03:23 PDTDatabaseReplyTeradata Query-URGENTWhenever I read URGENT I tend to fall into tranquilo, mañana mode :-)   QUALIFY ROW_NUMBER() OVER (PATTITION whatever ORDER BY whatever) = 1
460118 Aug 2016 @ 03:15 PDTDatabaseReplySQL Error on 'Create Table' in Terdata SQL AssistantSimply read the error message: CREATE TABLE Failed.  [3707] Syntax error, expected something like a 'LOG' keyword or a 'QUEUE' keyword between ',' and the 'CHEC...
460018 Aug 2016 @ 03:10 PDTTeradata DebuggerReplyFetching the last date of the current Quarter !!! Your first calculation doesn't return the current quarter correctly, e.g. in July it will return 2016-04-01 instead of 2016-07-01. -- begin of current quarter trunc(current_date, 'q'...
459918 Aug 2016 @ 03:03 PDTTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageIt's Network Settings, not Network Proxy :-) You must modify eth0 (lo = localhost, you can't change that), this is the only entry, listed as Ethernet Network Card.
459817 Aug 2016 @ 07:38 PDTDatabaseReplyterdata query.@GTeradata: You probably run an older version of Teradate where you need to add the column list like WITH cte (col1,col2,.., rn, pairs) AS   @Kuldeepg92: There's no way to avoid p...
459717 Aug 2016 @ 05:52 PDTTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?There's a link on the download site "how to install and configure Teradata Express for VMware." :-) http://downloads.teradata.com/node/415
459617 Aug 2016 @ 03:12 PDTTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageYou do the standard (Suse) Linux way: Computer -> Control Center -> Network Settings -> Edit
459517 Aug 2016 @ 03:09 PDTDatabaseReplySubstitute for "LIKE" in teradata Standard SQL LIKE only supports _ & %, using ranges is characters is an extension (e.g. SQL Server).   What did you try? There's no regexp_like in Teradata, but regexp_similar works...
459417 Aug 2016 @ 03:04 PDTTeradata StudioReplyHow to solve the error "Creating connections to local Teradata Database has encountered a problem" ?Well, the error message is self-explaining:  The UserId, Password or Account is invalid.   You used a wrong username or password.
459316 Aug 2016 @ 10:02 PDTDatabaseReplyDatatype of a Column of a ViewAll literals default to Unicode character set, thus the CASE results in a Unicode string. dbc.ColumnsV returns the ColumnLength as physical size in bytes, for Unicode (CharType=2) you must di...
459216 Aug 2016 @ 09:38 PDTConnectivityReplyCLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGONYou simply add a new line SET TERACLI=1 to the batch file before calling BTEQ.   To modify environment variables on a user/system level, see http://superuser.com/questions/949560/how-d...
459116 Aug 2016 @ 09:13 PDTDatabaseReplyterdata query.You can assign a row_number sorted by gender and split in two groups. Assuming you want to pair randomly: WITH cte AS ( SELECT dt.*, ROW_NUMBER() OVER (ORDER BY gender, id)...
459015 Aug 2016 @ 05:20 PDTConnectivityReplyCLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGONThe delay is caused by the lookup to find an ip-address for teracli., the COP discovery: BTEQ/CLI adds COP1 to the hostname and resolves it to an p-address, if successful the number is increased t...
458915 Aug 2016 @ 04:41 PDTDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsYou should find 9 UDFs in syslib and 10 in td_sysfnlib with the name GREATEST (but different specific names). The functions in syslib are not the built-in functions (those UDFs have been installed...
458814 Aug 2016 @ 01:03 PDTDatabaseReplyBteq import the output characters got cut off by 2 #: When you define IMPORT VARTEXT all fields must be defined a VARCHAR #2: You need to quote the filename when you want to add command options: #3: You better add PACK to speed up the import &nb...
458714 Aug 2016 @ 03:12 PDTToolsReplyUnderstanding teradata sample scriptsYou mean the scripts found in Teradata\Client...? Those are examples for TPT (Teradata Parallel Transporter).   Files in quickstart are based on the TPT Quick Start Guide and userguide...
458613 Aug 2016 @ 02:58 PDTToolsReplyBTEQ and OReplaceCheck the datatype returned by oReplace, it's probably a VarChar(8000), but your .WIDTH is set to 2000, which leads to truncation. You need to cast to a properly sized VarChar.
458512 Aug 2016 @ 09:28 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowThis seems to be similar to forums.teradata.com/forum/database/calculation-of-prescription-drug-adherence   If this matches you need to materialize a row_number in a Volatile table and ...
458412 Aug 2016 @ 08:17 PDTDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsThose functions found in syslib are some old pre-TD14.10 UDFs, if you don't qualify the function name they will be found/used instead of td_sysfnlib.greatest. The names are due to overloading (...
458312 Aug 2016 @ 06:09 PDTGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsThis is the best plan you can get, the optimizer combines all OLAP steps with the same partition/order.   Standard SQL syntax supports a WINDOW clause (not supported in Teradata) which avoid...
458212 Aug 2016 @ 06:05 PDTGeneralReplyLooking for help with regards to nested aggregatesSorry, but I don't get what you're trying to do with your sample data and expected result.   If your "reporting solution" doesn't support subqueries/Derived Table you b...
458112 Aug 2016 @ 05:52 PDTToolsReplyAny way to find the original query that created a table?Or you check the CreatorName & CreateTimestamp and try to find the query in the QueryLog history
458012 Aug 2016 @ 05:50 PDTDatabaseReplyCapturing MAX marks for Each Student when the MArks are in Columnstd_sysfnlib.GREATEST accepts up to 10 parameters. Check if there's another UDF with the same name in the search path:  default database -> syslib -> td_sysfnlib
457904 Aug 2016 @ 02:59 PDTDatabaseReplyNeed help with interdependent calculation using result from previous rowBased on the example data you don't need to use the previous row's data, it's just the minimum start date plus a cumulative sum of supplied days: min(SELL_DATE) over (partitio...

Pages