3803 | 28 Jun 2015 @ 01:59 PDT | Database | Reply | spool space allocation | The 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... |
3802 | 28 Jun 2015 @ 01:56 PDT | Database | Reply | Problem with history table | What'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... |
3801 | 28 Jun 2015 @ 01:40 PDT | Tools | Reply | Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ | Hi 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
|
3800 | 27 Jun 2015 @ 03:15 PDT | Database | Reply | SQL Script To Grant Select on All Views Within a Database | If 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... |
3799 | 27 Jun 2015 @ 03:11 PDT | Database | Reply | Link for Teradata Database for Windows XP | There'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... |
3798 | 27 Jun 2015 @ 03:08 PDT | Database | Reply | Table Aliasing | Hi Moutusi,
aliases simplify query development, no need to key in that_very_long_tablename all the time.
|
3797 | 27 Jun 2015 @ 03:06 PDT | Database | Reply | Create tables for loading changing files | Hi Prasanth,
for Studio check the articles by Francine Grimmer:
Transitioning from SQL Assistant to Studio Express
Teradata Studio 15.10 now available
|
3796 | 27 Jun 2015 @ 03:04 PDT | Database | Reply | Explain Plan based on stats | Hi 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... |
3795 | 27 Jun 2015 @ 02:59 PDT | Database | Reply | Using case when with a timestamp in the select statement | What'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... |
3794 | 27 Jun 2015 @ 02:56 PDT | Database | Reply | Teradata Express database instance - why no Windows version | I 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... |
3793 | 26 Jun 2015 @ 11:29 PDT | Database | Reply | Teradata Express database instance - why no Windows version | There's Teradata Express, a VMWare Virtual Machine.
It's a fully featured Teradata running on Suse Enterprise Linux 11.
|
3792 | 25 Jun 2015 @ 09:27 PDT | General | Reply | Get the number of days in a month | TD14:
SELECT EXTRACT(DAY FROM LAST_DAY(CURRENT_DATE))
|
3791 | 23 Jun 2015 @ 03:20 PDT | Database | Reply | Using case when with a timestamp in the select statement | When 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 '... |
3790 | 23 Jun 2015 @ 03:03 PDT | Database | Reply | Get the previous row's column Value | This 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... |
3789 | 23 Jun 2015 @ 02:47 PDT | Database | Reply | Finding next change in value | Hi 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... |
3788 | 23 Jun 2015 @ 02:23 PDT | Database | Reply | Difference between years | What's your TD release?
SELECT ROUND(MONTHS_BETWEEN(DATE '2012-07-24', DATE '2011-10-30') / 12)
|
3787 | 23 Jun 2015 @ 02:19 PDT | Tools | Reply | Editing queries in column Mode for SQL Assistant v15 | Hi 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.
|
3786 | 23 Jun 2015 @ 02:11 PDT | Database | Reply | Qualify 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.
|
3785 | 21 Jun 2015 @ 07:48 PDT | Tools | Reply | Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ | Hi 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-... |
3784 | 21 Jun 2015 @ 03:16 PDT | Tools | Reply | Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ | Hi Malli,
DIF is an ancient format (from the ages of Multiplan and Lotus 1-2-3), why do you want to use it anyway?
|
3783 | 21 Jun 2015 @ 02:46 PDT | Database | Reply | Create tables for loading changing files | Hi 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... |
3782 | 21 Jun 2015 @ 02:40 PDT | Database | Reply | 9334 Invalid constraint definition | What's your exact Teradata release?
Your Create works fine for me on a 15.00.01.06.
|
3781 | 21 Jun 2015 @ 02:37 PDT | Database | Reply | Teradata HW | Hi Alaa,
only the network (Teradata's Bynet) is proprietary, otherwise Teradata servers are standard Intel-based hardware (OEMed DELLs) running Suse Enterprise Linux.
|
3780 | 21 Jun 2015 @ 02:36 PDT | General | Reply | Install TD Express on PARALLELS | Hi 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
|
3779 | 20 Jun 2015 @ 02:41 PDT | Database | Reply | maxspool 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... |