194 | 15 Nov 2013 @ 03:19 PST | Database | Reply | Get previous column vale till it reaches another not null value | Bikky,
I dont know why my previous post is published empty. But you can get detailed information about this claues at teradata info home.
The URL is as follows:
http://www.info.teradata.com/ht... |
193 | 15 Nov 2013 @ 03:17 PST | Database | Reply | Get previous column vale till it reaches another not null value | Bikky,
You can get a detailed information about this clause at teradata info home. The URL is as below:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_... |
192 | 15 Nov 2013 @ 03:07 PST | Database | Reply | Get previous column vale till it reaches another not null value | Hi Bikky,
I hope the following query will fullfil your requirement.
SEL
M.EMPNO AS MAIN_EMP,
M.EFF_DT AS MAIN_DT,
--L.TYPE_CD,
MAX(TYPE_CD) OVER(ORDER BY M.EFF_DT RESET WHEN TYPE_CD IS NOT ... |
191 | 15 Nov 2013 @ 01:34 PST | Tools | Reply | Problem using Teradata import - making me crazy!! | Hi Sure,
Can you please paste some sample data from the file you want to import?
|
190 | 14 Nov 2013 @ 09:44 PST | Tools | Reply | Utilities interacting with mload | Raja,
Probably you have got answer from Tom :)
|
189 | 14 Nov 2013 @ 04:31 PST | Database | Reply | Move column data as rows | Hi,
If you want to put data in all columns into a single column then the technique advised by Raja will obviously work. But if you want to place the data in these column into a single row then you... |
188 | 14 Nov 2013 @ 04:28 PST | Tools | Reply | Utilities interacting with mload | Raja,
Utilities are a mean to interact with Teradata database, Mload is istself a utility to interact with teradata database.
Can you please elaborate your question, what do you mean by &qu... |
187 | 14 Nov 2013 @ 12:35 PST | Tools | Reply | Installing BTEQ / MLoad on Windows 7 | Hi,
The installation of BTEQ and MLOAD is quite straight forward on Windows-7. You just need to run the setup.exe for TTU and the select the required components you want to install. You do not nee... |
186 | 14 Nov 2013 @ 12:31 PST | Database | Reply | Have NULLs in DATE fields always been possible? | Hi,
All RDBMS should allow nulls to capture all the business scenarios, But it is Application designers decision to either keep the null, or some constant value instead of null to represent some b... |
185 | 12 Nov 2013 @ 10:07 PST | Database | Reply | Problems with dynamic creation of Volatile tables | Hi,
The first thing is I am not sure you can create an index on volatile table. But if still it gives you that 0 rows have been processes. then the table is their, I think it is a problem with you... |
184 | 12 Nov 2013 @ 10:57 PST | Database | Reply | Can we Have a Column Partition on a MLOADED table? | Hi Rakesh,
As per my knowledge Fatload,Multiload is not suppported with the following:
To load a table with USI, NUSI
Column Partitioned table cant be loaded with Multiload
Tab... |
183 | 12 Nov 2013 @ 10:03 PST | Database | Reply | SQL MERGE Detecting Duplicate Rows | If you are using Merge statement in TPT Operator, then it inserts the UV violated rows into a table name with TableName_UV. You can analyse that table to get the rows not inserted due to duplicate ... |
182 | 12 Nov 2013 @ 02:18 PST | Database | Reply | Recursive Query | Sarah,
So you main target is to get the latest_DND, Does this means that a DND goes through diffrent values? like at start it is 105 and at the current value is 4008. from this data, I assum... |
181 | 11 Nov 2013 @ 02:20 PST | Database | Reply | Move column data as rows | Your data output is not understandable, Can you please give some more description? and also paste the data in correct format?
Like currently, it seems that you want to see this data in a coolumn!
... |
180 | 09 Nov 2013 @ 02:26 PST | Database | Reply | Recursive Query | Sarah,
Can you please paste your recursive query code?
|
179 | 09 Nov 2013 @ 01:04 PST | General | Reply | Teradata Express 13.0 for Windows | Hi Srini,
you can download a full working VMware edition of Teradata Express 13 and 14 from the link:
http://downloads.teradata.com/download/database/teradata-express/vmware
|
178 | 09 Nov 2013 @ 12:54 PST | Database | Reply | Recursive Query | Hi Sarah,
Yes you can use more than on table in source using joins.
Syntax:
WITH RECURSIVE <query name> AS
(SELECT COL_list FROM A
INNER JOIN B
ON A.Col = B.Col
UNION ALL
<RE... |
177 | 08 Nov 2013 @ 11:08 PST | Database | Reply | Delete or Drop a table if it already exists | I believe if this code is working in SQL Assistant then it will run in any odbc compliant GUI.
Have you tried it using alteryx?
|
176 | 08 Nov 2013 @ 03:10 PST | Database | Reply | Joining tables from two different servers | you can consult the following thread:
http://forums.teradata.com/forum/database/compare-two-database-tables-row-count-in-each-table-which-are-in-different-servers#comment-86684
|
175 | 08 Nov 2013 @ 01:49 PST | Database | Reply | Dynamic Table Names | I think you can create a parametrized macro to create a table for every month. just pass the current month in the parameter and execute the macro.
To combine data from all of these tables, you can... |
174 | 08 Nov 2013 @ 01:45 PST | Tools | Reply | SQL Assistant upgrade causing heartburn! | Raja,
The answer is yes, The use of Teradata studio is much easy, and provides more information in different windows. It is much easy to use for peaple coming from Microsoft background, especially... |
173 | 08 Nov 2013 @ 01:38 PST | Database | Reply | Joining tables from two different servers | Hi,
I think it would not be possible for a query to get data from two different servers. One alternative is to copy the smaller table on the other server and then run your query.
|
172 | 08 Nov 2013 @ 01:35 PST | General | Reply | Change a tables datatype in a Column for Joining | Hi,
I agree with Vlad, if you convert the varchar column to Integer, the join will become much fast, and also storage will be saved. you can go for integer.
|
171 | 07 Nov 2013 @ 08:11 PST | Tools | Reply | Will the TTU 13.10 work against Teradata Database version 14.10? | I think their will be no issue about the use of TTU 13.10 with 14.10 Database. You will not be able to take benifit of some 14.10 features but connectivity will not be an issue, especially in the c... |
170 | 06 Nov 2013 @ 02:23 PST | Database | Reply | Conditional statement in Teradata macro | Hi,
in addition to the above sequence your string in WHERE Clause whould be enclosed in single qoutes, like this
WHERE Department = 'Adult Medicine'
|