#DateForumTypeThreadPost
2513 Jun 2016 @ 03:11 PDTDatabaseTopicTable 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...
2413 May 2016 @ 02:44 PDTDatabaseReplyIssue while logging : CLI error: CLI2: BADLOGMECH(507)Try adding this before logon command : .LOGMECH TD2 or  .LOGMECH LDAP  
2318 Aug 2015 @ 08:05 PDTDatabaseReplySELECT 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   
2218 Aug 2015 @ 03:44 PDTDatabaseReplyTable Lock Issue...logon server/usrid,password; begin loading fastload_table_name errofiles error_table1,error_table2; end_loading;
2115 Jul 2015 @ 07:40 PDTDatabaseReplyUsage of Staging tables with NoPI and Insert/SelectThere 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    
2014 Jul 2015 @ 01:55 PDTConnectivityTopic305 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.
1913 Jul 2015 @ 03:55 PDTDatabaseReplyAlter table for VARCHAR(4000) Latin to UNicodeDo we have alter option for this change or rename & then recreate is the only way. Thanks in advance. Nagendra
1806 Jul 2015 @ 10:08 PDTDatabaseTopicAlter table for VARCHAR(4000) Latin to UNicodeHi, 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
1703 Jul 2015 @ 01:45 PDTDatabaseTopicOne string out of the repetitive string seriesHi, 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
1602 Jul 2015 @ 07:12 PDTDatabaseTopicVT table data getting deleted after "Multiple rows updated" errorHi, what could be the reasson for data deletion after  "Multiple rows updated" error automatically ? Thanks Nagendra
1502 Jul 2015 @ 07:10 PDTDatabaseTopicExport/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...
1428 May 2015 @ 08:17 PDTDatabaseTopicFinding last character of a stringHi, Do we have some different approch to get last character of a string ( Fix length/ Variable length both ) apart from using substr ? Thanks Nagendra
1326 Sep 2014 @ 04:29 PDTDatabaseReplyTeradata Error 5533Thanks 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 .
1226 Sep 2014 @ 03:58 PDTDatabaseReplyTeradata Error 5533what 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 ?
1126 Sep 2014 @ 02:48 PDTDatabaseTopicTeradata Error 5533Hi , What is teradata error 5533 about and how to resolve the problem . Thanks, Nagendra
1011 Sep 2014 @ 07:03 PDTToolsReplyHow 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...
909 Sep 2014 @ 12:45 PDTDatabaseReplyUnderstanding QuantileHi 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...
808 Sep 2014 @ 01:00 PDTToolsTopic10061 WSA E ConnRefused: The Teradata server is not accepting connectionsHi, 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...
708 Aug 2014 @ 08:20 PDTDatabaseReplyDelete from table allHi, 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 ...
605 Aug 2014 @ 08:20 PDTDatabaseTopiccollect stats statement failure because of spool spaceHi, 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...
504 Aug 2014 @ 10:06 PDTDatabaseReplyWhat is mean by STAT FUNCTION in TeradataHi,   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...
404 Aug 2014 @ 09:57 PDTDatabaseReplyRank 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 ...
303 Aug 2014 @ 12:31 PDTDatabaseReplyRank 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 ...
230 Jul 2014 @ 10:44 PDTDatabaseTopiccollect stats statement failure because of spool spaceHi, 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...
129 Jul 2014 @ 01:37 PDTDatabaseReplyMvc Compression and Collect Stats on TD 14Hi, 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 ? ...