All Forums

For topics that do not belong to another forum. This includes general development topics, such as Java, .NET, User Interface design, etc., as well as discussion of the Teradata Developer Exchange itself. For articles, blogs and more, see the General section of the site. Do not post SQL or database questions here; they belong in the Database forum. JDBC/ODBC questions belong in Connectivity.

You must login to post to the forums.
Teradata Forum Account Temporarily Blocked Topic by sallad 12 Jul 2016

I am logged into my work computer (this is how I am posting right now) but when I logged into a virtual machine I got the password wrong and now I see that my account has been temporarily blocked.  How long does the temporary account block last?

136 views
0 replies
cumulative sum and moving average Topic by zarina 03 Jul 2016

Hi All
 
I am new to teradata and looking for the teradata query for the below situation
query to retireve cumulative amount and moving average salary for each employee in the reporting period of the first 6 months of 2015

112 views
1 reply, 3 years ago
HOW TO GET ODD NUMBER ROWS IN A TABLE IN TERADATA Topic by Purushotham 09 Jun 2015

Hi everyone,
 
Could you please attach the query for getting the odd rows in a table;
eg : id name sal 
       1 puru   2000k
       2 kiran   3000k
       3  hari    4000k
       4  mani    5000k
      5   suri      6000k
 
I need output as : 1 puru 2000k
                         3 hari    4000k

1060 views
4 replies, 3 years ago
Update statment is getting failed Topic by kartaj 04 Jul 2016

Hi team,
I was trying to update sample 100  active records with a specific date('2016-07-04'), But my query is getting failed...(i have tried using with qualify rank, even it was not working), can you please help me with the query
Query :
UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04' WHERE EFF_END_DT = '9999-12-31' AND COL1 IN

179 views
5 replies, 3 years ago
Teradata to AWS(Redshift) Topic by anoopjohn 07 Jun 2016 Teradata to Redshift, teradata to AWS

Hi Team,
 
I have a table in Teradata with more than 9 Tb data.I need to copy the entire content of this table to AWS-Redshift DB.
I have identified below options ,
1.Fast export the Teradata table content into flat files ,then SCPs these files to AWS servers and then load Redshift

240 views
2 replies, 3 years ago
Query issue Topic by BI_guy 30 Jun 2016 teradata, query

Query -

247 views
3 replies, 3 years ago
how to find frequently used data in a table of Teradata Database Topic by arkaprava.chandra 30 Jun 2016

Hi All,
could you please tell me, how to find frequently used data in a table of Teradata Database?
Portions of data within tables that were accessed within last 2 years – Ex, if a table had 5 years of data and only 2years of data is being actively used, the plan is to archive the unused data.

113 views
0 replies
Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS Topic by arkaprava.chandra 29 Jun 2016

HI All,
Could you please tell us, what is the basic difference between DBC.ROLEINFO and DBC.ALLROLERIGHTS?
Some roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTS.
 
Thanks,
Arka

108 views
2 replies, 3 years ago
Store Backup of table strucutre into an table Topic by radsubra 26 May 2016

Hi,
 
We want to store backup of table structure into a table every week . What would be the best way to achieve this.
For example we want to get the table structure for all the tables in one particular database using show table and then store that information into a table
 
THnaks,
 

135 views
1 reply, 3 years ago
transpose in teradata(columns to rows viseversa) Topic by mlogan24 20 Apr 2016 transpose--rows to columns

Hi All,
I have a requirement to convert rows into columns in teradata.
source:

Mode

col1

col2

col3

col4

Air

3

1

2

10

Sea

4

5

6

7

road

6

4

1

7

train

1647 views
7 replies, 3 years ago
table needs change Topic by totalzoom 24 May 2016

Hi, I have table like below: All i need is if  roll# has flag in mutiple columns highest heirarcy column should show the flag and rest columns should be null 
for eg:
 
125 has flag is both auto & small = i want only small flag to be shows and auto flag to be null becasue small is higher in heirarchy than auto
another eg:

139 views
3 replies, 3 years ago
Join Index Topic by pundrikv 25 May 2016

Hi 
At what situation or condition PE decide to take the data from the  JOIN INDEX  or  from the normal join.
 
Thanks

194 views
1 reply, 3 years ago
How to detect updates in a teradata table at runtime without using timestamp column or last acess time stamp, Topic by Romil 24 Jun 2016

How to detect the teradata table updates and how to determine it at runtime. My requirement is to import from teradata and at runtime whatever updates have happened ..need to import those latest changes at runtime. Any suggestion please ?

99 views
1 reply, 3 years ago
steps to install td-ttu-15.10.05_for_Windows Topic by rharitha7 25 Jun 2016 rharitha7

