17 | 12 Nov 2014 @ 10:37 PST | Database | Reply | ALTER Secondary Index | The only index that you can modify using an alter is the primary index and the table must be empty to do that.
Example:
ALTER TABLE HSTLD.ADW_CUSTOMER_TYPE2 MODIFY PRIMARY INDEX(CT_ID );
Dieter ... |
16 | 15 Oct 2014 @ 09:12 PDT | Database | Reply | User commentString | Ok the question I have is why you would want or need to change the comment string for DBC?
-Fred
|
15 | 15 Oct 2014 @ 09:09 PDT | Database | Reply | Sessions are getting block | You can achive write concurrency on a table provided that the row hash locks do not overlap otherwise you will be blocked which is probably what is happening in your case.
|
14 | 15 Oct 2014 @ 08:54 PDT | Teradata Studio | Reply | Teradata Load Errors | A few questions:
1. What utility are you using to load the table?
2. Can you provide the script that you are using?
Thanks
-Fred
|
13 | 14 Oct 2014 @ 08:36 PDT | General | Reply | Getting the warnjng- *** Warning: Out of data-while importing csv file using bteq | What are you trying to accomplish by eliminating the warning?
|
12 | 14 Oct 2014 @ 08:24 PDT | Connectivity | Reply | Create a Teradata view to an external Teradata Server | Either way you are going to move the data even if it is a seamless process that you don't see. There are features coming that provide the Teradata equivalent of db links.
-Fred
|
11 | 01 Oct 2014 @ 09:16 PDT | Database | Reply | Finding PI for a table created already | Welcome Sarah!
|
10 | 01 Oct 2014 @ 08:51 PDT | Database | Reply | How to find base tables/views for views | You can also use a recursive query to parse the view ddl. I used to have a piece of SQL I wrote to do this which worked fairly well but I've misplaced it or I'd share.
|
9 | 29 Jan 2014 @ 11:20 PST | General | Topic | CAPTCHA | Just going to say that the CAPTCHA implementation is a bit overkill. I just had a customer spend 30 minutes trying to get registered and log in because the CAPTCHA was not just a little h... |
8 | 08 Jan 2013 @ 08:29 PST | Database | Reply | Temporal Macro / Dynamic SQL in a View | This is not difficult.
CREATE MACRO PassValidtime(mydate DATE) AS (
validtime as of :mydate
select *
from
MyTemporal_Table;)
EXEC PassValidtime('2012-12-01')
You can al... |
7 | 21 Mar 2012 @ 05:03 PDT | Database | Reply | Compressing History Database |
Have you tried running "Compact History" under "Tools" manually to see if it will stop trying to do it automatically. How big is your query history database?
|
6 | 21 Mar 2012 @ 04:54 PDT | Tools | Reply | Export large data set to CSV files |
Send an email to Bob Hahn. He has developed an axsmod called pfast which allows you to easily do what you describe. It works great. We are using it with 13.10.
Robert.Hahn@Teradata.com
-... |
5 | 21 Mar 2012 @ 11:31 PDT | Database | Reply | Defining two derived tables using WITH clause ?? |
That is great news Dieter. Thanks for posting. My current client will love this information.
|
4 | 21 Mar 2012 @ 11:27 PDT | General | Reply | Checksum |
I think this will provide what you need:
http://forums.teradata.com/forum/database/checksum-attribute
|
3 | 20 Mar 2012 @ 02:59 PDT | Extensibility | Topic | SQL UDF replace_chars |
I put together a simple sql udf to replace characters in a string. Its limited to a 55 character source string but works well.
select replace_chars( '1%223456#664', '%16#',... |
2 | 20 Mar 2012 @ 02:48 PDT | Database | Reply | Defining two derived tables using WITH clause ?? |
Unfortunately not. We encountered this issue on a DB2 conversion. It is a much cleaner way to work with derived tables. It would be nice if Teradata supported it.
|
1 | 14 Mar 2012 @ 12:42 PDT | UDA | Reply | Split delimited column into separate rows |
This will work.
I setup the test like this.
CREATE TABLE LOAD.Test_x
(
Delimited_String VARCHAR(100)
)
INSERT INTO LOAD.Test_x
VALUES ('1 | A, B, C')
VALUES (... |