#DateForumTypeThreadPost
819 Mar 2008 @ 03:05 PDTAnalyticsTopicRetrieving varbyte column into a fileHi , What is the process of retrieving the column value whose datatype is varbyte in bteq script.For example I have a table ABC having a column bcd as varbyte(64000).In this column one .dat file i...
705 Aug 2007 @ 04:44 PDTDatabaseReplyDifference in queryThanks for the information with the example.Examples have made the difference in output quite clear.Reason why I want to modify query1 is because its taking a lot of time toretrieve records where a...
605 Aug 2007 @ 04:31 PDTUDAReplyDifference in outputThanxs a lot Fred.Saw your reply today & i have got the logic mentioned by you.Actually I was looking to tune query 1 as it was taking a lot of time to fetch records.Query1 was using the index but ...
531 Jul 2007 @ 02:31 PDTUDAReplyDifference in outputThanxs fred for the reply.I think the problem with the query is because of COALESCE & left outer join.COALESCE is making the query 1 to behave as Inner join.what's ur views on the same
430 Jul 2007 @ 11:44 PDTDatabaseReplyDifference in queryThanxs for the reply.I think u meant the output would be different.If so i would really appreciate if u can tell me the reason.is it because of left outer join which will act different in both the ...
330 Jul 2007 @ 06:34 PDTUDAReplyTeraData vs OracleBoth the database has there advantages & disadvantages.There are a lot of factors to be taken into consideration before deciding which database is better.If you are talking about OLTP systems then ...
230 Jul 2007 @ 06:27 PDTUDATopicDifference in outputHi All,Mentioned below are 2 queries .Can anyone have a look & tell me whether the output of both the queries would be same or not.Query 1SELECTS.ACCT_EVENT_TYPE_CD ,S.CUST_ACCT_EVENT_ID ,S.EVENT_U...
130 Jul 2007 @ 05:50 PDTDatabaseTopicDifference in queryHi All, Mentioned below are 2 queries .Can anyone have a look & tell me whether the output of both the queries would be same or not.Query 1SELECT S.ACCT_EVENT_TYPE_CD ,S.CUST_ACCT_EVENT_...