Hi,
 
I've installed td-ttu-15.10.05_for_Windows and extracted the zip file. can someone please share me the steps to install td-ttu-15.10.05_for_Windows.which setup file has to be installed and other configuaration to set up connectivity.
 
Thanks in advance.

243 views
3 replies, 3 years ago
Retrieve columns having a specific value Topic by Jok3r 21 Jun 2016 columns, value

Hi,
I have 100+ columns. I need to retreive columns having a specific value [Say 'ABC'] in any of the rows. 
Please help. 

153 views
3 replies, 3 years ago
Assign values based on dates by group Topic by ericawang0829 20 Jun 2016

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-01-06
I would like to assign "initial" to the oldest date, "recent" to the most recent date, and the others "interim" according to groupID (1,2).

114 views
1 reply, 3 years ago
How to download and install teradata on windows 10 Topic by inDiscover 04 Jun 2016 teradata

I am very new to the Teradata world. Have much interest to learn Teradata.
Can any one help me install "Teradata" on Windows 10. A step by step guide will be much helpful.
I tried this in Google but didnt get any useful link.

318 views
5 replies, 3 years ago
Install Teradata Windows or Open Suse Topic by Jossymedina 04 Jun 2016

Hi good day! someone could tell me how can I install install or to use Teradata window? if possible?

 

I install vmware player and virtual teradata express but still it does not work. would someone kindly explain how to do it or should I install.

 

Thank you very much.

118 views
2 replies, 3 years ago
to remove duplicates Topic by anand82 11 May 2016

Dear Friends,

2453 views
2 replies, 3 years ago
Merge with TIMESTAMP column PK Topic by rubenjdc 13 Jun 2016

Hi everyone.
I need to merge some data what i  have a 3 column's UPI (col1,col2,col3), col 1 and col2 are a varchar but col3 it's a timestamp.
Im trying to merge but teradata studio show me an error, what i have a pk duplicated.
I test before with count and count distinct using only the UPI columns and i dont have any duplicated

175 views
1 reply, 3 years ago
Passing Parameters to Bteq in Mainframes Topic by niranjan_nr000 08 Jun 2016 Parameterizing in Mainframe, Teradata BTEQ mainframe parameter

Hi,
I am working with maniframe / teradata .. 
Consider 2 databases "A" and "B".. I need to load table existing in database A using tables present in database B.
I want to parameterize the database name using mainframes. Any Suggestions?
Something like below:
INSERT IN A.TBL1
SEL * FROM B.TBL1 x1
JOIN B.TBL2 x2
ON x1.c = x2.c

100 views
0 replies
Order of execution in Qualify clause Topic by zulfi123786 06 Jun 2016 qualify
CREATE MULTISET VOLATILE TABLE V_CURRENT_DATE
(
ID integer,
ID_VALUE VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC 
)PRIMARY INDEX(ID)ON COMMIT PRESERVE ROWS;

insert into V_CURRENT_DATE
values (10,'one');
insert into V_CURRENT_DATE
values (11,'two');
insert into V_CURRENT_DATE
values (12,'three');
insert into V_CURRENT_DATE
values (13,'four');
268 views
2 replies, 3 years ago
PDCR tables CleanUp Topic by Ramesh.2914 21 Jul 2012

Hi ,can someone tell me the steps to CleanUp PDCR tables.

8050 views
5 replies, 3 years ago
What the hell is wrong with you??? Topic by RichHolt 01 Jun 2016

Seriously, 19 tries to get a captcha that is somewhat readable, and then copy/paste a freakin' key string into a textbox *JUST TO DOWNLOAD THE LATEST TERADATA ODBC SUITE*. Why ??? This is not a secret download for cryin' out loud! Its a DRIVER SETUP PACKAGE.

167 views
2 replies, 3 years ago
FDL4822 DEFINE statement rejected. Topic by meta 01 Apr 2010 fastload error

Hi
Iam trying to load a small sample data using fast load..and Iam getting the following error..
Can any one help me please..

FDL4822 DEFINE statement rejected.

and log file is as follows:

0001 logon 127.0.0.1/dbc,

**** 17:27:42 Teradata Database Release: 13.00.00.00
**** 17:27:42 Teradata Database Version: 13.00.00.00
**** 17:27:42 Current CLI or RDBMS allows maximum row size: 64K
**** 17:27:42 Character set for this job: ASCII
**** 17:27:43 Number of FastLoad sessions connected = 2
**** 17:27:43 FDL4808 LOGON successful

0002 DEFINE

(EmpNo (smallint),

6034 views
3 replies, 3 years ago

Pages