#DateForumTypeThreadPost
2023 Jul 2012 @ 01:25 PDTGeneralTopicTVAS Implementation Hi ,   I understood that Teradata Virtual Access Solution (TVAS) allows SAP BW end-users to access transactional detail and aggregate data residing in Teradata Database.Can som...
1903 Jan 2012 @ 02:12 PSTGeneralReplyAJI Hi , I am also in need of the above resolution. Can someone please respond on the same. 1)Does the columns of query should match with AJI columns? 2)Does the columns of query should ma...
1821 Dec 2011 @ 07:17 PSTDatabaseTopicClarification on Partition_Column in Teradata I have a table with below DDL:   CREATE SET TABLE X,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( A INTEGE...
1721 Dec 2011 @ 12:05 PSTDatabaseTopicConversion from Hexadecimal to Char Hi All,   Can someone please help me how to convert a Hemxadecimal value from a column. HexValue_of_Col             ...
1605 Dec 2011 @ 10:38 PSTDatabaseReplyEnd Dating Previous Relations Thank you All. I was able to sort out the issue in below 2 ways:   SQL1: -------- UPDATE M FROM EMP M, (Select A.EMP_ID,A.Dept_No,A.STRT_DT ,CAST(B.STRT_DT AS DATE)-...
1507 Nov 2011 @ 01:47 PSTDatabaseReplyTruncation of Data while Bteq Export Yes Jimm.I used .Set width as well.Below is the script.   .set width 50000 .set titledashes off .set sidetitles OFF .set format off .SET RTITLE '' INSERT INTO&nb...
1407 Nov 2011 @ 12:37 PSTDatabaseTopicTruncation of Data while Bteq Export Hi All, I am trying to export data to a file using REPORT format.The data inside the Select statement exceeds 254 characters.Data is getting exported fine till last line.However the las...
1322 Aug 2011 @ 11:08 PDTDatabaseTopicUnable to login into TD Demo express Evaluation version 13.10Hi All, I have installed TD evaluation demo version 13.10.When I trying to log into Bteqwin using below credentials I am getting different errors.I have given the login details,errors and hostfi...
1211 Aug 2011 @ 08:48 PDTDatabaseReplyClarification in Global Temporary TablesThank you for the explanation.
1110 Aug 2011 @ 08:54 PDTDatabaseTopicClarification in Global Temporary TablesHi All, I have a global temporary table Table_A and If am loading this table in a session1 and at the same time if I am trying to Select data or insert data from\into the same global temporary t...
1027 Jul 2011 @ 05:45 PDTUDAReplyKey Level DuplicatesHi Mnylin, Sorry for not being clear.For eg: We have a table Tab_a Col1 Col2 Col3 1 Ashok Y 1 Ashok N 2 Mnylin Y The output for the below query will be: SELECT * FROM Tab_a QUALI...
927 Jul 2011 @ 05:33 PDTGeneralReplyMload vs Fastload in rejecting the duplicatesThanks Jim. So you mean to say becuase of this sequence numbers in acquistion phase,Mload will be in a position to identify the duplicates in work table loaded due to restart and discard them.Ho...
826 Jul 2011 @ 06:09 PDTGeneralTopicMload vs Fastload in rejecting the duplicatesHi All, I am bit confused about why Fastload does nt load duplicates even in Multiset table.I got a reason from my colleague that ,its because of its restartability feature.The example which he ...
722 Jul 2011 @ 04:36 PDTDatabaseTopicQuery on Collect statsHi All, Can some one explain I should take sats seperately on the columns or I shall take multicolumn stats for below query.And Why? Select * from Tab1 T1 Inner Join Tab2 T2 On T1.Col1...
620 Jul 2011 @ 08:37 PDTUDAReplyKey Level DuplicatesThis wont work because..subquery will eliminate the duplicates based on col1 and col2 though....Main query will retrieve all the rows along with duplicates because of in condition...
520 Jul 2011 @ 07:38 PDTUDAReplyKey Level DuplicatesHi Elvis, Do u mean to say that I have to write a query like this? Sel col1,col2,col3,col4,col5 from Tab1 group by 1,2,3,4,5 having count(*)>1 ? But this will filter the whole duplic...
420 Jul 2011 @ 05:30 PDTUDAReplyKey Level DuplicatesThanks for the suggestion. However I have got 5 columns col1,col2,col3,col4,col5.Out of which I want to select all the columns by doing the grouping at key level i.e, col1 and col2.So the above ...
320 Jul 2011 @ 03:39 PDTUDATopicKey Level DuplicatesHi All, I was trying to select all the columns which are not key level duplicates.For that I have written a query as SELECT * FROM Tab_a QUALIFY ROW_NUMBER() OVER (partition by col1,col2 ...
219 Jul 2011 @ 06:55 PDTUDAReplyNumeric Overflow While SumThank you very much Jimm.It worked.
118 Jul 2011 @ 06:14 PDTUDATopicNumeric Overflow While SumHi All, I tried to to do sum for a column where I am getting numeric overflow error. Eg: ---- Sel Sum(Col1) from Tab1 group by1 col2; Where Col1 is an integer. I tried to caste it as...