26 | 17 Feb 2015 @ 08:40 PST | Database | Reply | How to write a select query for all columns in a join environment but only show a subset | There is something missing in your query. I cannot see the second table after the "inner join" ...
|
25 | 17 Dec 2014 @ 03:00 PST | Database | Reply | Extra space is getting added with data while loading data into varchar data type column | Please respond on this
|
24 | 16 Dec 2014 @ 11:17 PST | Database | Topic | Extra space is getting added with data while loading data into varchar data type column | Hi All,
I am getting extra space while inserting integer data into varchar data type column.
Please explain the reason behind this.
create volatile table rowhash_my,no log
(... |
23 | 04 Dec 2014 @ 09:32 PST | Tools | Reply | Mload utility is loading unexpected data into table | Hi Fred,
I amend the code as you suggested .Still i am facing the same issue.
Can some one help me on this ?
Thanks,
Sai
|
22 | 03 Dec 2014 @ 01:50 PST | Tools | Topic | Mload utility is loading unexpected data into table | Hi All,
I have build below Mload script to load the data into table.Sample data and final output in table also given below
.LOGTABLE tdbname.Logtable001_mld;
.logon <Dbnam... |
21 | 12 Jul 2013 @ 02:57 PDT | Database | Reply | How to spell out numeric value in English words by select query. | So we can't spellout beyond 9999 |
20 | 12 Jul 2013 @ 02:55 PDT | Database | Reply | How to spell out numeric value in English words by select query. | Thanks a lot Dieter. |
19 | 12 Jul 2013 @ 12:52 PDT | Database | Reply | How to spell out numeric value in English words by select query. | Hi Dnoeth,
THnaks for the information.It is really usefull for me.
I have one more question.
Can't we spellout the numbers in terdata?
In requirement have a column having 4 degit numbe... |
18 | 12 Jul 2013 @ 12:45 PDT | Database | Reply | How to spell out numeric value in English words by select query. | Hi Dnoeth,
THnaks for the information.It is really usefull for me.
I have one more question.
Can't we spellout the numbers in terdata?
In requirement have a column having 4 degit numb... |
17 | 11 Jul 2013 @ 09:54 PDT | Database | Reply | How to spell out numeric value in English words by select query. | Hi All,
Can any one help me on this?
Thanks
sai |
16 | 11 Jul 2013 @ 10:18 PDT | Database | Topic | How to spell out numeric value in English words by select query. | Hi ALL,
Can any one help me how to use Element (SP) in To_char function to spell out the number in english words?
I am using TD 14 verion>
Below content mentioned in TD14 doc about SP... |
15 | 10 Jul 2012 @ 08:56 PDT | General | Topic | How to display the similar column value only one time in query? |
HI ,
Can some one helpme how to display the similar column value only one time in query?
ex:
Code id
=== ===
Pune 105
Pune &... |
14 | 09 Jul 2012 @ 06:33 PDT | General | Reply | How to display first 3 and last 3 records from a table |
Thanks Dnoeth.
|
13 | 09 Jul 2012 @ 09:15 PDT | General | Topic | How to display first 3 and last 3 records from a table |
Hi All,
Can someone help me how to display the first & last 3 records from atable?
Ex:
id name
101 sai
102  ... |
12 | 06 Jul 2012 @ 08:57 PDT | General | Reply | How to find the parent and child relationship between tables in Terdata by using Dictonary tables? |
Hi Waq,
I did not find single table from the above set of dictonary tables. even though there is a user difined tables in my database.
So,is there any other solution to get the dat... |
11 | 05 Jul 2012 @ 09:39 PDT | General | Reply | How to find the parent and child relationship between tables in Terdata by using Dictonary tables? |
CAn you frame the query with above tables?
Thanks,
Sai
|
10 | 29 Jun 2012 @ 10:02 PDT | General | Topic | How to display the last 3 characters of lastname? |
Hi,
In oracle we used below query to display the last three characters of last_name.
SELECT SUBSTR(LAST_NAME,-3) FROM
EMPLOYEES;
Can someone help me how to perform in ... |
9 | 29 Jun 2012 @ 09:18 PDT | General | Topic | How to find the parent and child relationship between tables in Terdata by using Dictonary tables? |
Hi,
In my project have many Facts and dimentions.I would like to know the relationship between those tables by using Query.
Does terdata store parent child relationship at dictonary tabl... |
8 | 27 Jun 2012 @ 08:18 PDT | General | Topic | How to generate multiple records from single record |
Hi,
Can some help me how to generate mutiple records from single record without UNION/UNION ALL.
Example:
Source:
Id Customername account... |
7 | 27 Jun 2012 @ 08:10 PDT | Database | Reply | Can we use GROUPING ,GROUPING_ID,Grouping Sets |
Thanks mjasrotia
|
6 | 26 Jun 2012 @ 09:31 PDT | Database | Topic | Can we use GROUPING ,GROUPING_ID,Grouping Sets |
Can some one help me how to use GROUPING ,GROUPING_ID,Grouping Sets in terdata?
|
5 | 26 Jun 2012 @ 09:22 PDT | Database | Reply | SQL QUERY help |
Thanks for your Reply Dieter!
Yes, I need this query to test one of the report in my project.
|
4 | 25 Jun 2012 @ 09:39 PDT | Database | Topic | SQL QUERY help |
Hi All,
I have following data in table level.
Can some one helpmeon this?
Category barcode &nb... |
3 | 14 Apr 2012 @ 10:56 PDT | Database | Topic | How to display each row in a table into multiple times |
Hi All,
I am new to Teradata.
Please let me know how to display the single row into multiple time.
In oracle :
======
saelect * from table ... |
2 | 09 Apr 2012 @ 09:04 PDT | General | Reply | Welcome to the Teradata Developer Exchange discussion forums! |
Hi,
Can anyone guide me how to find the Parent and child relationship between tables in teradata.
Thanks in advance.
|