#DateForumTypeThreadPost
1126 Jan 2016 @ 03:21 PSTConnectivityReplyODBC Socket Error in some Informatica SessionsHi,   I am also facing a similar kind of error, CMN_1022[Database driver event... Error occured loading library[libodbc.so: cannot open shared object file: Permission denied] Database driv...
1026 Feb 2014 @ 05:37 PSTToolsTopicSHOW table/View issue in Teradata SQL Assistant 13 Java versionHi, When i execute show view or show table in my newly installed teradata SQL assistant 13 Java version tool. The DDL (result set ) for the query is not displayed, the save to file option is also ...
901 Jan 2014 @ 02:24 PSTDatabaseReplyrecursive query numeric overflow issueHi Experts,   Kindly help me to achieve the scenario in Teradata stored procedure.   Thank you!   --Arun
821 Nov 2013 @ 02:38 PSTDatabaseReplyrecursive query numeric overflow issueHi VBurmist, It is working :). Thanks a lot. --Arun
720 Nov 2013 @ 09:25 PSTDatabaseTopicrecursive query numeric overflow issueHi All, I am using recursive query to fetch the top most hireracy of the relation. I have data as shown below:   Manager Reportee Department 1     &nbs...
620 Nov 2013 @ 09:06 PSTDatabaseReplyfetching data by joining 2 tables in a viewHi Ulrich, The table T2 will have more than 80k records. I have posted only sample data to explain the scenario.   --Arun
519 Nov 2013 @ 10:12 PSTDatabaseReplyfetching data by joining 2 tables in a viewHi Ulrich, PFB the DDLs , data in the table and the select statement in the view. CREATE MULTISET TABLE DB_TEST.T1 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, ...
418 Nov 2013 @ 10:29 PSTDatabaseReplyfetching data by joining 2 tables in a viewHi Ulrich, I am in need to adding new fieds in the table T2 to table T1. I am trying to transpose the records in the table T2 to columns in T1. So it requires me around 15 joins. Regards, Arun
313 Nov 2013 @ 05:09 PSTDatabaseReplyfetching data by joining 2 tables in a viewHi VandeBerg, Your suggestion is working fine :). But i am have 15 to 18 such different join combinations between the two tables, so i am joining the table T2 18 times with different alias name a...
230 Oct 2013 @ 03:13 PDTDatabaseReplyfetching data by joining 2 tables in a viewHi Experts, Kindly help me to sort this out. Regards, Arun
127 Oct 2013 @ 09:43 PDTDatabaseTopicfetching data by joining 2 tables in a viewHi, I need to fetch data by joining 2 tables as shown below: I have 2 tables T1 and T2. T1 have fields A,B,C,D and X. The table T2 have fields E,F,G and H. I need to join tables with the fields A...