All Forums

Topics related to the Teradata Database, excluding database connectivity (e.g. JDBC) and extensibility (e.g. UDFs) . Typical topics are about SQL syntax and usage (SELECT, GROUP BY etc), database performance, use of database functions, comparison with / migration from Oracle or DB2, and generally why the Teradata Database rocks. For articles, blogs and more, see the Database section of the site.

You must login to post to the forums.
TD Join Indexes Topic by eejimkos 1 hour ago

Hello,

15 views
0 replies
TD 14 Soft RI Topic by eejimkos 1 hour ago

Hello,
Thanks in advance for your time.
What possible issues cause with Soft Ri implemented when ,
1)I have foreign keys (on fact table) ,which they do not exist on my dimension?
For example , i have transactions for dates which these dates do not appear on my calendar dimension.

11 views
0 replies
Timestamp format on teradata retrieval Topic by jas 07 Mar 2006

I have a parameter string coming into an ETL application which is in the format MM/DD/YYYY HH:MI:SS.On the teradata database the rows I need to retrieve contain a timestamp in standard teradata format YYYY-MM-DD HH:MI:SS.

90904 views
11 replies, 2 hours ago
Calling procedures inside procedures in Teradata Topic by drmkd17 5 hours ago stored procedures

Hi Techies,
 
I am working on a stored procedures which has  cursors dynamic sqls and two calls to other procedures. My procedure is working really slow. I want to know if calling procedures inside another procedure makes it slow?
Please provide your expert comments.
 
 
Thanks

12 views
0 replies
Calling procedures inside procedures in Teradata Topic by drmkd17 5 hours ago

Hi Techies,
 
I am working on a stored procedures which has  cursors dynamic sqls and two calls to other procedures. My procedure is working really slow. I want to know if calling procedures inside another procedure makes it slow?
Please provide your expert comments.
 
 
Thanks

8 views
0 replies
Thoughts on CPUBusy caclulations. Topic by Random_Thought 29 Jul 2009

A few people in our organization are slightly disbelieving of the CPU utilisation charts I produce, they always focus on the CPU utilization charts, as if it is the only metric to be interested in.(But thats a different post)

We use Linux based TD nodes, and I use the DBC.ResUsagespma table to extract the CPU utilisations.

10702 views
25 replies, 6 hours ago
9804: Response Row Size/Constant Row Size overflow Topic by hyma 1 day ago

I have a Query. It ran for a long time without any problem. Few days ago the query suddenly got the error: 
9804: Response Row Size or Constant Row Size overflow.
All checks that have been done just tell me that it's not really the row size that makes problem.
A DB restart didn't help.

47 views
2 replies, 7 hours ago
Timestamp Format Topic by deepthi.narayanasetty 1 day ago

Hi All,
I am having one column which is in timestamp(6) format in source and i need in below varchar  format.
Source Column data type: ASSOC_ASGN_TS TIMESTAMP(6),
Target Column data type: varchar(26)
Desired Format: 2014-06-27-20.19.04.757246

75 views
4 replies, 7 hours ago
A Sort Table Changes Topic by williamzeng 1 day ago Teardata, sql, sort

Hi Gurus,
    Could you help me with the problem below?
    I have created a SET table with two columns: user VARCHAR(12) and prob FLOAT.
    I would like to acquire 3000000 user with bigger prob.
    So, I do like this:
    Step 1,

61 views
3 replies, 11 hours ago
Mvc Compression and Collect Stats on TD 14 Topic by eejimkos 2 months ago

Hello,
Thanks in advance for your time.
I would like your thoughts on collecting stats.

231 views
7 replies, 14 hours ago
remove line feed, carriage return from column Topic by mfgfd 23 hours ago replace, hex strings

Hello,
does anyone know how to remove some non-printable characters from a string in a column?
I imported data via OLE-LOAD from a MS SQL server. At least one column contains '0D0A'XB or '0A'XB. This delivers undesired results when exporting via Parallel transporter. So I have to remove those hex Strings, but
Oreplace(column, '0D0A'XB, '2020'XB) is not allowed

49 views
2 replies, 16 hours ago
Avoid Product Join Step Topic by Ashwin4tera 4 days ago Avoid Product join, Understand Step, explain terminology

Hi,
Could you please suggest how to avoid this product join step and explain about this step.
Usually how should i understand this kind of steps all stats seems to be up to date on these columns.
 

