#DateForumTypeThreadPost
10116 Aug 2010 @ 03:30 PDTDatabaseTopicMerge vs Insert-SelectI am trying to insert into Table A from B & C all having same PI.Please let me know difference in 2 approaches .Generally when PI are same it shud be all AMP merge with no use of spool,but here spo...
10012 Aug 2010 @ 10:46 PDTToolsReplyMLoad and multiple input filesto add on above: Hi All, Can anybody clear on below: We are trying to load 3 files in 3 different tables within same multiload script. As a part of impact analysis we have been asked if sup...
9912 Aug 2010 @ 08:19 PDTToolsTopicMultiload --sequential or parallel for multitableHi All, Can anybody clear on below: We are trying to load 3 files in 3 different tables within same multiload script. As a part of impact analysis we have been asked if suppose 1 of file loa...
9828 Feb 2010 @ 09:33 PSTDatabaseReplyError 3932 while running Vies DDL in SQL assistantHi Forum Member, Thanks for you response...but even when i am running that query alone no error is coming... When both queries are run 1 by 1 together......then the error is coming...please help...
9726 Feb 2010 @ 10:11 PSTDatabaseReplyError 3932 while running Vies DDL in SQL assistantHi ,Any takers in this forum???please come up with some resolution...
9626 Feb 2010 @ 01:51 PSTDatabaseTopicError 3932 while running Vies DDL in SQL assistantHi All,When i am running bewlo 2 queries in sql assistant i am getting error 3932:Only an ET or null statement is legal after a DDL Statement. REPLACE VIEW AAS LOCKING ROW FOR ACCESSSELECT x,y,z ...
9511 Jan 2010 @ 11:38 PSTDatabaseReplyCollect stats on GTTHi All,Please reply..
9410 Jan 2010 @ 06:23 PSTDatabaseTopicCollect stats on GTTHi,GTT allows to have collect stats on single column but not combinations of column why is it so?Also please specify where stats for indexes and column are stored for GTT like in permanent tables i...
9329 Oct 2009 @ 02:49 PDTDatabaseReply3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSIONHi,Can anybody help me out in this?Regards,
9227 Oct 2009 @ 12:26 PDTDatabaseTopic3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSIONHiWhen i am running following querySEL COALESCE(A,CAST(' 12:63:39.999999 'AS TIME(6))) FROM employeeI am getting error 3800: DATATYPE MISMATCH IN THEN/ELSE EXPRESSIONCOLUMN A IS TIME(6) IN DDL.Plea...
9125 Aug 2009 @ 12:39 PDTDatabaseReplyunion, minus, intersectHi Forum Beings,Pls reply ....already 4 days gone since last post.
9021 Aug 2009 @ 02:13 PDTToolsReplyMload locksHi All,Please provide some input...Regards,
8916 Aug 2009 @ 02:30 PDTToolsTopicMload locksHi Forum Gurus,I am having some confusions about locks in various phases of MloadAcquisition Phase1)Access lock2)Acquisition lock which sets a flag in table header rejecting any DDL except DROP.How...
8814 Aug 2009 @ 04:23 PDTToolsReplyFastload and Multiloadhi raj,thanx for reply,as we know mload is restartable from all 5 phases the solution given by you is a rerun not a restart.could u plz tell how we can restart in this scenario or is it not possibl...
8714 Aug 2009 @ 02:11 PDTToolsTopicFastload and MultiloadHi,As we know Fastload doesnt allow duplicate rows in even Multiset table.So suppose i have a chechpoint of 10k and job failed at 9k those records upon restart will be send again and by virtue of t...
8604 Jul 2009 @ 11:31 PDTDatabaseReplySET with UPIHI,Can anybody clear this please???
8504 Jul 2009 @ 05:15 PDTDatabaseReplySET with UPIHi Carlos,I am bit confused as which one of you is saying correct ,also i was unable to understand anything as all in spanishCould you please write something from that extract in english explaining...
8402 Jul 2009 @ 11:11 PDTDatabaseTopicSET with UPII am stuck with a strange situation ....I am having about 100 tables in my system which areSET+UPI defined upon thatSET----system level check to ensure no duplicate rows are thereUPI----table level...
8311 Jun 2009 @ 09:45 PDTDatabaseReplyStats on non index columnHi Rob,Thankx for your reply...As you have said "The reason for collecting single column and multi-column stats where appropriate is to provide the optimizer with the most accurate histogram of the...
8208 Jun 2009 @ 11:10 PDTDatabaseReplyStats on non index columnThankx for the reply Anadi...But i am not exactly looking for that My question was what really is use of stats collected on set selection non-index column ,even in case of JOIN it will be used to e...
8108 Jun 2009 @ 02:24 PDTDatabaseReplyStats on non index columnHi ,Can anybody throw some light on this....pls
8006 Jun 2009 @ 02:10 PDTDatabaseTopicStats on non index columnHi ,Having some confusions about how collect stats really worksSuppose i am running this queryselect * from table where column=300Basically stats collected on columns used for selection will never ...
7905 Jun 2009 @ 11:11 PDTDatabaseReplyDelete ALLHi Jim,thankx for the reply...could you please tell where to find these details told by you....?Any documentation.......
7805 Jun 2009 @ 09:26 PDTDatabaseReplyDelete ALLHi Jim,"DELETE ALL doesn't need to be rolled back if the transaction fails "in the middle" because the physical delete is not done until the transaction commits"Not able to get this statement.........
7704 Jun 2009 @ 09:57 PDTDatabaseReplyDelete ALLcan anybody reply on this???

Pages