#DateForumTypeThreadPost
1828 Oct 2014 @ 09:57 PDTDatabaseReplyErrormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10Hi  Ulrich, Fastload version is       ===================================================================      =           ...
1728 Oct 2014 @ 07:30 PDTDatabaseTopicErrormessage: The file "errmsg.cat" cannot be opened. Fastload Teradata 14.10Hi , We are doing the Teradata upgrade and facing  issue in Teradata connectivity Teradata. New Teradata Version : 14.10 Teradata Previous Version before Upgrade: 13.10 Issue: We are facin...
1609 Oct 2013 @ 07:11 PDTPrivate Forum
1525 Nov 2012 @ 03:46 PSTDatabaseTopicTeradata SQL Assistant Hangs when column contains only Space as values.  Hi,   I am using Teradata SQL Assistant 13.11.0.04 .   Database version is 13.10.05.03 Provider version is 13.00.00.02     If any ...
1418 Jul 2012 @ 07:16 PDTGeneralReplyquery tuning Hi, How much time is it taking?   Also please check the datatype of the tables , it seems that teradata need to convert the values to float before joining . Datatype conversion ...
1305 Jun 2012 @ 11:59 PDTDatabaseReplyGroup by question   Try following:   sel  name,empno,medstat,edlev,max(salary) over ( partition by medstat,edlev )from retail.employee  
1216 May 2012 @ 12:45 PDTUDAReplyalter table modify primary index to unique primary index Please consider your primary index again. Partitioning columns do not have to be columns in the primary index. If they aren't, then the primary index cannot be unique. 1) If you will...
1116 May 2012 @ 12:16 PDTDatabaseReplyhow backup of tables with IDENTITY column create a table new by executing the DDL of the original table ( remove the identity clause from that).   Insert into backuptable sel * from identitytable;
1003 Apr 2012 @ 04:56 PDTDatabaseReplySql query help @Bryce and ulrich, thanks a lot for the help.
902 Apr 2012 @ 04:50 PDTDatabaseTopicSql query help     My input data is as follows:   Product category value 1 ...
830 Nov 2011 @ 01:16 PSTPrivate Forum
729 Nov 2011 @ 01:44 PSTGeneralReplyHow to get entire database DDL structure in TeraData   Run the following Query for the database for which you want to get the DDL   sel 'show table ' || databasename   ||'.'||   tablename ||';...
624 Nov 2011 @ 10:27 PSTGeneralReplyFload table release lock yes all the details , number of records loaded , number of records duplicate and the time take will be present in the log file.  
524 Nov 2011 @ 01:07 PSTGeneralReplyFload table release lock   Following will be included in the script.     LOGON dbc/sjn,music ; BEGIN LOADING Fast_Table ERRORFILES Error_1, Error_2 ; END LOADING ;   ...
424 Nov 2011 @ 01:01 PSTGeneralReplydata distribution in amp when more amps added Whenever new AMP are added to the existing system, your hash algorithm changes and the rows from the exisitng AMP may or may not migrate to the new AMP based on the new hash algorithm. In yo...
323 Nov 2011 @ 05:42 PSTGeneralReplyFload table release lock For fastload we can not release lock, we drop the table and recreate it again.   Other way is to run a fastload which contain BEGIN LOADING and END LOADING statement.  
207 Jun 2011 @ 04:55 PDTDatabaseReplyNumeric Overflow error in teredataYou are not losing the precision when changing it to Float. In sql assistant go to tools--> option --> Answerset --> Number of decimal Places to display for float column ( change this to the req...
113 May 2011 @ 03:06 PDTDatabaseReplypivoting data from an existing table data please assistcreate volatile table cps ( id integer, test1 integer, test2 integer, test3 integer) on commit preserve rows insert into cps values (1 , 32, 15,12) insert into cps values (2 , 1, 3,5...