0 - 14 of 14 tags for help

Dear All, Need help with below situation....
id        date
100   6/6/2015
100   8/1/2015
100   9/30/2015
200   8/11/2015
300   7/18/2015
300   1/10/2015
300   3/5/2015
300   6/15/2015

My data looks something like this:
ID | Line | Code
1 | 1 | a
1 | 2 | b
2 | 1 | d
2 | 2 | e
2 | 3 | f
Code | Name
a | alpha
b | beta
d | delta
e | epsilon
f | phi
A common join brings the following results:
ID | Line | Name

This article is the official release announcement for Teradata Viewpoint 15.00 with an effective release date of April 9th 2014. The Viewpoint 15.00 release has a whole new look and feel. The upgraded infrastructure embraces newer web technologies, improves performance, and enhances user accessibility, interaction, and discovery. As the versioning suggests, Viewpoint 15.00 supports the Teradata Database 15.00 release. 

I am new to Teradata and I am working on query for which I greatly appreciate any help. I have a following table (after ordering by col1 and col2) 
Col1        col2             col3        
Alpha      10:00          activity typ 1
Alpha       10:00:30    activity typ 2
Alpha       10:00:40     activity typ 3

Hi,  I am having the following problem when trying to create a CSV report  to email out.  The title line of the report is showing up like this "((((((((((((((((((((((((((((((((((((((((((((((((((AGT_ENT_US" instead of all the field names.  The records themselves are showing up properly.
.set width 1300

I download the 'Windows Help' file for '.NET Data Provider' at

I am running a query that returns blling data with an account number that contains "." in no set position. What I need to do is replace the period "." in each instance that it occurs with a forward slash "/".

I have read many items related to using UDF's, however I do not own the server and have no idea if any UDFs are actually loaded.

What is the difference between FUNCTION and SPECIFIC FUNCTION?  When do I use SHOW FUNCTION versus SHOW SPECIFIC FUNCTION?  Or HELP FUNCTION versus HELP SPECIFIC FUNCTION?  Thanks,  Denmark

What is the best way to extract the output of the 'Help statistics DbName.TblName column Partition;", for the purpose of extracting the value of the column 'Number of Rows'. If you have attempted this through SQL, please share your thoughts. What I've already have in place is the following methodology...
Run 'Collect Statistics on DbName.TblName Column (Partition);
Run 'Help Statistics DbName.TblName Column (Partition);' through BTEQ with SideTitles on


NOTE: Teradata SQL Assistant 12.0 worked over the past year and just started giving me an issue in the past month or two. I am running on Windows XP Professional 32-bit.

I am running into an interesting error that I cannot seem to find a solution to. When trying to run Teradata SQL Assistant 12.0, I am receiving the following error prompt:

Error received: "Error occurred during GetIniData. Code=339

Component 'POWERE~1.OCX' or one of its dependencies not correctly registered: a file is missing or invalid

there are two tables table1 and table2

table1 ---columns

C1 c2 c3 c4 c5

where c3 and c4 are datebegin and dateend


d1 d2 c5

where d1 and d2 are dategin and date end

now i need to join table1 and table2 based on c5

So you have Viewpoint installed and you are logged in for the first time, a blank Viewpoint pane stares back at you ... Now what?

Hey everyone,

I'm in the midst of creating a new Viewpoint article discussing getting started with Viewpoint and what portlets are most often used as a starting dashboard for various Teradata user roles. So questions like, "if I was to share Viewpoint with our Business Users, which portlets would I want to allow them to use?" or "As a DBA, what are the most logical portlets to start with?". So the article is going to try and provide some insight for those whom have questions like that.

First off, my apologies on slacking in my series of blogs on cool Viewpoint features. Was the last one really November? Spilt milk at this point, so let's get to it. One of the key considerations to Viewpoint development planning is "ease of use" and the desire to make Viewpoint as intuitive as possible.