#DateForumTypeThreadPost
1712 Nov 2014 @ 10:37 PSTDatabaseReplyALTER Secondary IndexThe 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 ...
1615 Oct 2014 @ 09:12 PDTDatabaseReplyUser commentStringOk the question I have is why you would want or need to change the comment string for DBC?  -Fred
1515 Oct 2014 @ 09:09 PDTDatabaseReplySessions 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. 
1415 Oct 2014 @ 08:54 PDTTeradata StudioReplyTeradata Load ErrorsA few questions: 1. What utility are you using to load the table? 2. Can you provide the script that you are using? Thanks -Fred
1314 Oct 2014 @ 08:36 PDTGeneralReplyGetting the warnjng- *** Warning: Out of data-while importing csv file using bteqWhat are you trying to accomplish by eliminating the warning? 
1214 Oct 2014 @ 08:24 PDTConnectivityReplyCreate a Teradata view to an external Teradata ServerEither 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
1101 Oct 2014 @ 09:16 PDTDatabaseReplyFinding PI for a table created alreadyWelcome Sarah!
1001 Oct 2014 @ 08:51 PDTDatabaseReplyHow 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.
929 Jan 2014 @ 11:20 PSTGeneralTopicCAPTCHA 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...
808 Jan 2013 @ 08:29 PSTDatabaseReplyTemporal Macro / Dynamic SQL in a ViewThis 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...
721 Mar 2012 @ 05:03 PDTDatabaseReplyCompressing 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?  
621 Mar 2012 @ 04:54 PDTToolsReplyExport 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 -...
521 Mar 2012 @ 11:31 PDTDatabaseReplyDefining two derived tables using WITH clause ?? That is great news Dieter. Thanks for posting. My current client will love this information.
421 Mar 2012 @ 11:27 PDTGeneralReplyChecksum I think this will provide what you need: http://forums.teradata.com/forum/database/checksum-attribute
320 Mar 2012 @ 02:59 PDTExtensibilityTopicSQL 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#',&#...
220 Mar 2012 @ 02:48 PDTDatabaseReplyDefining 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.
114 Mar 2012 @ 12:42 PDTUDAReplySplit 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 (...