#DateForumTypeThreadPost
380328 Jun 2015 @ 01:59 PDTDatabaseReplyspool space allocationThe spool of a user does not depend on the user's perm space (otherwise most end users would have severe problems as they got PERM = 0). So MRKT still can utilize up to 300GB spool (unless the...
380228 Jun 2015 @ 01:56 PDTDatabaseReplyProblem with history tableWhat's your Teradata release? In TD14.10 there's LAST_VALUE: LAST_VALUE(colums_s IGNORE NULLS) OVER (PARTITION BY key_col ORDER BY date_col ROWS UNBOUNDED PR...
380128 Jun 2015 @ 01:40 PDTToolsReplyReceiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQHi Mallik, Q1: There's no need for DUAL as you don't need FROM: SELECT 1; Q2: The name VarChar (= Character Varying) implies variable size Q3: You can compress VarChars since TD13.10
380027 Jun 2015 @ 03:15 PDTDatabaseReplySQL Script To Grant Select on All Views Within a DatabaseIf you follow Teradata's recommendations to seperate tables and views into different databases, it's a simple GRANT SELECT ON myDb TO myUser; Otherwise create the GRANT statements FROM dbc...
379927 Jun 2015 @ 03:11 PDTDatabaseReplyLink for Teradata Database for Windows XPThere's no Teradata for XP, it's only running on SUSE Linux. But there's Teradata Express, a fully featured VM, it's for VMWare, but you should be able to run it on Virtual Bo...
379827 Jun 2015 @ 03:08 PDTDatabaseReplyTable AliasingHi Moutusi, aliases simplify query development, no need to key in that_very_long_tablename all the time.
379727 Jun 2015 @ 03:06 PDTDatabaseReplyCreate tables for loading changing filesHi Prasanth, for Studio check the articles by Francine Grimmer: Transitioning from SQL Assistant to Studio Express Teradata Studio 15.10 now available
379627 Jun 2015 @ 03:04 PDTDatabaseReplyExplain Plan based on statsHi Mani, of course the plan might be bad if stats are wrong (wrong = orders of magnitude). If you know that stats are outdated you might recollect them and simply check Explain before and after i...
379527 Jun 2015 @ 02:59 PDTDatabaseReplyUsing case when with a timestamp in the select statementWhat's the datatype of CHECKIN_TIME? SELECT CURRENT_TIME AS CHECKIN_TIME ,CHECKIN_TIME (FORMAT 'hh:mi:ssbt') (CHAR(12)) AS CHECKIN ,CASE WHEN CHECKIN_TIME BETWEEN TI...
379427 Jun 2015 @ 02:56 PDTDatabaseReplyTeradata Express database instance - why no Windows versionI doubt that a native Windows version would be much faster, speed is usually related to the RAM size on the host (4GB is the lower limit, when you got 8GB you can assign more RAM to the VM) and dis...
379326 Jun 2015 @ 11:29 PDTDatabaseReplyTeradata Express database instance - why no Windows versionThere's Teradata Express, a VMWare Virtual Machine. It's a fully featured Teradata running on Suse Enterprise Linux 11.
379225 Jun 2015 @ 09:27 PDTGeneralReplyGet the number of days in a monthTD14:  SELECT EXTRACT(DAY FROM LAST_DAY(CURRENT_DATE))  
379123 Jun 2015 @ 03:20 PDTDatabaseReplyUsing case when with a timestamp in the select statementWhen you cast a time to a string you apply string comparison rules (and a string doesn't care about AM/PM) Simply keep the time: SELECT PATIENT.PAT_NAME ,PAT_ENC.CHECKIN_TIME (FORMAT '...
379023 Jun 2015 @ 03:03 PDTDatabaseReplyGet the previous row's column ValueThis will return the UID if both values exist: select uid from tab where SID in ('S1','S2') -- only searched values group by uid having min(SID) <> max(SID)-- both mu...
378923 Jun 2015 @ 02:47 PDTDatabaseReplyFinding next change in valueHi Vijay, you probably mean 07-2015 for the last for rows instead oof 06-2015. What's your Teradata release? TD14.10 has a nice new syntax: SELECT emp_id, amt_paid, BEGIN(pd), END(pd) FR...
378823 Jun 2015 @ 02:23 PDTDatabaseReplyDifference between yearsWhat's your TD release? SELECT ROUND(MONTHS_BETWEEN(DATE '2012-07-24', DATE '2011-10-30') / 12)
378723 Jun 2015 @ 02:19 PDTToolsReplyEditing queries in column Mode for SQL Assistant v15Hi Calvin, there was a bug in the initial version of SQLA 15 which has been fixed in the very first patch 15.0.0.1. Upgrade to get the latest patch level.
378623 Jun 2015 @ 02:11 PDTDatabaseReplyQualify rank not applied?It's a bug, if you Explain both queries you will notice that the EXPAND ON is in step #1 in one case and #3 in the other. If you're a customer open an incident.
378521 Jun 2015 @ 07:48 PDTToolsReplyReceiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQHi Mallik, in the exported DIF there's info about the column names, but Excel doesn't seem to use it. DO you need to run this export in a batch or manually? SQL Assistant can create Excel-...
378421 Jun 2015 @ 03:16 PDTToolsReplyReceiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQHi Malli, DIF is an ancient format (from the ages of Multiplan and Lotus 1-2-3), why do you want to use it anyway?
378321 Jun 2015 @ 02:46 PDTDatabaseReplyCreate tables for loading changing filesHi Prasanth, imho there's no reliable solution for this scenario, loading totally unknown data. What are you going to do with that table afterwards? Teradata Studio supports loading fil...
378221 Jun 2015 @ 02:40 PDTDatabaseReply9334 Invalid constraint definitionWhat's your exact Teradata release? Your Create works fine for me on a 15.00.01.06.
378121 Jun 2015 @ 02:37 PDTDatabaseReplyTeradata HWHi Alaa, only the network (Teradata's Bynet) is proprietary, otherwise Teradata servers are standard Intel-based hardware (OEMed DELLs) running Suse Enterprise Linux.
378021 Jun 2015 @ 02:36 PDTGeneralReplyInstall TD Express on PARALLELSHi ABH, I didn't try it, but Parallels should have an option to open/run/convert VMWare VMs. E.g. http://kb.parallels.com/en/115305
377920 Jun 2015 @ 02:41 PDTDatabaseReplymaxspool value wrong in dbc.diskspaceV?Hi Sven, the spool of this user is assigned via a PROFILE, there are two columns for Spool/Temp:  SELECT databasename, SUM(maxperm), SUM(COALESCE(MaxProfileTemp,Maxtemp)), SUM(COALESCE...

Pages