3178 | 03 Oct 2014 @ 11:46 PDT | Teradata Studio | Reply | Tools > Create > Database, User etc. dialogs missing in Teradata Studio Express 15 | TD Studio Express doesn't have the admin part, you need TD Studio .-)
|
3177 | 03 Oct 2014 @ 11:45 PDT | Database | Reply | sql server . How they can be conveted to valid TeraData types | Most datatypes are exactly the same in Teradata, please check the manuals:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1143_112A/title.040.2.html
... |
3176 | 03 Oct 2014 @ 06:41 PDT | Tools | Reply | Get a Thousand Separators Using BTEQ Export Script | Hi Sri,
you need to implicitly place the thousand seperators, some countries use hundred seperators :)
Do you need leading zeroes?
format '-999,999,999,999.99'
Otherwise:
format '-... |
3175 | 03 Oct 2014 @ 06:33 PDT | Database | Reply | How to concatenate a date in three different columns? | That's simple, there's an invalid date.
This function will return a NULL for invalid dates:
REPLACE FUNCTION fnc_try_ymd_to_date(y INTEGER, m INTEGER, d INTEGER)
RETURNS DATE
SPECIFIC... |
3174 | 02 Oct 2014 @ 08:38 PDT | Database | Reply | Partitioning by a character column | Hi Sandesh,
you will get partition elimination only for equality when using HASHBUCKET.
So CHAR-PPI is the preferred sollution in 13.10.
|
3173 | 02 Oct 2014 @ 08:30 PDT | Database | Reply | How to concatenate a date in three different columns? | Instead of casting to strings and back to date you might use a numeric calculation:
SELECT 1987 AS y, 2 AS m, 14 AS d,
(y-1900)*10000 + m * 100 + d (DATE)
|
3172 | 28 Sep 2014 @ 01:39 PDT | Training | Reply | Any best Training Centres you guys know in Hyderabad?? | Logins are only revoked when a user spams.
Nobody prevents him from using a different email to register again and then aswering questions instead of simply promoting himself.
|
3171 | 28 Sep 2014 @ 03:10 PDT | Training | Reply | Any best Training Centres you guys know in Hyderabad?? | What I consider strange about Manohar (and some other similar guys):
- Most of the "Manohar's the best" post are from members with didn't post anything else. They register, submi... |
3170 | 27 Sep 2014 @ 10:10 PDT | General | Reply | Stored Procedure | Of course can DDL and DML be mixed in the same SP, you just have to follow the rule that a DDL must be commited.
|
3169 | 27 Sep 2014 @ 10:08 PDT | Database | Reply | output of Stored Procedure | Of course can you use select in a macro, but no dynamic SQL.
|
3168 | 27 Sep 2014 @ 07:10 PDT | Database | Reply | Merge with error table | Hi Moutusi,
dbc.ErrorTblsV tracks existing error tables.
And when you read the manuals you'll find all details:
The SQL DML manual for MERGE and the SQL DDL manuals for CREATE ERROR TABLE.
... |
3167 | 27 Sep 2014 @ 05:05 PDT | Database | Reply | output of Stored Procedure | No, this is how returning answer sets from a SP is implemented (based on Standard SQL)
|
3166 | 27 Sep 2014 @ 03:21 PDT | Private Forum |
3165 | 27 Sep 2014 @ 03:15 PDT | Database | Reply | self join of table based on PI is spooling out | Hi Srilakshmi,
can you show DDL plus query (join conditions) and explain?
To get a direct join on the PI you must also add the partitioning columns to the join, too.
|
3164 | 27 Sep 2014 @ 03:06 PDT | Database | Reply | Tuning LIKE Operator | What's the selectivity of your LIKE-condition?
I just tried it on a TD15 VM and it's using a NUSI (or JI) if the number of distinct values is high (in my case 150,000 within 9,000,000 rows... |
3163 | 27 Sep 2014 @ 02:36 PDT | Database | Reply | Remove characters after '-' in a string | Teradata Timestamps only support 6 digits, so you must strip of the last digit.
Do you really have data with that accuracy?
In your case there's a fixed format, so simply extracting the ... |
3162 | 27 Sep 2014 @ 02:32 PDT | Database | Reply | output of Stored Procedure | Providing an error message instead of "unable to get an output" would be helpful.
SysExecSQL/EXECUTE don't support SELECTs.
You shoud read the Stored procedures manual, there's ... |
3161 | 26 Sep 2014 @ 06:26 PDT | Database | Reply | Teradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token. | Hi Amadu,
'60'x should be a backtick "`", this is not valid in Teradata (or Standard SQL).
You don't need to quote a name unless there are invalid characters in it or it'... |
3160 | 26 Sep 2014 @ 06:22 PDT | Database | Reply | Tuning LIKE Operator | Did you check if the optimizer misses a statistic?
You can try a join index with the same PI as the base table and the column searched by LIKE:
create join index ... as
select id,end_dt, col1
... |
3159 | 26 Sep 2014 @ 06:15 PDT | Database | Reply | Qualify in select statement | I don't fuly understand what you want, but it seems like you need the row where the cumulative sum of the transaction amount reaches 300?
Then you need to two nested QUALIFY:
SELECT ...
FR... |
3158 | 25 Sep 2014 @ 10:05 PDT | Database | Reply | job sequence number | Do you mean a column defined with GENERATED ALWAYS AS IDENTITY?
This is the the way it is implemented in TD, it's not one sequence, it's a parallel sequence. Each AMP/PE reserverves a batc... |
3157 | 25 Sep 2014 @ 09:25 PDT | Database | Reply | Select Statement inside a case statement | Hi Raghav,
do you try to run this as a standalone query?
select Case when (select count(*)from ABC) >'0' then 'Data is available' else 'No data' end
or better
s... |
3156 | 25 Sep 2014 @ 08:51 PDT | Database | Reply | How to group these records? | The common technique to get this kind of result is using a cummulative sum on the 1/0 flag Raja mentioned:
SELECT ...
SUM(CASE WHEN GapDays >= 8 THEN 1 ELSE 0 end)
OVER (PARTITION BY ... |
3155 | 24 Sep 2014 @ 08:12 PDT | Database | Reply | Difference between TO and AS keywords in RENAME syntax | Hi Balaji,
there's no difference, it's just a syntax variation.
|
3154 | 24 Sep 2014 @ 08:10 PDT | Database | Reply | Temporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key) | Hi Parth,
why do you want to disable/enable FKs? Due to bad performance?
In a DWH you hardly find FKs and if they're usually implemented using REFRENCE WITH (NO) CHECK OPTION.
|