2903 | 15 Jul 2014 @ 06:51 PDT | Database | Reply | format for email in create table | Why do you want to format an email address, it's only a string?
A valid email should already include the @ and if you stored both parts separately you simply concat:
local_part || '@'... |
2902 | 15 Jul 2014 @ 06:20 PDT | General | Reply | Can we use coalesce and aggregate function in one derived columns | I can't follow your logic, so I don't know if this is correct, but adding an aggregate function to the coalesce(main.a5,0) or removing the SUM should at least remove that error:
... |
2901 | 15 Jul 2014 @ 04:06 PDT | Database | Reply | Copy table 1:1 with compression | What kind of compression, multi value or block level?
Based on your other question I assume MVC. You can use
CREATE TABLE new_table
(col not null compress (1,2),
...) AS existing_table ... |
2900 | 15 Jul 2014 @ 03:59 PDT | Database | Reply | New in Release 13 ? Alter table not possible on columns with statistics | It's not a bug, this is how it's implemented :-)
At least you don't have to re-collect the stats:
CREATE TABLE table_copy AS old_table WITH NO DATA
COLLECT STATS ON table... |
2899 | 15 Jul 2014 @ 03:02 PDT | General | Reply | ORDER BY cannot be used in sub queries | This is exactly the same, remove ORDER BY, it is and always was absolutely useless for an INSERT.
|
2898 | 15 Jul 2014 @ 01:31 PDT | General | Reply | ORDER BY cannot be used in sub queries | Hi Soumik,
this query should have failed in every TD release, there's no ORDER BY allowed in an INSERT/SELECT (unless there's a TOP, too).
If it worked before it was a bug, now it's c... |
2897 | 15 Jul 2014 @ 01:06 PDT | Aster | Reply | How to load Fixed width files into Aster | Hi Arun,
afaik there's no Aster tool to load fixed width files.
You need to use any ETL tool supporting Aster or JDBC/ODBC.
|
2896 | 15 Jul 2014 @ 01:04 PDT | Database | Reply | New to Teradata Help with data type | A phone or email is simply a VarChar with some added validation rules.
Which DBMS has built in dataypes like that?
|
2895 | 15 Jul 2014 @ 01:02 PDT | Database | Reply | Stored procedure conversion from Oracle to Teradata | What is this SP supposed to do?
Simply returning a result set, then it's:
CREATE PROCEDURE RegionSelect ()
DYNAMIC RESULT SETS 1
BEGIN
DECLARE cur_OUT CURSOR WITH RETURN ONLY FOR
... |
2894 | 15 Jul 2014 @ 12:49 PDT | Database | Reply | Sybase SIMILAR Function and Teradata 14.0 equivalent | You should create a new topic for a new question.
I don't know Sybase, but:
1) + 2)
There's no capability like that in a Teradata SP, seems to be used to return some "work in progr... |
2893 | 14 Jul 2014 @ 09:10 PDT | Database | Reply | All AMP active for Updates based on primary index | The only case I can imagine if it's actually a single update using the PI is a LOCKING TABLE.
Do you run the update against a view with?
Then switching to LOCKING ROW shoul help.
|
2892 | 14 Jul 2014 @ 08:49 PDT | Database | Reply | Blank space check based on the position | What's your TD release?
In TD14 there are Regular Expression:
CASE WHEN regexp_similar(col, '[^B]([0-9]){3}.*') = 1 THEN 'ABC'
...
otherwise you need to SUBSTRING each cha... |
2891 | 11 Jul 2014 @ 03:45 PDT | Database | Reply | ROW_NUMBER() Problem in SUb Query | If you need a DELETE why don't you talk about it instead of SELECT?
ROW_NUMBER is only supported for SELECTs, but you don't need it (or ROWID):
delete from operations.tll_gnr_master as ... |
2890 | 11 Jul 2014 @ 01:49 PDT | Database | Reply | Creating a Total | Hi Bill,
of course you need to add a GROUP BY 1,2
|
2889 | 11 Jul 2014 @ 01:41 PDT | Database | Reply | DBC.QryLog table shows future time. | How far into the future, a few hours?
Might be because StartTime doesn't include a time zone and is stored in UTC.
|
2888 | 11 Jul 2014 @ 01:36 PDT | Database | Reply | Executing several Macros in a Macro | Hi Raghu,
all SQL within a macro (including nested macros) is treated as a Multi Statement Request, i.e. a single transaction.
If you don't need everything in a single transaction you should ... |
2887 | 11 Jul 2014 @ 01:33 PDT | Database | Reply | Need Query for reading XML data from a CLOB object | Hi Murugesan,
you should have a look at Teradata XML Services for TD14, in 14.10 this will be built-in.
|
2886 | 11 Jul 2014 @ 01:30 PDT | Database | Reply | ROW_NUMBER() Problem in SUb Query | This query is overly complicated (in Oracle, too), should be exactly the same as
select a.*
from operations.tll_gnr_master a, operations.site b
where a.site_key=b.site_key
and b.brand... |
2885 | 11 Jul 2014 @ 01:26 PDT | General | Reply | How to use reserved key words as column names | No.
You should try to avoid reserved names as you have to use those double quotes whenever that column is used in any SQL.
|
2884 | 11 Jul 2014 @ 01:21 PDT | Aster | Reply | Aster regexp: how to delete 5 lines before certain words | I can't spot where you specify 5 lines, but this might be due to the forum software stripping off some meta characters...
You want to keep the line with 'fax' in it, including the phon... |
2883 | 10 Jul 2014 @ 11:18 PDT | Database | Reply | Year and Month only field |
WHERE to_mth >= EXTRACT(YEAR FROM CURRENT_DATE) * 100 +
EXTRACT(MONTH FROM CURRENT_DATE)
Looks complicated, but the optimizer will resolve it to as a YYYYMM number, check E... |
2882 | 10 Jul 2014 @ 08:02 PDT | Tools | Reply | FASTLOAD ERROR | Hi Zeeshan,
this error indicates there are less fields in your input record than DEFINEd.
Btw, 44 delimiters define 45 columns, but this should not the source of your problem.
|
2881 | 10 Jul 2014 @ 04:06 PDT | Database | Reply | SELECT failed 7453 : interval field overflow | You can't compare an HOUR TO SECOND interval to an INTEGER. What is 30 supposed to be. hours, minutes or seconds?
((FIRSTRESPTIME - FIRSTSTEPTIME) hour(4) to second ) <= INTERVAL '30&... |
2880 | 10 Jul 2014 @ 02:37 PDT | Database | Reply | Execute Query based on IF condition | You should write a Stored Procedure for this.
If all those queries return compatible columns a Macro might work, too:
replace macro xxx (indate date) as
(
select ....
where indate = ... |
2879 | 10 Jul 2014 @ 02:33 PDT | Tools | Reply | FASTLOAD ERROR | Hi Zeeshan,
it's hard to tell without more info.
Did you use VARTEXT and the correct DELIMITER?
Did you DEFINE all fields as VARCHAR?
|