Hi, for Teradata 13.10, I am missing XSD schema file for XMLPLAN DBQ logging output referenced in Teradata documentation, "SQL Request and Transaction Processing", as an download on http://schemas.teradata.com.

Let's say I have these results from a subquery. They are are grouping by date with the MAX() of a unique identifier [xxxxx]. Assume the number appended to the unique identifer describes the highest number. This means the 05/08/13 unique identifer is the greatest.
05/05/13 xxxx1
05/07/13xxxx2
05/08/13 xxxx3

Hi, when I execute the following SQL

 sel doc_id
	, prd_id
	, prd_cmn_name
	, net_quant
	, mvt_gravity
	, cast(net_quant*42*(mvt_gravity*8.338426855)-0.0101578 as DECIMAL(19,13))
from monroe_prd.movements 

I am getting the following error:
SELECT Failed 2614: Precision loss during expression evaluation
Relevant table DDL is below

Hi,

I work for TD Czech Republic (Europe :) I have a problem with translation of Czech words into DDL. I create a view with this statement:

REPLACE VIEW CDSN_REP_V.D_ORG_PSC_HIER

AS
LOCKING ROW FOR ACCESS
SELECT
LHPP.id_par AS id_par_posta
,PPSC.id_zdroj AS psc
,PPNZV.nazev AS nazev_posta
--obvod
,OBVKOD.id_par AS id_par_obvod
,OBVKOD.identUdaj_hodn AS kod_obvod
,OBVNZV.nazev AS nazev_obvod
,REGKOD.id_par AS id_par_region
,REGKOD.identUdaj_hodn AS kod_region
,REGNZV.nazev AS nazev_region
,1 AS kod_cpost
, 'Česká pošta' AS nazev_cpost

Hi All

When I compile my procedure which contains comments, some(not all) comments are changed to /*_UNICODE '002A002A002A*/

I don't use special characters - just simple letters.

Do You know what should be done to see comments in normal text?

Perfect Query Timings needs to be captured.
 
Hello, we are using Teradata13.10 Version and using Viewpoint also. We are using OBIEE 11g tool to refreshing the reports.
Daily basics we runs 10000+ reports against to Teradata by using PROD_OBIEE_USER user (Only one User-DBQL log is enabled)

REPLACE VIEW Failed. 6922:  Illegal or unsupported use of subquery/derived table inside a recursive query/view.

HI All,
 

Teradata ONLINE TRAINING
Good online training offers the best Teradata online training with the industry experts as their trainers. All the experienced certified tutors will share their experience, tips and tricks in the SAP SD Online training course. We will provide More informations please contact us :
www.goodonlinetraining.com

Hello,
 
After running a set of queries, it was found that, there are various values of TotalIOCount.
These values range from few hundreads to as high as 23 * 10^6.
On a system with 14 nodes and 504 AMPs, how to we say whether these values are significant, not - significant etc?
 
Niteen

what is the difference between MERGE and UPSERT?
which one of them is supported in Teradata?

Hello,
Can compression be applied to indexes?
If so where can the syntax be found in documentation?
In database design document found that, compression can be applied to secondary indexes, join indexex and hash indexes. However there is no information on how it can be applied.
 
Thanks in advance.
-Niteen

Hi,
Same table created by different users in same database have different date format ie. One has YYYY-MM-DD and other YY/MM/DD.
Is this due to table def stored on a different AMP with different date format setting at database level.
Thanks,
Abhi

Hi,
 
Can someone please table whether we can provide coalesce for a column while creating table.
I have seen cases where you select using coalesce but could not find anywhere within create table
 
Thanks,
Sunitha

Hi there, I'm pretty new to the forums so if this is answered elsewhere feel free to point me in the right direction.
I am trying to create flexible stored procedures which take strings that correspond with dbname.table/viewname and then compare them to user input volatile tables and then output them into a new volatile table.  Here's a sample call:

Hi Guys,
I have a table which contains a start date and an end date
Table a
Start_date       End_date
13-03-2013     14-03-2013
10-03-2013     13-03-2013
.........
....
along with this i have another table which has the list of all bank holidays
table b
date                 day_of_week    bank holiday

Hi,We need to change the format of all our usernames and there are many usernames/userids.Does anyone have scripts or macro's that can be used to automate/simplify creating a new user with the same access rights and privileges as another user.Thnx,Marius

Problem Description
A typical lookup kind of JOIN between FACT table with hundreds of millions of web clicks, and DIM table with 55M IP ranges in numeric style (e.g. downloaded from MaxMind).

I am building a new table and my understanding is, since Terdata stores DATE datatype as integer, I need to specify a respective integer value in COMPRESS clause, i.e. to store compressed value of '2099-01-01', I would need to have COMPRESS 1990101 when defining column.  Please let me know if this is correct.
Thank you,

Dear esteemed experts,
I need to deliver to one of my end-users, an overview of the Used CPU & IO compared to their maxs, preferrably per hour.
I know i have to look at the resusage and dbql tables, but i rather not like to reinvent the wheel all over again. Does anyone have such querie(s) i could use.
It would be much appreciated.

Dear esteemed experts,
I need to deliver to one of my end-users, an overview of the Used CPU & IO compared to their maxs, preferrably per hour.
I know i have to look at the resusage and dbql tables, but i rather not like to reinvent the wheel all over again. Does anyone have such querie(s) i could use.
It would be much appreciated.

Hi All,
    Is there anyway to improve the performance(Reducing the CPU consumed is the main aim for now) of queries involving like in the where clause.
 
 
WHERE FIRST_NM LIKE :V_FIRST_NM||'%'
AND LAST_NM LIKE :V_LAST_NM||'%';

Is it possible to collect stats for VT's inside Procedures? 

http://developer.teradata.com/blog/carrie/2013/02/statistics-collection-recommendations-teradata-14-0
In the above link at the end its given as Currently, statistics are not supported on BEGIN and END period types.  That capability is planned for a future release.

I am observing a session thru View Point , which is in responding state for the past 10 days
The CPU Use is 0 but the Impact CPU is 33.7
Similary I/O is 0 but I/O skew is 55%.
Could anyone explain the meaning of the same ,how to interpret the information.