90 views
4 replies, 16 hours ago
Declare and Set then Open and Fetch Topic by comptrtoy1 1 week ago

If I understand correctly, I am trying to convert a Declare, Set then Open and Fetch. I need to do this in a SP? If so does anyone have an example of using all of these in one SP?
I need to create the table
Declare the values
Set the values
Declare the cursor as Select * from table

113 views
4 replies, 17 hours ago
Partition integer date key by month Topic by goldminer 1 week ago

Hello All!
 

80 views
4 replies, 19 hours ago
compression calculations Topic by n_shashi 10 Mar 2014

Hi,
 I've a requirement of finding the columns which are best suited candidates for compression. I've around 80 tables in my database. Can somebody suggest if we have any SQL's which give us calculations related to compression so that columns for compressin can be decided.
Thanks in advance 

245 views
5 replies, 22 hours ago
Identify Set - Multiset Tables in TD 14 Topic by eejimkos 18 Apr 2014

Hello,
1.Is there any way to identify the set-multiset tables in TD14?(except the like expression on request text)?
2.Still the syntax create table as... , does not include the constraints?
 
Thank you very much.

294 views
10 replies, 22 hours ago
3707: Syntax error... between the 'BETWEEN' keyword and ':'. - in Macro/OLAP Topic by banan 1 day ago

Hi All,
Is it possible to use Macro parameter in an OLAP function?
REPLACE MACRO m1 (sm_limit INT) AS
(
SEL
    d1
    ,SUM(d2) OVER(ORDER BY d1 ROWS
        BETWEEN :sm_limit PRECEDING AND CURRENT ROW) AS sumi
FROM table1;
)
i got error 3707.
We have Version:
    InfoKey    InfoData

20 views
0 replies
hexadecimal--->decimal Topic by lijianguonew 3 days ago teradata

hexadecimal--->decimal 
 
id   16hex   
aaa  28E1
 
 
Result:
id    decimal 
aaa   10465

47 views
2 replies, 1 day ago
help with SQL Topic by td_admirer 1 day ago

Hi Gurus,
Could you please help me with the below SQL? I need to merge the columns from a few rows on the same table based on a different grouping criteria.
 
This is how the input data looks like..
COL1                           TS                             COL2                    COL3              COL4              COUNT(*)

89 views
5 replies, 1 day ago
Complex SQL Scenario Topic by KVB 6 days ago

I have a table with multiple employees,the records needs to be picked up is on different conditions.
I have done them one by one and did UNION.But I am looking for any other manner.Pleas ethrow any light on this.
ID TYPE_CD EFFDT  SEQ
1 A 1-Jul-14 1
1 O 1-Jul-14 2
1 N 1-Jul-14 3
If there are codes in A,O,N then N needs to be picked up
   

82 views
2 replies, 1 day ago
Total Quantity of Items Sold per Month Topic by dg217r 6 days ago

The below query is giving me a result of how many of each product has been sold over time but I need it to tell me how many were sold each month for a chosen year. What am I doing wrong?

 

128 views
9 replies, 1 day ago
Need help on a case scenario Topic by sujithwarrier 6 days ago #sql

Hi All,
I am bit stuck with a case for getting the exact sql. The scenario is we have to pick the price from Table1 with respect to Table2 and create an output. The price should be picked from the latest date and if we have duplicate price for same date then exact match must be considered first.

36 views
1 reply, 1 day ago
HashBufferSize Topic by Kishore_1 1 day ago HashBufferSize

What is the HashBufferSize parameter in Teradata?How does it affect Teradata system performance?

45 views
2 replies, 1 day ago
ESCAPE with Single Quote ? Topic by abort_session 2 days ago

I want to seach this string exactly:     ('TEST')
 
sel * from database.test where feld  like    '@'TEST@''  ESCAPE'@'.
 
Is this not possible with Single Quotes ?

61 views
4 replies, 1 day ago
Distribution in amps Topic by yuvaevergreen 1 week ago

Hi,
 In a system of 190 amps,Whenever I create a table 1 kb is assigned to each vproc by default summing to 190 kb. Why is this space assigned to each vproc. When I queried the allspace view, I am able to find this info.
 
Thanks,
yogi.
 
   

51 views
1 reply, 2 days ago

Pages