69 | 24 Sep 2013 @ 11:13 PDT | Database | Reply | Correlated SubQuery needs Tuning.. INDEX and LENGTH functions causing problem | Hi,
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 ... |
68 | 24 Sep 2013 @ 10:02 PDT | Database | Reply | Filter on two separate date field ranges using between function | You 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... |
67 | 24 Sep 2013 @ 09:01 PDT | Database | Reply | Filter on two separate date field ranges using between function | Hi,
What is th e issue you are facing in using condition?
|
66 | 24 Sep 2013 @ 03:24 PDT | Tools | Reply | Much time taken in SQl assitant when compared with DBQlog table time | DBQLOG 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... |
65 | 23 Sep 2013 @ 10:36 PDT | Database | Reply | Migrate All the Tables of SQL Server DataBase to TeraData in one go | Hi,
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... |
64 | 22 Sep 2013 @ 03:30 PDT | General | Reply | ROW_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).
|
63 | 22 Sep 2013 @ 03:29 PDT | General | Reply | How 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 ... |
62 | 22 Sep 2013 @ 03:25 PDT | Database | Reply | Cannot install Teradata Express 13 under Windows XP | You can download all the TD related softwares from this link.
http://downloads.teradata.com/download
|
61 | 21 Sep 2013 @ 11:35 PDT | Database | Reply | LT,WT,ET,UV tables | Hi 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?
|
60 | 21 Sep 2013 @ 12:52 PDT | Database | Reply | Importing data from excel using the insert statement | You can use the following syntax:
INSERT INTO TABLENAME (COL1, COL2)
VALUES(?COL1,?COL2);
|
59 | 20 Sep 2013 @ 12:08 PDT | Database | Reply | Should 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.
|
58 | 20 Sep 2013 @ 12:04 PDT | Database | Reply | Help 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... |
57 | 19 Sep 2013 @ 11:18 PDT | General | Reply | CREATE MULTISET VOLATILE TABLE 0 row processed with ON COMMIT PRESERVE ROWS | Hi,
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... |
56 | 19 Sep 2013 @ 10:49 PDT | General | Reply | Should 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... |
55 | 19 Sep 2013 @ 10:47 PDT | General | Reply | Getting "x" in Teradata SQL Assistant but x in BTEQ | When 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 ... |
54 | 19 Sep 2013 @ 04:40 PDT | General | Reply | Replace blank('') as NULL in Stored Procedure | I 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... |
53 | 19 Sep 2013 @ 12:16 PDT | Database | Reply | Use of CTE within stored procedures | Many thanks Dieter for the valuable information!
|
52 | 18 Sep 2013 @ 10:13 PDT | Database | Reply | Use of CTE within stored procedures | It 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... |
51 | 18 Sep 2013 @ 11:19 PDT | Tools | Reply | Error 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... |
50 | 18 Sep 2013 @ 11:17 PDT | Tools | Reply | Installing the TTU 14.10 on windows | Hi,
The problem is potentially a result of an inconsistent/incorrect environmental variable (%AppData%).
Solution:
Open the Registry editor
Navigate to the followin... |
49 | 17 Sep 2013 @ 08:35 PDT | Database | Reply | DELETE 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... |
48 | 16 Sep 2013 @ 10:24 PDT | General | Reply | SQL return code in stored procedure in TD14 | Hi,
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... |
47 | 16 Sep 2013 @ 02:44 PDT | Database | Reply | Latest database tools to learn | If 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 ... |
46 | 16 Sep 2013 @ 02:35 PDT | Tools | Reply | SQL Assistant Preferences & DSN entries location | About 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... |
45 | 16 Sep 2013 @ 02:10 PDT | Tools | Reply | SQL Assistant Preferences & DSN entries location | The 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_... |