http://www.enzeecommunity.com/index.jspa?view=discussions Latest Forum Threads in The Netezza Community en Wed, 08 Sep 2010 23:19:11 GMT Clearspace 2.5.3 (http://jivesoftware.com/products/clearspace/) 2010-09-08T23:19:11Z en http://www.enzeecommunity.com/thread/2100 Hi,   First of all, I apologize for duplicate thread.   I am doing a testing to check the performance.   First Test, In my table a and table b, we have a common columns having char(1) as datatype. Table has approx. 900,000 records and Wed, 08 Sep 2010 20:23:00 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2100 2010-09-08T20:23:00Z 1 hour, 46 minutes ago 4 3 http://www.enzeecommunity.com/thread/2099 Hi All,   Is there any clause in Netezza similar to CONNECT BY PRIOR. Wed, 08 Sep 2010 20:00:17 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2099 2010-09-08T20:00:17Z 4 hours, 50 minutes ago 2 1 http://www.enzeecommunity.com/thread/2094 nzsql has a command called \copy what is the syntax to dump the contents of a query to an output file using \copy   thanks. Tue, 07 Sep 2010 22:09:17 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2094 2010-09-07T22:09:17Z 11 hours, 16 minutes ago 3 2 http://www.enzeecommunity.com/thread/2096 Hi,   Is there any difference between these 2 types    DECIMAL(?,?)   and NUMERIC(?,?)...     would appreciate your replies...   thanks, Gerry Wed, 08 Sep 2010 08:35:48 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2096 2010-09-08T08:35:48Z 14 hours, 10 minutes ago 2 1 http://www.enzeecommunity.com/thread/2093 How to know whether the table contains skew or not Mon, 06 Sep 2010 13:50:26 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2093 2010-09-06T13:50:26Z 2 days, 10 hours ago 2 1 http://www.enzeecommunity.com/thread/2092 Has anyone seen or know how to resolve this error: "Not enough memory to partition hash join".  The query that is producing this error runs everyday and has been fine.  While the tables have grown the dataset that is being worked on is pretty constant Sun, 05 Sep 2010 19:07:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2092 2010-09-05T19:07:31Z 3 days, 5 hours ago 1 http://www.enzeecommunity.com/thread/2091 I am currently running nzrestore on a 2TB database.  The backup itself is on a snap drive and the new machine where the db is being created is a TwinFin P12.  The utility is being run with -v (verbose) option. Four tables in this db have 2billion+ rec Sun, 05 Sep 2010 14:10:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2091 2010-09-05T14:10:35Z 3 days, 10 hours ago 1 http://www.enzeecommunity.com/thread/1782 I am using Netezza date_trunc function but its giving different result compare to oracle. Trunc function in Oracle gives the output as for ex select sysdate from dual - 18-JAN-10 09.26.53 select trunc(sysdate) from dual - 18-JAN-10 12.00.00 (Its Mon, 18 Jan 2010 14:47:05 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1782 2010-01-18T14:47:05Z 5 days, 9 hours ago 5 4 http://www.enzeecommunity.com/thread/2081 Hi all,   I would like to know how to switch between Databases within a Stored Procedure for DML Operations?   Thanks in advance. procedures Wed, 25 Aug 2010 18:32:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2081 2010-08-25T18:32:37Z 6 days, 9 hours ago 7 6 http://www.enzeecommunity.com/thread/2088 I'm a new kid on the Enzee block - and can't wait to sink my teeth in this project.   I could use some collective wisdom to push me in the right direction.  I've been tasked with coming up with a general approach to the following problem.   We synchronization ssis sql server Wed, 01 Sep 2010 19:40:28 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2088 2010-09-01T19:40:28Z 6 days, 10 hours ago 6 5 http://www.enzeecommunity.com/thread/2089 SELECT DATENAME ( month , GETDATE ()) AS 'Month Name' This returns September in microsft SQL Server. I need to get a equivalent of the Datename function in Netezza. netezza functions Thu, 02 Sep 2010 08:19:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2089 2010-09-02T08:19:59Z 6 days, 12 hours ago 3 2