Hi,
I am new to Teradata, could anyone list the difference between Teradata 13.10 and Teradata 14 and new features which are avaialble in Teradata 14.
Thanks in Advance.

Hi ,

I have a smiple mapping where I take data from Oracle database ,use expression transformation to add certain parameter values and then push it to teradata box.

Now, it is running fine when I use relational connection however whe I use TPT connection it shows all rows being processed but nothing gets inserted into table.

Hi,
I am trying to compare the row count of table in two different databases but the tables are similar with same DDL. I need to call table name in cursor and database names are parameters of the procedure.  
Replace procedure testProc(a varchar(30),b varchar(30))
BEGIN
-- Cursor is having the names of table in order
OPEN MY_CURSOR ;

Hi,
Can someone tell me why the below won't work? I've tried everything I can think of.
The error I am getting is "expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between ')' and the 'Where' keyword".
Thanks
---------------------------------------------------------------------------------------------------
SELECT

We have implemented a 'Penalty Box' workload within TASM for queries that are demoted after reaching specific exception criteria with the idea that they go into a workload which has a low CPU allocation.
We have seen a high % of CPU be taken into the Penalty box and remain with the query for a significant period.

Every day i will receive a Flat file which i have Mload it in prod. So i have to check the Header in file and make sure it matches with old one.
File Delimited '|'

Eg : S_NO | LNAME | FNAME  (Given header)

Eg : S_NO | LNAME | FNAME (File header)

Some times source changes the header so i need pre check before i load.
Plz help me out

Hi,
As per my understanding, if I am sure that SOURCE will always send UNIQUE rows I should create Target table as MULTISET table as it will ignore the ROW LEVEL CHECK which a SET table performs to check for duplicate rows. So loading of data will be much faster in MULTISET table than SET table. Am I correct ?

Hi there,
I have heard that there is some script in on OS under teradata which check if Teradata and other components are alive or not. The same script (or similar) generates T@YS issues if system or database dies or make a DB restart.
The same script contains some log...
Have you heard about similar script or function in Teradata?

Is there a UDF or external stored procedure to convert varbyte to varchar in Teradata?

NFS Mount On Teradata Node

It seems that there is some error with below post as when I try to reply to this post it doesn't work. As a database person, I can guess, it is may be because of some locking issue or may be any other reason or I am the only one who is experiencing this problem
 

31546

30 Apr 2013 @ 08:40 PDT

I have a perplpexing issue, which seems to me must have a simple answer -
I am attempting to natch values  of  a column that contain embedded whte space of more than one consecutive <space> character
 
In other words if I have two character strings ,  
 
'ABC DEF'  ( 6 characters bisected by a single whte space )

TD 12 PRICE:
Teradata 12 Database Administration 160 USD
Teradata 12 Solutions Development    160 USD
Teradata 12 Enterprise Architecture     160 USD
 
TD 14 PRICE:
Teradata 14 Database Administration 10000 USD
Teradata 14 Solutions Development 10000 USD
Teradata 14 Enterprise Architecture 10000 USD
 

I have the following table:

CREATE SET TABLE hcclnc_ushare.O884450_table1 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
      per_name VARCHAR(11) CHARACTER SET UNICODE NOT CASESPECIFIC,
      start_time TIMESTAMP(0),
      end_time TIMESTAMP(0))
PRIMARY INDEX ( per_name );

Hi guys, the user guide says :Each AMP can perform up to 80 tasks in parallel.
who can tell me the meaning of "task", is it a request from users's application such as the select statement or the step within a sql statement?
sorry my english is not very well....i think you should understant what i mean。。。。right?   

I'm looking for ideas or a way to create a script that will take a flat file & import into a Teradata table with minimal effort.  I've used the Atanasuit FastLoad Wizard but there's too much manual set up for our environment.

Hello Everyone,
 
I was creating diffrent tables in database by taking year and date from the users with the help of '?' character but the problem is

HI,
I need to find a way to SUM a field where, IF it contains a '0', I want to replace it with some text or any other value.
So the value isn't NULL & NULLIF won't work.
The syntax would be something like 'IF((SUM(Billed_Amount) = '0'), 'No_Charge')).
Thanks for any suggests! 
 

Hi,
I need to know where I can find information about the end of mantenace of Teradata Model 5500C system both processing and storage.
I need also information about the EOM of NCR UNIX MP-RAS V3.03.
I sing in in the web of NCR and Teradata and I find nothing.
thanks!

I need to run an insert query in a BTEQ based on the number of records in another table. 
SELECT BU_ID FROM TABLE1 WHERE BU_FLAG = 'A';

Hi ,
 
We are getting error 
"Internal error: Please do not resubmit the last request.  SubCode, CrashCode:   0,  3701"
Teradata error code is 3610.

I am doing a query in which the results of a previous row calculation are used in the next row calculation (recursive I guess).
 
For example the results should look like this:
 

Item

Loc

Week

A

B

C

Inventory (Prev Inv + A + B - C)

1111

aaaa

201301

Hi
I have a table and while loading the table , if the column is INTEGER then blank from SOURCE is converted to 0 i.e. numerical ZERO.  Why is this happening ? Does this mean we cannot have BLANK value in integer column ?
The problem is I cannot identify if the 0 was sent from Source or it is converted from BLANK value.
Any suggestion ?
Thanks in advance .

I get the full data for each category instead of getting the full total for each category. For example the output came out 9936 instead of 5 rows with totals
SELECT
 SV.CATEGORY_DSC,
 SUM(SV.BILL_UNIT_CNT) BILL_UNIT_CNT,
 SUM(SV.BILL_DAY_CNT) BILL_DAY_CNT,
 SUM(SV.BILL_AMT)BILL_AMT
 FROM EDWMTH.CL_BILL_MTL SV,
     EDWMTH.CL_SUMM_MTL SM

UnifiedSQL