#DateForumTypeThreadPost
730 May 2006 @ 11:09 PDTAnalyticsReplypartitioning results of queryHi,could you please explain how to go about this 'EXPLAIN'.???thanks a lot
630 May 2006 @ 06:23 PDTAnalyticsTopicpartitioning results of queryhi,i want to run this insert..select query.now since the result set is huge, i am running into spool space problems.is there any way by which i can avoid this.some way by which the result set may b...
527 Mar 2006 @ 05:19 PSTDatabaseTopicnumber of rows returned..rowcounthi,how do i get the rowcount or the number of rows affected by the last query?somethign like rowcount in oracle.
420 Mar 2006 @ 02:58 PSTDatabaseTopicmacroshi, can someone plz pass on the sql to create a macro and the syntax to call the macro from a shell script.thanks.
316 Mar 2006 @ 06:51 PSTDatabaseTopicenvironment file in bteq scripthi, i am trying to get the names of input/ export files into my bteq script from an environment file.using .i have used.os /pimecris/temp/pims.envbut .import data file= $export does not work.Any su...
216 Mar 2006 @ 04:22 PSTToolsReplyimport data from text fileHi,This is the little code that i want to test.cast did not solve my problem.i have tried report, data and indicdata type of export/import.first i am exporting, then importing the result to evaluat...
113 Mar 2006 @ 08:09 PSTToolsTopicimport data from text fileHi, i tried exporting data and then importing it back as part of a where clause in a select query.but it does not give the desired result.it somehow always adds some characters to the output while ...