25 | 13 Jun 2016 @ 03:11 PDT | Database | Topic | Table data in Alphabetical Column Name order in SQLA | Hi,
How can I get "Select * from tablename" result in alphabetical order of column names in SQLA window ?
Ex. Table/view has columns defind in order A,C,D,B , then sel * from table shou... |
24 | 13 May 2016 @ 02:44 PDT | Database | Reply | Issue while logging : CLI error: CLI2: BADLOGMECH(507) | Try adding this before logon command :
.LOGMECH TD2
or
.LOGMECH LDAP
|
23 | 18 Aug 2015 @ 08:05 PDT | Database | Reply | SELECT Failed 3707 Syntax error, expected something like an 'EXCEPT' keyword or an 'UNION' keyword or a 'MINUS' keyword between | -- and ph_pymt_dt = ?
) <sub_query_name>
union
all
SELECT * FROM
(select
|
22 | 18 Aug 2015 @ 03:44 PDT | Database | Reply | Table Lock Issue.. | .logon server/usrid,password;
begin loading fastload_table_name
errofiles error_table1,error_table2;
end_loading;
|
21 | 15 Jul 2015 @ 07:40 PDT | Database | Reply | Usage of Staging tables with NoPI and Insert/Select | There is an article in the forum on NoPI , Please go through this :
http://developer.teradata.com/database/articles/say-yes-to-no-primary-index-no-pi-tables
|
20 | 14 Jul 2015 @ 01:55 PDT | Connectivity | Topic | 305 NOREQUEST Specified request does not exist. | Hi,
Getting "305 NOREQUEST Specified request does not exist." Error while creating Volatile table through SAS connection string.
What could be the issue ?
Thanks in Advance.
|
19 | 13 Jul 2015 @ 03:55 PDT | Database | Reply | Alter table for VARCHAR(4000) Latin to UNicode | Do we have alter option for this change or rename & then recreate is the only way.
Thanks in advance.
Nagendra
|
18 | 06 Jul 2015 @ 10:08 PDT | Database | Topic | Alter table for VARCHAR(4000) Latin to UNicode | Hi,
I want to alter my table column from VARCHAR(4000) Latin to Unicode .
Please help with the alter table syntax if feasible or any differnt approch for the same.
Thanks
Nagendra
|
17 | 03 Jul 2015 @ 01:45 PDT | Database | Topic | One string out of the repetitive string series | Hi,
How to get only one word out of the repetitive word series for exanple XYZ FROM XYZ XYZ XYZ or XYZ,XYZ,XYZ or XYZ?XYZ?XYZ.
Thanks
Nagendra
|
16 | 02 Jul 2015 @ 07:12 PDT | Database | Topic | VT table data getting deleted after "Multiple rows updated" error | Hi,
what could be the reasson for data deletion after "Multiple rows updated" error automatically ?
Thanks
Nagendra
|
15 | 02 Jul 2015 @ 07:10 PDT | Database | Topic | Export/Import data through Teradata SQL | Hi,
Do we have any feature in teradata where we can export/import data through a Teradata SQL query .( Not SQLA exprot/import utility).
Lets take a scenerio : we are connected TD from SAS , creat... |
14 | 28 May 2015 @ 08:17 PDT | Database | Topic | Finding last character of a string | Hi,
Do we have some different approch to get last character of a string ( Fix length/ Variable length both ) apart from using substr ?
Thanks
Nagendra
|
13 | 26 Sep 2014 @ 04:29 PDT | Database | Reply | Teradata Error 5533 | Thanks Raja for update.
I reduced stored proc size by remmoving unwanted words and made it with of 3.5 MB as of now and it compiled fine .
|
12 | 26 Sep 2014 @ 03:58 PDT | Database | Reply | Teradata Error 5533 | what does size mean here ? is it number of rows , chracters etc a proc request can have ?
if yes , what are the limitations on size for TD14 ?
|
11 | 26 Sep 2014 @ 02:48 PDT | Database | Topic | Teradata Error 5533 | Hi ,
What is teradata error 5533 about and how to resolve the problem .
Thanks,
Nagendra
|
10 | 11 Sep 2014 @ 07:03 PDT | Tools | Reply | How to find the number of columns in each table in Teradata ?? | Hi,
dbc.tables wont give column details better u check below SQL for the number of columns :
Select tablename, count(Columnname) from dbc.columns where tablename='table_name' and Database... |
9 | 09 Sep 2014 @ 12:45 PDT | Database | Reply | Understanding Quantile | Hi Moutusi,
Actual calculation of Quantile funtion works as
(RANK() OVER (ORDER BY s) - 1) * q / COUNT(*) OVER()
please cross check the results of quantile(4,emp_sal) and (RANK() OVER (ORDE... |
8 | 08 Sep 2014 @ 01:00 PDT | Tools | Topic | 10061 WSA E ConnRefused: The Teradata server is not accepting connections | Hi,
I downloaded td-ttu-15.00_for_Windows on my personal computer and created a DSN using my public ip over internet as IP server for DSN.
While connecting the DSN on TDA i am getting "10061... |
7 | 08 Aug 2014 @ 08:20 PDT | Database | Reply | Delete from table all | Hi,
You can get Diff between delete & delete all into below page :
https://forums.teradata.com/forum/database/delete-all-vs-delete
AS far as I know MLOAD works with data block in ... |
6 | 05 Aug 2014 @ 08:20 PDT | Database | Topic | collect stats statement failure because of spool space | Hi,
What could be the reason for a collect stats statement failure on a single column because of spool space (In a enough spool env. )?
Also on execution on Collect stats statement what Ter... |
5 | 04 Aug 2014 @ 10:06 PDT | Database | Reply | What is mean by STAT FUNCTION in Teradata | Hi,
Please check below link :
http://teradatablog.wordpress.com/2011/09/15/stat-function-in-explain-plan/
Try to use sample in place of TOP .
SELECT * FROM table SAMPLE 10;
Thanks
Nag... |
4 | 04 Aug 2014 @ 09:57 PDT | Database | Reply | Rank with Qualify not giving the exact results. | Hi Amit,
Try with below query :
1)
Select Sub.NAME
,Sub.REVISION
,Sub.last_update_date
FROM
( Select
--CDR_ODS_R_GE_OBJ_HST .FROM_ID as FROM_ID,
CDR_ODS_R_GE_OBJ_HST .FROM_NAME ... |
3 | 03 Aug 2014 @ 12:31 PDT | Database | Reply | Rank with Qualify not giving the exact results. | Hi Amit,
Based on above data i could able to think of below query.
Please try this and let me know if does not work or useful for you :
Select Sub.part_name
,Sub.Revision
... |
2 | 30 Jul 2014 @ 10:44 PDT | Database | Topic | collect stats statement failure because of spool space | Hi,
What could be the reason for a collect stats statement failure because of spool space (In a enough spool env. )?
Also on execution on Collect stats statement what Teradata DB does interna... |
1 | 29 Jul 2014 @ 01:37 PDT | Database | Reply | Mvc Compression and Collect Stats on TD 14 | Hi,
What could be the reason for a collect stats statement failure because of spool space ?
Also on execution on Collect stats statement what Teradata DB does internally on Vprocs & Vdisks ?
... |