#DateForumTypeThreadPost
518 Feb 2014 @ 02:38 PSTDatabaseReplyHash Index and Single Table Join IndexAnswer for 5th Question -   If PPI is not part of PI, We can not have UPI. Because, UPI requires duplicate row check for each and every rows being inserted. To do this check, it has to go to...
413 Feb 2014 @ 01:47 PSTDatabaseReplyParameterizing Like clauseLets say your main table name is diagnosis And the driver table is as below   create table driver (sensitive_info char(20)); Below query will satisfy your requirement. sel 'sensiti...
305 Dec 2012 @ 06:18 PSTAnalyticsTopicDifference Horizontal data redistribution and vertical data redistribution.Could some one explain what is the difference between horizontal data redistribution and vertical data redistribution ?
205 Dec 2012 @ 03:42 PSTDatabaseReplyhow to logon to bteqIf the above is not working u can try his also.   .logon 127.0.0.1/dbc,dbc;
105 Dec 2012 @ 03:38 PSTDatabaseReplyPPI is not working with left joinsPaste the DDL of both tables.