| 57891 | 20 Jun 2016 @ 11:37 PDT | dnoeth | Database | Reply | Recursive Query Vs UNION | Seems like you want to return only the weeks with no negative value in the current and next week.
This should be a simple task using OLAP-functions like this:
select a,b,c
from
(
select ... |
| 57890 | 20 Jun 2016 @ 11:08 PDT | dnoeth | General | Reply | How to download and install teradata on windows 10 | http://lmgtfy.com/?q=teradata+express+download
|
| 57889 | 20 Jun 2016 @ 09:50 PDT | Priti_Kanal | Database | Reply | Dynamically select TOP N rows from table | Thanks for helping to resolve the issue...!! :)
|
| 57888 | 20 Jun 2016 @ 08:44 PDT | toadrw | Tools | Reply | Easy Loader Skip Column in Flat File | Thank you for the response Steve! Appreciate your help once again!
|
| 57887 | 20 Jun 2016 @ 06:57 PDT | rharitha7 | General | Reply | Install Teradata Windows or Open Suse | hi
i installed vmplayer. where i can get the virtual teradata express. help me through this.
Thnks.
|
| 57886 | 20 Jun 2016 @ 06:54 PDT | rharitha7 | Teradata Database on VMWare | Reply | Confused over which VM to download | hi
where i can find TDE for vm ? please help me through this.
Thanks.
|
| 57885 | 20 Jun 2016 @ 06:52 PDT | rharitha7 | General | Reply | How to download and install teradata on windows 10 | hi
can someone tell me where i can find teradata for vmware?
thnks
|
| 57884 | 20 Jun 2016 @ 03:38 PDT | mhussey | Teradata Studio | Topic | Teradata Studio does not show all of my authorized tables- | I started working on a new project a few weeks ago, which requires me to use Teradata, Hadoop, and Aster. That being the case, I want to use Teradata Studio instead of Teradata SQL Assistant. Conne... |
| 57883 | 20 Jun 2016 @ 03:12 PDT | ericawang0829 | General | Topic | Assign values based on dates by group | I have a table looks like this:
groupID Date
1 2016-01-03
1 2016-01-02
1 2016-01-01
2 2016-01-04
2 2016-01-05
2 2016-... |
| 57882 | 20 Jun 2016 @ 12:16 PDT | feinholz | Tools | Reply | Easy Loader Skip Column in Flat File | This is not currently available with "tdload".
In order to do this, you would need a script so that the "SELECT" portion of the APPL-SELECT canbe used to filter out the... |
| 57881 | 20 Jun 2016 @ 12:09 PDT | toadrw | Tools | Topic | Easy Loader Skip Column in Flat File | Hello:
Is there a way to only load specific columns from a flat file using tdload? Say my flat file has five columns, but I only need the last three. Is there anyway to specify the fir... |
| 57880 | 20 Jun 2016 @ 11:39 PDT | feinholz | Tools | Reply | Need Help regarding TPT ODBC Operator | The bundling of DataDirect drivers was first supported with TPT 14.10.00.06.
If you upgrade to that efix level, you will get the drivers.
However, you do need license files in order to use the dr... |
| 57879 | 20 Jun 2016 @ 09:51 PDT | Harkrish | Database | Reply | LOBs are not allowed to be hashed issue in Recursive query | Hi, I am facing the same problem. Can you put it over here if you were able to overcome the issue?
|
| 57878 | 20 Jun 2016 @ 09:30 PDT | jobbazar | Tools | Reply | Using Geospacial Import/Export java tools | I am also facing the same issue.
Can't laod IA 32-bit .dll on a AMD 64-bit platform.
The error is related geojni.dll when it is linking.....
Any idea how to fix this?
Is there a 64 bi... |
| 57877 | 20 Jun 2016 @ 08:53 PDT | klaement | Tools | Reply | Need Help regarding TPT ODBC Operator | Thanx Carlos,
I will try to convince them that they have no choice but to buy it if they want it.
Regards
|
| 57876 | 20 Jun 2016 @ 08:19 PDT | dnoeth | Database | Reply | Dynamically select TOP N rows from table | - use QUALIFY ROW_NUMBER instead of TOP
- use dbc.ColumnsV instead of dbc.Columns
- without ORDER BY the result is random
If it's always all but the last four columns:
SELECT COLUMNNAME
... |
| 57875 | 20 Jun 2016 @ 06:47 PDT | Priti_Kanal | Database | Topic | Dynamically select TOP N rows from table | Hi All,
I need to perform dynamically select TOP N row from table.
SELECT TOP (10-4) COLUMNNAME
FROM DBC.COLUMNS
WHERE DATABASENAME='DATABASE_NAME'
AND TABLENAME ='TABLE_NAME';... |
| 57874 | 20 Jun 2016 @ 04:37 PDT | archana_2016 | Tools | Reply | Usage of GetRow method in TPT API for exporting table data into csv | Thanks Steve for your valuable information!
|
| 57873 | 20 Jun 2016 @ 04:07 PDT | dnoeth | Database | Reply | After Insert trigger | Well, this is a website which simply copies the error descriptions from Teradata's Messages manual.
http://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/index.html#page/General_Reference/B035_10... |
| 57872 | 20 Jun 2016 @ 03:02 PDT | crochlit | Database | Reply | After Insert trigger | The issue is well explained on this page:
http://teradataerror.com/5424-A-triggered-action-statement-is-the-wrong-kind.html
"SET" can only be used in a BEFORE row triggers
|
| 57871 | 19 Jun 2016 @ 11:56 PDT | NiteshM | Database | Reply | Recursive Query Vs UNION |
Table T1
Column A Column B Column C Column D
123 001 1/1/2016 60
... |
| 57870 | 19 Jun 2016 @ 09:20 PDT | AVOT | Viewpoint | Topic | Data Labs Upgrade Question | Hi Teradata Gurus
I am currently working on a project where I have installed Data Labs 15:00 (tddatalabsportlet v15.00.00.04-1). I installed Data Labs on the Viewpoint (version 15.00.00.01).
I wi... |
| 57869 | 19 Jun 2016 @ 02:52 PDT | CarlosAL | Tools | Reply | Need Help regarding TPT ODBC Operator | Hi.
The bundled versions of DataDirect Oracle ODBC drivers have a 'trial period' and then a message of 'license expired' appears.
I think the last TPT 14.10 versions have the driv... |
| 57868 | 18 Jun 2016 @ 05:05 PDT | Jhossymedina | Database | Topic | sql create database | I would like to know how I can do a sql to create my database with permission and install the vmware version does not work so I do graphic
|
| 57867 | 18 Jun 2016 @ 01:19 PDT | dpalepu | General | Reply | interview help | Dear Anand,
Please email to dpbits710@hotmail.com
Thanks in advance,
Durga Prasad.
|
