#DateForumTypeThreadPost
14425 Oct 2013 @ 01:50 PDTDatabaseReplyNeed update on Identity columnsHi, According to the Merge Into documentation, PI can be identity column, it was restricted with Upsert form of update.  What if you generate the ID in some tamp table and then insert into t...
14325 Oct 2013 @ 12:50 PDTDatabaseReplyregarding denormailizing the strutcture of table.Hi, There is not a very clear patteren about the data you want to split. But if you want to split data based in -, then the following code might help. SELECT SUBSTR(ColumnName, POSITION('-&...
14225 Oct 2013 @ 12:42 PDTTeradata ApplicationsReplygood teradata instituteIf you are a Teradata employee then you can learn everything from Teradata University.
14124 Oct 2013 @ 12:08 PDTDatabaseReplyThe string contains an untranslatable character Have you tried it through BTEQ? it might be an issue due to ODBC limitations.  
14024 Oct 2013 @ 12:04 PDTTeradata ApplicationsReplyGetting "<error>" in the column next to the BLOB column while selecting data using SQL assistantHi, Sorry for the delays, Can you please check the max length of the data in LOB column. You can use the following query: select ID, CHAR_length(ATCHMNT_FILE_NM) from tableName; I doubt you ma...
13923 Oct 2013 @ 11:18 PDTDatabaseReplyCount Days in a date fieldHi, Use the follwoing: select SUM(Extract(DAY FROM COL_NAME)) from TABLENAME;  
13823 Oct 2013 @ 11:03 PDTDatabaseReplyThe string contains an untranslatable character Hi, Probably these characters the binary characters created during an export operation. Are you facing this issue in a file loaading or something else?  
13723 Oct 2013 @ 07:57 PDTDatabaseReplyTranspose rows to columnsHi, How much rows do you have to process?   
13623 Oct 2013 @ 07:48 PDTDatabaseReplycould not convert from character to date typeHi, By the way why you are using TRIM? Is the column of Character data type?  If it is date When you apply the function TRIM(DATE123) it converts the date to string, You can only cast s...
13523 Oct 2013 @ 01:20 PDTGeneralReplyMacro ...stored procedureIf you mean that a Macro or Stored Procedure is a transaction, then the Answer is yes.  First we have to look at what a transaction is? A unit of work, and unit of work may consist of single ...
13420 Oct 2013 @ 11:45 PDTDatabaseReplyAfter extraction of 10,00000 rows query giving 'Out of memory' errorHi, It has been discussed before on another thread, there is a limit of data that can be seen using SQLA, after the consuming that much memmory, the SQLA fails to handle the large amounts of data....
13318 Oct 2013 @ 12:04 PDTDatabaseReplyMultiple nested select statements with CaseHi,  How are you trying to combine the multiple select statements? without any join, and cross join, union etc? The first select is right, but I do not see any link between these select state...
13218 Oct 2013 @ 11:03 PDTTeradata ApplicationsReplyGetting "<error>" in the column next to the BLOB column while selecting data using SQL assistantHi, Which error you are actually getting?  
13118 Oct 2013 @ 04:06 PDTDatabaseReplySub query vs OLAP approachHi Dieter, Thanks for the correction!  
13017 Oct 2013 @ 08:59 PDTDatabaseReplySub query vs OLAP approachUlrich, If you can see the manual 25965_TeradataSQL-V14.0.4-studentmanual, Page # 522 explains the difference between a subquery and a corelated sub query. It explains that the main diff...
12917 Oct 2013 @ 12:32 PDTDatabaseReplySub query vs OLAP approachWell, the corelated subquery processes data a row at a time. While the OLAP function is a set operation, So the performance will be better in case of OLAP (SET Operation) as compared to Corelated(R...
12816 Oct 2013 @ 09:28 PDTDatabaseReplySub query vs OLAP approach I am not sure with the performance effect of using these two approaches, but the result will be affected by using either of these.   As with subquery the inner query will select the...
12716 Oct 2013 @ 09:22 PDTDatabaseReplyCREATE TABLE. [5506] Column names must be specified when SELECT list contains an unnamed expression.Hi, You need to name all the columns where the column is being created using some expression or function. For example [edited at request of IP owner] must be given an explicit name. Otherwise you ...
12615 Oct 2013 @ 01:31 PDTToolsReplywaht is Spoolmode option in TPT script?Hi Ratnam, Fastexport is used to export data from a Teradata database table. If you want to load some file, to Teradata, you have to use Fastload, or you can also use the TPT load operator. If you...
12515 Oct 2013 @ 01:26 PDTDatabaseReplyPrimary index + Partition Key + single AMP operation Well the first thing is you must try to define a column with unique values as PI to get the even distribution and take benifit of Teradata parallelism.   a column like gender with s...
12415 Oct 2013 @ 01:18 PDTDatabaseReplyError while Importing data from flat file to table thru sql assistantHi washdd, This error often appears due to invalid delimiter. You can anlyze the data, and check for if there is a header in the file? Or data enclosed in qoutes? Or the delimiter is appearing in ...
12314 Oct 2013 @ 02:18 PDTDatabaseReplyTeradata Express for WIN 32 BITWhich Explorer you are using? Try with Internet Explorer.  
12214 Oct 2013 @ 04:46 PDTDatabaseReplyConvert string into dateHi, Try this code: SELECT CAST( CAST( DATE_COL AS DATE FORMAT 'DD-MMM-YY') AS DATE FORMAT 'YYYY-MM-DD');  
12114 Oct 2013 @ 01:41 PDTDatabaseReplySELECT Failed. [3540] Number of tables in join exceeds Parser limit.Teradata Supports 128 joins on a single query. One possible solution is you can create volatile/Temporary tables of chunks of this query and then perform select on those multiple volatile tables. ...
12011 Oct 2013 @ 12:40 PDTDatabaseReplyMinmum Time field selection - TIME(6)Can you please paste some sample data?  

Pages