#DateForumTypeThreadPost
1120 Jul 2011 @ 06:12 PDTDatabaseTopicBTEQ. On Error: ContinueHi All, I'm new to BTEQ, and writing a BTEQ script, made up of several SQL's. What I want to do, once an Query is finished, if the error code is greater than 0, just ignore it and continue to...
1024 May 2011 @ 10:44 PDTDatabaseReplyTotal Sum of all columnsThanks alot guys :)
922 May 2011 @ 11:37 PDTDatabaseTopicTotal Sum of all columnsHi All, I run a query daily which groups some specific data and gives an integer value in several columns like GROUP || NAME || Count(A) || Count (A+B) || Difference =====================...
821 Dec 2010 @ 10:11 PSTGeneralTopicAcceptable Duplicate Row CountHi all, I have a database with many tables (around 60-70) where around half the number of tables, or slightly more, have a small amount of duplicate rows. (Between 0-3% duplicate rows on average...
712 Dec 2010 @ 03:21 PSTToolsTopicFailing loads in TpumpHi All, I just wanted to ask this question regarding TPump. If I were to remove the IGNORE DUPLICATE ROWS line from my tpump script, would a failed load be able to continue where it failed? An...
607 Dec 2010 @ 03:44 PSTToolsReplyTpump and LoadingI just wanted to add to this question. If I were to remove the IGNORE DUPLICATES line from my tpump script, would a failed load be able to continue where it failed? And is this also the same fo...
530 Nov 2010 @ 08:53 PSTToolsTopicTpump and LoadingHi all, I wanted to ask a question regarding Tpump loading into a Set table. If the load fails, can it pick up again and continue from where it failed? Or does there have to be some form of cle...
411 Nov 2010 @ 04:08 PSTToolsReplyTpump and DuplicatesThanks feinholz. It's much appreciated
310 Nov 2010 @ 09:27 PSTToolsReplyTpump and DuplicatesI have another question aswell.. Regarding the speed of tPump. If i try to insert say 1-10k rows into the multiset table it takes around 2 seconds to complete the operation. However if I was to...
210 Nov 2010 @ 09:23 PSTToolsReplyTpump and DuplicatesThanks feinholz, I appreciate the quick response. I think I understand what you mean. The table I want to insert into is indeed a multiset table. Are you saying that if i have specified IGNOR...
110 Nov 2010 @ 04:19 PSTToolsTopicTpump and DuplicatesHi all, I just have a question about Tpump and the IGNORE DUPLICATES operation. I want to insert rows into a table using tpump, and I have not set IGNORE DUPLICATES. Now say a row already exist...