0 - 50 of 223 tags for teradata

I want to write SQL UDF with Multiple Lines:
1. Declare variables.
2. Set those variables with select into statement.
3. some if conditions on Variables
4. return some value.
What is the syntax to write this.
I'm using teradata Version

Can Anyone Suggest me where teradata jobs are available.

I am exploring business calendar functions in teradata. There are some of the business calendar functions like td_week_begin, td_week_end, which takes timestamp with time zone value in first argument and time literal value in third argument, Second argument is the calendar type like iso, teradata.

We have a Customer asking this question:
-----Original Message-----

Hi all,
   I need to get data from users from a webpage (jsp) and connect to a teradata database and load them into the tables in the database. I am using jsp to create the webpage. Is it possible to directly connect to the teradata database by scripting in jsp?. If so, some guidance will be appreciated. Thank you

Am looking to find out where does the Checksum metadata values of the datable got stored.
Here when I run a query
        "Column1" CHARACTER(5),
        "Column2" CHARACTER(5)

I am facing a problem when writing a case statement, 
Here is the sample query

I am teradata developer I  worked in teradata technology  last 2 years . i have taken 2 year gap  and searching for  oppurtunities . Can anyone suggest good  big training institutes in USA / any other certifications that  help  to improve my career.

I want to Update a table. But before that i want disable foreign key\check Constraint\Unique Key on some tables.
After update, i want to enable those disables constraint again.
Can you please tell me how can i do that.

We are upgrading from Teradata 12 to Teradata 14, and DataStage 7.5.2 to DataStage 9.1
Existing Teradata DataStage stages will not be converted.  The following parameters are used to read and write from Teradata.

Parameters to read From Teradata 14

I have been developing a demo MVC application and trying it to connect to Teradata Database. But I have been failing since long . I tried whatever I could do as a newbie to this field but apparently have not been able to solve the problem.

I'm new to TeraData. Following is the script i am using to create to While loop in Stored Procedure.
But TeraData Studio is giving me Syntax Error:
can we use loop in Stored Procedure or is there any other way to do that.
Kindly suggest.
        IN i INTEGER,

Looking for Teradata job in USA
              please help me.


What distinguishes set processing from row processing?

Set processing normally applies to primary key operations.

Set processing is unsupported by Teradata Utilities.

Set processing efficiently updates large amounts of data.

Set processing is seldom an all-AMP operation.


Can any one answer my Question...How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's

In our database we have a system-generated ID that is built off of the timestamp. It’s not a date or time format, it’s a string, like (20130405103422), which is essentially the year, month, day, hour, minute and second that the record was created. I want to join it to another field, which is date, but I need to convert it first. How do I do that

Explain Fast Load in Teradata?


What is Teradata & how does it differ from other conventional Systems?


Hi Team 


While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.


-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual




-- Teradata

Hi Team 


While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.


-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual




-- Teradata

So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.

Hello Experts:


What's the difference between NOT IN and minus  in SQL? 


Which is better to use in SQL queries for the performance aspects?

Can we ALTER/add/delete the partitions created on CP(columnar Partition) table? Please specify the way to do so, if any.
If at any point of time after the CP table is creared, can I delete/add any columnar partition to the exisiting table? Or the table need to be recreated?

I am very new to teradata. Please help me. 
Is it possible to connect to teradata using Entity framework 6.0. 
If so, is there any sample application or source code(some kind of tutorial) for reference.
Previn S

Every tried to figure out the exact ETL/ELT process that is running some sql statement from within the database..... good luck with that!

Query Banding is part of Teradata's workload management features BUT can also be simply used to trace exactly what process is executing something.

id   16hex   
aaa  28E1
id    decimal 
aaa   10465

How did Teradata get its name? Does mistletoe grow in parse trees? If there are “virtual AMPs” are there “virtual Watts” as well?

In my server I am running TD Express for VMware, version TD14.10. I have created several users and have no relevant data there (its a sort of sandbox for some users).
I would like to create all the users and keep the same passwords. I am guessing that this could be done exporting and loading some tables into TD15?

My PreSQL query in the WorkFlow of Informatica had 2 parts, 1.Insert query 2.Refresh Stats procedure call In the absence of a ';' between these 2 parts gives me record count in Millions but in the presence of the ';' it gives me record count in Thousands.

whenever i run any query in terdadata, i am getting blank result in columns having VARCHAR or CHAR data type. using windows 7.  please help if anyone have idea. not able to understand why CHAR values are not showing in the answersheet result?

I need to convert these statments from using  AT TIMEZONE to FROM_GMT2.  Help is very much appreciated
c_timestamp is a column of timestamp(0) type

Hello All,
The way I see Teradata is...Node contains multiple PE & AMPs. PE handles the user sessions in addition to other activities and AMPs service the data movement amongst other role. Considering a production system having say, 50 Nodes...I seek clarification on the following 02 topics:

Hi All,
I want to install teradata on a linux machine. 
1) Do we have a teradata version directly for linux or do we need to install a vmware player in linux and use teradata for vmware player.

Hello All,
Teradata Utilities are specialised tool for loading or exporting huge volume of data as compared to conventional SQL tools like SQL Assistant & BTEQ. I wish to learn the fundamental performance gain reason between them. I have provided my understanding on them below. I would appreciate any addition/correction to them.

I have a table to be updated having 3 columns ext_JobGroupCd,ext_JobCd,ext_OrderIngroup

I am a newer to teradata database, and I want to study teradata database systematically all the time by a classical book about teradata. But I could not find such that book as introduce teradata. Can everyone recommed one book to me? it is better to tell me where download it. Thanks very very much .

We are using Teradata Parallel transporter (TPT) loaders as both source and target connection.
     Source     - TPT Export
     Target      - TPT Load
Using that performance has improved significantly compared to relational connection.

Does anyone know how to connect to a DB View with OData service in Visual Studio?

I have a java udf that basically just does a bunch of shows on each and every procedure and macro and then inserts those into a table. The jar is installed and my definition for the procedure is below. The problem i'm getting is i keep getting the error:

Folks - if ANYONE out there wants to join me in getting access to TPN+ membership reply or IM me ( preferably if there, IM in the forum that is ) . I have  been in Terdata world for a long time - technology has now changed drastically from what it used to be during V2R3/5/6 days .

Linux Environment Details:
Linux version 2.6.32-431.3.1.el6.x86_64 (mockbuild@x86-003.build.bos.redhat.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC) ) #1 SMP Fri Dec 13 06:58:20 EST 2013

Hi all,
I need to know the syntax for calculating the day number of the year for a date in teradata SQL.

It has become very slow fetching an answer set (serval seconds per row) during last several days using Teradata SQL Assistant. I never experienced this problem before. Rebooting the computer does not help. People use Teradata SQL Assistant in our office pritty intensively, but no one has ever experienced this problem. Please help.

When I am trying to export data from Hadoop Hive to Teradata I am getting Datatype mismatch exception, especially for Date and Decimal format.
Just for testing, I tried to export the same Hive table to TD, that was imported from TD into Hive with same schema. But it didn't work.

I've been trying to download the TDE for VMware (4GB). Its not downloading. Are they unavailable at present. Are the VMware versions of Teradata Express for 64 bit the only option? They seem to be problem prone.