#DateForumTypeThreadPost
6924 Sep 2013 @ 11:13 PDTDatabaseReplyCorrelated SubQuery needs Tuning.. INDEX and LENGTH functions causing problemHi, INDEX and SUBSTR functions impact the query performance, I suggest you should use a derived table instead of Subquery. Perform all the INDEX and SUBSTR functionality inside the derived table ...
6824 Sep 2013 @ 10:02 PDTDatabaseReplyFilter on two separate date field ranges using between functionYou can use the following SQL Where C.pmt_last_upd_dt = B.b_a_added_date AND (C.pmt_last_upd_dt between '2013-07-01' AND current_date AND B.b_a_added_date between '2013-07-01...
6724 Sep 2013 @ 09:01 PDTDatabaseReplyFilter on two separate date field ranges using between functionHi, What is th e issue you are facing in using condition?  
6624 Sep 2013 @ 03:24 PDTToolsReplyMuch time taken in SQl assitant when compared with DBQlog table timeDBQLOG is showing time the Teradata server took to process the request, Whil the time shown in application and SQL Assistant includes the time of data transfer over ODBC OR JDBC over the network. I...
6523 Sep 2013 @ 10:36 PDTDatabaseReplyMigrate All the Tables of SQL Server DataBase to TeraData in one goHi, I think you can write a procedure that will generate all the Teradata equalent DDL's for all the tables in SQL Server. Once the DDL's are deployed then you can copy data using the foll...
6422 Sep 2013 @ 03:30 PDTGeneralReplyROW_NUMBER() OVER (PARTITION BY col1,col2.... order by col1)Hi, You can cast it to BIGINT, and if still the range is outside the limit, then cast it to Decimal(18,0).  
6322 Sep 2013 @ 03:29 PDTGeneralReplyHow to install Teradata for practice in windows xp.Hey!  The first step is that you get TD installation material. Once you get the meterial, You will have to run the setup.exe and follow the instruction, just like you install other softwares ...
6222 Sep 2013 @ 03:25 PDTDatabaseReplyCannot install Teradata Express 13 under Windows XPYou can download all the TD related softwares from this link. http://downloads.teradata.com/download  
6121 Sep 2013 @ 11:35 PDTDatabaseReplyLT,WT,ET,UV tablesHi Abhijeet, Can you please elaborate what do you mean by full processing? Do you want an explainiation about the processing? OR some sample scripts of these utilities?  
6021 Sep 2013 @ 12:52 PDTDatabaseReplyImporting data from excel using the insert statementYou can use the following syntax: INSERT INTO TABLENAME (COL1, COL2) VALUES(?COL1,?COL2);  
5920 Sep 2013 @ 12:08 PDTDatabaseReplyShould I create staging tables with PI or shall I create NOPI tables?NOPI tables are recomended for staging tables. as at this level you do not have well defined PI columns, so in order to avoid skewed data distirbution, NOPI is good choice.  
5820 Sep 2013 @ 12:04 PDTDatabaseReplyHelp calculating an average Start Time?Hi, Try this, it worked for me. SELECT ColumnName, AVG(CAST(TIME_COLUMN AS INTERVAL HOUR(4) TO SECOND(0))) FROM ( SEL CAST(CAST(CAST('2013-09-13 12:01:23' AS TIMESTAMP(0)) AS FORMAT...
5719 Sep 2013 @ 11:18 PDTGeneralReplyCREATE MULTISET VOLATILE TABLE 0 row processed with ON COMMIT PRESERVE ROWSHi, It is a teradata convention to show 0 rows processed on a volatile table creation.after this message you can check data in the create table temp. check it CREATE MULTISET VOLATILE TABLE tm...
5619 Sep 2013 @ 10:49 PDTGeneralReplyShould I create staging tables with PI or shall I create NOPI tables?NOPI tables have been designed specifically for staging tables in order to avoid amp skewness, as at this step you do not have any well defined PI for data distribution. I think you can use NOPI f...
5519 Sep 2013 @ 10:47 PDTGeneralReplyGetting "x" in Teradata SQL Assistant but x in BTEQWhen you submit a query through BTEQ it do not parse information and shows the data as it is stored in the database.  While SQL Assistant uses customizations to the format and also depend on ...
5419 Sep 2013 @ 04:40 PDTGeneralReplyReplace blank('') as NULL in Stored ProcedureI think is not linked with the blank parameter, it is related with the value in Column1. When the column 1 is null, then the comparison with like is a little complex.  Can you please paste t...
5319 Sep 2013 @ 12:16 PDTDatabaseReplyUse of CTE within stored proceduresMany thanks Dieter for the valuable information!    
5218 Sep 2013 @ 10:13 PDTDatabaseReplyUse of CTE within stored proceduresIt is strange that this SQL works fine in SQL-Assistant, but when called througha procedure throws error. I have checked with recursive CTE as well, but it throws the same error.  But it work...
5118 Sep 2013 @ 11:19 PDTToolsReplyError 1606 when installing Teradata GSS Clientnt-i386 12.0.Hi, The problem is potentially a result of an inconsistent/incorrect environmental variable (%AppData%).   Solution: Open the Registry editor Navigate to the followin...
5018 Sep 2013 @ 11:17 PDTToolsReplyInstalling the TTU 14.10 on windowsHi, The problem is potentially a result of an inconsistent/incorrect environmental variable (%AppData%).   Solution: Open the Registry editor Navigate to the followin...
4917 Sep 2013 @ 08:35 PDTDatabaseReplyDELETE command There is a similar topic where dnoeth has answerd this question. the URL is as follows: http://forums.teradata.com/forum/database/delete-xxx-rows-with-teradata You can use this query with the fol...
4816 Sep 2013 @ 10:24 PDTGeneralReplySQL return code in stored procedure in TD14Hi,   The first thing is that the return codes and error codes are ususlly univeral and not changed often with version change. What I have found about the error code 3705, It is just a warn...
4716 Sep 2013 @ 02:44 PDTDatabaseReplyLatest database tools to learnIf you simply want to learn and explore the teradata database, then you can install teradatra tools and utilities and explore the database structures and other features.   If you are asking ...
4616 Sep 2013 @ 02:35 PDTToolsReplySQL Assistant Preferences & DSN entries locationAbout the second part of your question: SQL-Assistant stores the customized information in XML files at the following path: "C:\Users\<username>\AppData\Roaming\Teradata\SQL Assist...
4516 Sep 2013 @ 02:10 PDTToolsReplySQL Assistant Preferences & DSN entries locationThe ODBC entries can be backed up and restored from the registry entries.  The ODBC entries are present at the following location: HKEY_CURRENT_USER\Software\ODBC for User DSNs HKEY_LOCAL_...

Pages