http://www.enzeecommunity.com/index.jspa?view=discussions Popular Discussion Threads in The Netezza Community en Wed, 08 Sep 2010 13:49:08 GMT Clearspace 2.5.3 (http://jivesoftware.com/products/clearspace/) 2010-09-08T13:49:08Z en 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, 18 minutes ago 3 2 http://www.enzeecommunity.com/thread/2087 Calling all enzees! Join us for single day local user group meetings in twelve cities worldwide this Fall. There's no cost, you can network with users locally, get product updates including 6.0 highlights, TwinFin i-Class for advanced analytics and roadshow netezza user group user_group twinfin i-class enzee_universe meeting 6.0 Mon, 30 Aug 2010 17:19:48 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2087 2010-08-30T17:19:48Z 1 week, 2 days ago 1 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, 48 minutes ago 4 3 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, 12 minutes ago 2 1 http://www.enzeecommunity.com/thread/2064 To refresh data from one NPS system (production) to another NPS system (development) which will be easy and less time consuming method nz_backup or nz_migrate? Note: We don’t need to migrate user / Group privileges. nz_backup or nz_migrate Thu, 12 Aug 2010 21:13:22 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2064 2010-08-12T21:13:22Z 2 weeks, 5 days ago 11 10 http://www.enzeecommunity.com/thread/2082 Has anyone successfully installed the Netezza Admin tool (4.6.2) on Ubuntu 10.04 via Wine? The functionality to view and change the permission for a user / group does not work. Anyway, is Netezza planning to support their Admin Tool on Linux? tool admin Wed, 25 Aug 2010 20:58:44 GMT bichonfrise74@gmail.com http://www.enzeecommunity.com/thread/2082 2010-08-25T20:58:44Z 1 week, 6 days ago 2 1 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 http://www.enzeecommunity.com/thread/2079 I am looking to see if netezza store's historical system uptime information. Any help will be greatly appreciated.   Thanks in advance. Wed, 25 Aug 2010 14:59:28 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2079 2010-08-25T14:59:28Z 1 week, 1 day ago 6 5 http://www.enzeecommunity.com/thread/2077 Hi,      I am trying to access Netezza from my JDBC code, I am using JDBC driver 5.0.10. My design is based on the error code returned from exception. would any one please tell me where can I get sql error codes returned by netezza.   Thank U Tue, 24 Aug 2010 18:00:14 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2077 2010-08-24T18:00:14Z 2 weeks, 8 hours ago 4 3 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/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/2084 hello -- I am trying to convert a large table with the following format         tab1:   id | fld1 | fld2 | ... | fld500 into a table with the following format         tab2:   rowid | colid | value   rowid corresponds to row_number in tab1 colid is Fri, 27 Aug 2010 16:49:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2084 2010-08-27T16:49:59Z 1 week, 5 days ago 2 1 http://www.enzeecommunity.com/thread/2086 Hello, I doint a rather large insert, and I'm received the following error.  I was wondering what the cause was.  I have searched the forum and couldn't find any reference.  org.netezza.util.PSQLException: Unable to fathom update count INSERT 0 Sat, 28 Aug 2010 20:44:49 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2086 2010-08-28T20:44:49Z 1 week, 3 days ago 3 2 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/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/2041 Hi All,   Does anyone know of any Opensource Free Tool to connect to Netezza SQL?   Thanks, Mohamed Tue, 27 Jul 2010 08:54:39 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2041 2010-07-27T08:54:39Z 1 week, 2 days ago 8 7 http://www.enzeecommunity.com/thread/2078 This simple update statement is failing due to spaces, quotes, slashes and "-" in the first input string:   #! /usr/bin/ksh if [ $# -ne 3 ]; then    rc=1    echo "You must give exactly 3 values"    exit 99 else     vals[1]=$1     vals[2]=$2     nzsql korn linux netezza shell Tue, 24 Aug 2010 18:46:48 GMT robert.dannels.238@my.csun.edu http://www.enzeecommunity.com/thread/2078 2010-08-24T18:46:48Z 2 weeks, 1 day ago 6 5 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/2052 Hi All,   I am pretty new to Netezza, can you please let me know how I can make this query work?   Update CUSTOMER_DEFECT a set M_FLAG = (Case when b.Source_code in  ('CHF', 'MLG' ) then 'Y' Else 'N' End) from  MIS_SRC_ID b  where a.ID =  b.ID update case Fri, 06 Aug 2010 04:03:11 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2052 2010-08-06T04:03:11Z 1 month, 3 days ago 4 3 http://www.enzeecommunity.com/thread/2071 Hey Guys,                       I keep on getting this error message ERROR:  206 : Transaction required, but no transaction started... , when I am trying to execute the netezza stored procedure, I checked for the syntax, and the procedure netezza procedures nzsql Mon, 16 Aug 2010 14:49:52 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2071 2010-08-16T14:49:52Z 3 weeks, 1 day ago 6 5 http://www.enzeecommunity.com/thread/2085 How can I get the current Netezza host name from within the NPS itself. For example:   select host_name, current_user   Obvisouly host_name doesn't work as a keyword, but there has to be something. Or it is stored some where within a table. Fri, 27 Aug 2010 20:54:58 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2085 2010-08-27T20:54:58Z 1 week, 4 days ago 3 2 http://www.enzeecommunity.com/thread/2051 Is there  a way to handle REPLACE Function in Netezza ? Fri, 06 Aug 2010 00:36:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2051 2010-08-06T00:36:10Z 2 weeks, 2 days ago 6 5 http://www.enzeecommunity.com/thread/1814 As a data analyst with needs to access database hosted on Netezza platform from time to time, I got a glimpse of the wonder of nzsql.  So I set out to search for some sort of quick reference of nzsql commands online but didn't see much.  Can anybody reference nzsql Tue, 09 Feb 2010 21:52:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1814 2010-02-09T21:52:37Z 7 months, 1 day ago 3 2 http://www.enzeecommunity.com/thread/2050 Hi all - relatively new user.  I run/support some scripts that run against a TwinFin db.  Recently I was asked to look at changing a view and when I ran my changes a s a SELECT statement as a test I get this error: ERROR:  netezza queries error Thu, 05 Aug 2010 14:55:51 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2050 2010-08-05T14:55:51Z 1 month, 4 days ago 2 1 http://www.enzeecommunity.com/thread/2075 I was asked this question and I was not sure how to answer it. I checked the /nz/kit/logs/postgres/*.log for the specific user but since the logs are not being kept forever, then the user might not be in the logs anymore. Then I tried to look at the login audit Fri, 20 Aug 2010 19:04:13 GMT bichonfrise74@gmail.com http://www.enzeecommunity.com/thread/2075 2010-08-20T19:04:13Z 2 weeks, 5 days ago 2 1 http://www.enzeecommunity.com/thread/2074 We just started on the Netezza platform. Does anyone know the internal views/tables that would hold the current size of all the databases? I am looking for just a simple query to generate a report off of. Thu, 19 Aug 2010 20:29:23 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2074 2010-08-19T20:29:23Z 2 weeks, 5 days ago 5 4 http://www.enzeecommunity.com/thread/2080 Has anyone had any success or failure or experience loading large amounts of data (300M+ records) from Netezza to QlikView? Or, has anyone used QlikView in conjunction with Netezza?   Thanks! qlikview Wed, 25 Aug 2010 16:04:39 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2080 2010-08-25T16:04:39Z 2 weeks, 9 hours ago 1 http://www.enzeecommunity.com/thread/2047 Hi ,   How to find the table last modified date(i.e insert/upadte transaction taken place) in netezza Wed, 04 Aug 2010 06:03:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2047 2010-08-04T06:03:53Z 1 month, 4 days ago 4 3 http://www.enzeecommunity.com/thread/2053 Am getting the following error message when my Netezza stored procedure is processing data from a table. On analysing the data , it  was found to contain special characters like 'PROFESSIONAL JOURNAL–ADVERTISING' (Column name: utf-8 error is input not Fri, 06 Aug 2010 14:29:04 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2053 2010-08-06T14:29:04Z 1 month, 12 hours ago 4 3 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/2048 Enzee Community members, take a look at Phil's posting today Four Fundamental Differences Between TwinFin and Exadata , download the eBook aand share your thoughts, comments and ideas on this topic. exadata twinfin ebook phil oracle_database_machine four fundamentals francisco compared vs Wed, 04 Aug 2010 16:20:33 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2048 2010-08-04T16:20:33Z 1 month, 5 days ago 1 http://www.enzeecommunity.com/thread/2061 hi I ran sql : select cast((30/40) as numeric(3,2)) ; It is giving the following result.   ?COLUMN? ----------      0.00 (1 row)   I want the original result 0.75. I don't know whats happening in netezza for this. I think it is taking it as cast Mon, 09 Aug 2010 11:53:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2061 2010-08-09T11:53:06Z 1 month, 11 hours ago 2 1 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, 52 minutes ago 2 1 http://www.enzeecommunity.com/thread/2045 Wondering if there is syntax similar to Oracle's for including a non-grouped total line in a grouped query.  In the database users guide, 'ROLLUP' and 'CUBE' are listed as keywords, but I can't find any other documentation or get them to work.  This is aggregate cube group_by_cube group_by_rollup rollup group_by Fri, 30 Jul 2010 16:33:36 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2045 2010-07-30T16:33:36Z 1 month, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1627 Hi, for loading purpose i am using nzload command in netezza, for that i have .csv data to datawarehouse tables, now i want to load some tables using SSIS tool, so i am not getting proper way for it. i have tried with ODBC connection, but the source discuss netezza queries twinfin active Tue, 22 Sep 2009 15:33:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1627 2009-09-22T15:33:07Z 1 month, 1 week ago 6 5 http://www.enzeecommunity.com/thread/2036 What is the syntax to get the escapechar in create external table using to work in a stored procedure?   This syntax will give an error if used within a stored procedure, but if type directly within nzsql, it works fine. If I remove the "ESCAPECHAR nzplsql procedures stored_procedure Fri, 23 Jul 2010 17:19:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2036 2010-07-23T17:19:10Z 1 month, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/2007 HI all,   We have a procedure that inserts into a table named QA_SUB_PROCESS_SOURCE_TOTAL, after which it computes the count on the number of rows  inserted in the current run by using a process id. This count is used for further processing. It is transaction serialize error Wed, 30 Jun 2010 15:30:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2007 2010-06-30T15:30:10Z 1 month, 11 hours ago 6 5 http://www.enzeecommunity.com/thread/1957 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in nzload table external Thu, 20 May 2010 13:37:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1957 2010-05-20T13:37:53Z 3 months, 1 week ago 10 9 http://www.enzeecommunity.com/thread/2043 Hello All, I am trying to learn neteeza, Can any one please let me know where i can find the material?   Thanks, Arvind netezza Thu, 29 Jul 2010 22:39:19 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2043 2010-07-29T22:39:19Z 1 month, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1560 Is there a way to use nzload with external tables to extract data from an Oracle datasource and load to a Netezza table? nzload Wed, 22 Jul 2009 17:10:45 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1560 2009-07-22T17:10:45Z 1 year, 1 month ago 21 20 http://www.enzeecommunity.com/thread/2037 Hi,   I need to have a column alias name with '+' & '[]'. Is that possible to do that.   Thanks in advance.   Thanks, S.Sampath Kumar Mon, 26 Jul 2010 11:34:28 GMT ksampath@firstam.com http://www.enzeecommunity.com/thread/2037 2010-07-26T11:34:28Z 3 weeks, 6 days ago 8 7 http://www.enzeecommunity.com/thread/1645 Hi Guys,   I am pretty new to Netezza and I thought you can give me some hints on my problem.   I need to extract substring containing full words from source column. I think the easiest way would be using regex for that.   1. I heard that Mon, 05 Oct 2009 13:56:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1645 2009-10-05T13:56:57Z 2 weeks, 6 days ago 5 4 http://www.enzeecommunity.com/thread/1835 I am working on some Oracle SQL queries migrated to Netezza SQLs. While running execution plan I came accross the following nodes Project Node and HashNode. What exatcly happens to the queries having these kind of nodes. How do we know  which node is sql_tuning Tue, 16 Feb 2010 10:55:23 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1835 2010-02-16T10:55:23Z 6 months, 1 week ago 7 6 http://www.enzeecommunity.com/thread/1616 I am new to Netezza, doing some work on netezza and came across some isues related to in-built functions.Like in SQL we have " datediff "and "dateadd"  function to get the date between two date in order of day,month and year.Here i want to do the same netezza Mon, 14 Sep 2009 13:19:56 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1616 2009-09-14T13:19:56Z 10 months, 3 weeks ago 10 9 http://www.enzeecommunity.com/thread/2040 We are trying to monitor long-running queries, and I have a couple of questions: Is the threshold that triggers the runaway query event the same as "Query Timeout,"  which is defined for users and groups?  If not, what is it, and how can I access it? We runaway_query events query_timeout monitoring long_running Mon, 26 Jul 2010 15:42:33 GMT drosenthal@valuecap.com http://www.enzeecommunity.com/thread/2040 2010-07-26T15:42:33Z 1 month, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1624 Hello, We currently use Cognos Data Manager as an ETL tool but we have come many across many issues and feel it is no longer beneficial to continue creating work arounds for the product inadequacies. We have future requirements for DI across the board data_manager etl push_down informatica elt sas bodi Mon, 21 Sep 2009 08:26:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1624 2009-09-21T08:26:07Z 11 months, 2 weeks ago 7 6 http://www.enzeecommunity.com/thread/2039 Are there any options in Netezza to compare character data in a case insensitive way?  For example, can a collation other than binary (one that specifies case insensitive) be specified for a database or a column in a table?  If not in 5.0, are there case_insensitive collation Mon, 26 Jul 2010 13:57:34 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2039 2010-07-26T13:57:34Z 1 month, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1785 Hi all   how to load data from oracle database to netezza database?   i am fallowing one method in that first i am downloading the data from oracle to flatfile then using nzload to load the data   but it is time consuming to take the data Tue, 19 Jan 2010 15:43:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1785 2010-01-19T15:43:31Z 5 months, 2 weeks ago 28 27 http://www.enzeecommunity.com/thread/2015 I am getting varchar data from an external source that is supposed to have numbers or be null.  Unfortunately, there are quite a few instances were non numeric data shows up.  This data gets loaded to a table that is defined the same way the file comes Thu, 08 Jul 2010 19:11:26 GMT john.moreth@landsend.com http://www.enzeecommunity.com/thread/2015 2010-07-08T19:11:26Z 2 months, 2 days ago 3 2 http://www.enzeecommunity.com/thread/2030 Hi ,   when I was analysing the plan file,I could see the term (SQB short) mentioned in the plan file.Can anyone please educate me more about this.     Thanks Wed, 21 Jul 2010 12:06:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2030 2010-07-21T12:06:12Z 1 month, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1658 Hi Folks,   I am very surprised if netezza take 2 and half hour to load 40 millions records into target table with 215 columns.   I am simply using one fact table and two dimension tables. Each dimension table has 70000 records and fact table netezza inserts Tue, 20 Oct 2009 05:37:09 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1658 2009-10-20T05:37:09Z 10 months, 3 weeks ago 5 4 http://www.enzeecommunity.com/thread/2038 Hi All,   Please assist me in where to find the (NPS Restart )/ nzstop or nzstart Log in NPS Version 4.0.2 ?   Thanks, Mohamed Mon, 26 Jul 2010 11:44:54 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2038 2010-07-26T11:44:54Z 2 weeks, 7 hours ago 5 4 http://www.enzeecommunity.com/thread/2024 Hi ,   I am geeting this error when try to exceute VIEW in netezza, i have extracted defination from NZADMIN, one which is running other is not running:   Running query column as:   NULL::UNKNOWN AS ANOMALY_FLAG   Not running query error twinfin nzsql functions twin netezza queries Mon, 19 Jul 2010 12:26:04 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2024 2010-07-19T12:26:04Z 1 month, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/2046 I’d like to be able to set up a scheduled job to run nzreclaim, and track its progress.   But I don’t understand the numbers that nzreclaim returns. Here’s an example.   I have a table TXN_FEE_FACT that appears to have a size of 815886800 bytes: > nzreclaim nzadmin Fri, 30 Jul 2010 22:11:17 GMT drosenthal@valuecap.com http://www.enzeecommunity.com/thread/2046 2010-07-30T22:11:17Z 1 month, 1 week ago 4 3 http://www.enzeecommunity.com/thread/2011 Recently at the user conference a speaker noted that Netezza can quickly and easily query hierarchy tables.  How is such a task implemented, as I can't seem to use the WITH RECURSIVE or a CONNECT BY style syntax. queries Tue, 06 Jul 2010 18:07:52 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2011 2010-07-06T18:07:52Z 2 months, 3 days ago 3 2 http://www.enzeecommunity.com/thread/2014 Hi netezza experts,   I have a table containing strings that represent dates e.g. '2010-03-22'.  Some of the rows contain invalid date strings.   When I try to query I get the following error:   nzsql> select Thu, 08 Jul 2010 01:51:20 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2014 2010-07-08T01:51:20Z 2 months, 2 days ago 3 2 http://www.enzeecommunity.com/thread/2013 I am trying to load data (2billion+ records) into a table.  The data is in bz2 compressed, pipe-delimited files (this is claims data and I have a file for each month).  Currently, I have a Python script generating a shell script which looks like this: Wed, 07 Jul 2010 18:58:49 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2013 2010-07-07T18:58:49Z 1 month, 3 weeks ago 7 6 http://www.enzeecommunity.com/thread/1967 Folks My current system of ETL where data from mysql goes to Netezza works fine (Delimiter in my files is '|' character). In mysql, when you dump the data, the null values are dumped as '\N'.   In Netezza, the value that is equivalent to NULL is Thu, 03 Jun 2010 14:33:05 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1967 2010-06-03T14:33:05Z 3 months, 1 week ago 8 7 http://www.enzeecommunity.com/thread/2034 Hi,   While analysing the plan file,I found a join condition as ""column name=_vt_inlist_rel7"."c1"",but I could not find any term as "_vt_inlist_rel7"."c1" and also I could hardly have any idea on this.   Can some one help me on this please? Thu, 22 Jul 2010 11:38:09 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2034 2010-07-22T11:38:09Z 1 month, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/2032 Hello,   The structure of my table is:   CREATE TABLE SAMPLE (RDATE DATE, RTIME TIME, "Context" VARCHAR(38), "pkt" BIGINT, "imb" BIGINT);   CREATE VIEW myView as (    select rdate,    rtime,    "Context",    "pkt",    "imb"    from correlated with keyword query Wed, 21 Jul 2010 15:54:42 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2032 2010-07-21T15:54:42Z 1 month, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/1977 Hi,   I am trying to get a unique user count for a period from a temporary table. Temp table is a snippet of the main table T1 and is distributed on i_id.   I created 2 temp table using the same query and have the same data, only difference is Thu, 10 Jun 2010 11:02:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1977 2010-06-10T11:02:06Z 2 months, 3 weeks ago 11 10 http://www.enzeecommunity.com/thread/2029     Hi,      I am trying to investigate on the queries which were run 3-4 days back and I could not get the plan files for them through NZADMIN tool.Is there any possiblity to get these plan files from NZ system or are ther any views or so to have these Tue, 20 Jul 2010 10:38:08 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2029 2010-07-20T10:38:08Z 1 month, 2 weeks ago 7 6 http://www.enzeecommunity.com/thread/1964 Folks How does Netezza respond to an attempt to try and load multiple files into the same staging table at the same time? Do the loads run actually in parallel or do they get serialized? Assume the files are not on netezza server and are being loaded Tue, 01 Jun 2010 14:53:21 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1964 2010-06-01T14:53:21Z 3 months, 1 week ago 10 9 http://www.enzeecommunity.com/thread/1588 Hi folks, In the "Netezza Performance Server Administrator’s Guide" I see the following paragraph.   "With NPS Release 4.5 and beyond, Netezza offers an optional Compress Engine feature, which is part of the FPGA-Accelerated Streaming Technology compress_engine Wed, 12 Aug 2009 22:52:56 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1588 2009-08-12T22:52:56Z 1 year, 3 weeks ago 11 10 http://www.enzeecommunity.com/thread/2010 I have some doubt on checking condition for EMPTY column.   I have created one table as ravi_test     RNO NAME CLASS 1 ravi 2 raju 22 deepak NULL   here if i fire query like   select * from ravi_test where class is not null; twin twinfin netezza nzsql active Mon, 05 Jul 2010 15:11:41 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2010 2010-07-05T15:11:41Z 2 months, 2 days ago 6 5 http://www.enzeecommunity.com/thread/1979 I'm new in the Netezza space and was hoping there was some handy documentation regarding the _t_user, _t_usrobj_priv, _t_database and similar tables that would assist in doing a direct look up for users, databases, groups, and permissions.  I initially odbc primary_key user practices Thu, 10 Jun 2010 18:14:42 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1979 2010-06-10T18:14:42Z 1 month, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/2018 Hi,   How to achieve "Substract one month to a date" in Netezza. I have tried "add_months(current_date,-1)". Tue, 13 Jul 2010 10:15:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2018 2010-07-13T10:15:57Z 1 month, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/2021 Hi,could you please let me know how can I check in my Planfile whether the table is redistributed or Broadcasted to complete the join condition? Thu, 15 Jul 2010 13:54:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2021 2010-07-15T13:54:29Z 1 month, 3 weeks ago 7 6 http://www.enzeecommunity.com/thread/2012 Hi All,   I have severe performance issue with one of my query. PFB the ddl and query details.   CREATE TABLE STAGE ( id integer, cat_desc  varchar(128), vat_descr varchar(128) sub_descr varchar(128)) distribute on (id);   Number of Wed, 07 Jul 2010 17:38:51 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/2012 2010-07-07T17:38:51Z 2 months, 3 days ago 2 1 http://www.enzeecommunity.com/thread/1874 I am a senior level Oracle professional. I am now considering investing in Netezza training and certification and wondering whether this would be a good investment. I have a strong background as Oracle developer and data architect. I have done DBA work Fri, 19 Mar 2010 06:54:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1874 2010-03-19T06:54:29Z 5 months, 5 days ago 23 22 http://www.enzeecommunity.com/thread/1509 Hi I have a situation where we look up data in the data warehouse and process them in short intervals (e.g. every 2 minutes or so.) Only one thread would be doing this. The processing results though involve inserts and updates into other tables which updates schema inserts primary_key Wed, 20 May 2009 14:14:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1509 2009-05-20T14:14:59Z 1 year, 2 months ago 7 6 http://www.enzeecommunity.com/thread/1820 Hi, I have created tables Year,Quarter and Month in my Netezza DB For thses tables I have :-                           Year_id--->Primary key in Year table                           Quarter_Id--->Primary key in Quarter table Thu, 11 Feb 2010 12:30:58 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1820 2010-02-11T12:30:58Z 6 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1673 Hi,   where can I find some documentation on stored procedure (function)   thanks d procedures Mon, 26 Oct 2009 11:32:01 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1673 2009-10-26T11:32:01Z 10 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1497 Hi all,   Is there any data masking tool available which can interface to Netezza? (Other than Informatica)   -Thangavel data_mask Wed, 06 May 2009 06:26:21 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1497 2009-05-06T06:26:21Z 9 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1762 Hi All,   i am completely new to Netezza i have few questions: we are planinig to migrate oracle to Netezza   1Q. if we dont have stored procedure option then how we can store data in netezza   2Q.presently we are using shell script to Thu, 07 Jan 2010 15:44:34 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1762 2010-01-07T15:44:34Z 8 months, 3 days ago 5 4 http://www.enzeecommunity.com/thread/1751 Hi All,   Can anyone please tell me that when i am retrieving the current timestamp by "now()" , i am getting the format as "2009-12-29 10:00:37". But i want the timestamp to display the milliseconds also. For example, "2009-12-29 10:00:37.126". Tue, 05 Jan 2010 15:40:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1751 2010-01-05T15:40:07Z 2 months, 1 day ago 5 4 http://www.enzeecommunity.com/thread/1878 Hi- I've searched around for a solution to this and have come up empty. How do you deal with the effect of daylight saving in your queries that involve a time-zone shift? I'm hoping to find a solution like MySQL where you can set a time_zone session and daylight_saving time_zone netezza Mon, 22 Mar 2010 01:48:49 GMT scott.nicholson@opinmind.com http://www.enzeecommunity.com/thread/1878 2010-03-22T01:48:49Z 5 months, 2 weeks ago 9 8 http://www.enzeecommunity.com/thread/1725 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm view replication cdc partition concurrent Fri, 11 Dec 2009 05:36:19 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1725 2009-12-11T05:36:19Z 9 months, 1 day ago 3 2 http://www.enzeecommunity.com/thread/1576 96 active disks plus 4 spares configured in RAID1 gives 48TB of total storage.  So this basically gives 32TB of user space and 16TB of spool/temp space per rack, right?   With only 4 spares in a full rack, this makes it clear the spares are somehow Wed, 05 Aug 2009 02:08:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1576 2009-08-05T02:08:35Z 3 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1777 Does anyone know how to convert the abstime into something that I can use? I am trying to collect data from some of the catalog tables:   create table table_stats as select t.owner, t.tablename, cast(t.CREATEDATE as timestamp) createdate, Wed, 13 Jan 2010 21:45:11 GMT mibrad@acxiom.com http://www.enzeecommunity.com/thread/1777 2010-01-13T21:45:11Z 7 months, 3 weeks ago 6 5 http://www.enzeecommunity.com/thread/1956 I am using NPS 4.6.2 and JDBC Driver for Netezza, Release 3.1 (Build 6341).   I am trying to execute a procedure in Sybase. If the procedure is not found in Sybase and I am generating some Exception and trying to insert a failure STATUS in Netezza. driver process query at time one can Thu, 20 May 2010 08:19:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1956 2010-05-20T08:19:53Z 3 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1703 We need to replicate UNIX/Teradata scripts as closely as possible to the Linux/Netezza environment.  Can a nzsql query return a result set to Linux script that invoked it?  Without a stored procedure?  Thanks! Thu, 19 Nov 2009 21:26:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1703 2009-11-19T21:26:15Z 9 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1735 Hi All we are migrating our oracle code to Netezza,i completely new to netezza,so i have few question regarding table creation what is distribute on in netezza table creation   below is the table script in oracle can any body convert this script to Tue, 22 Dec 2009 16:00:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1735 2009-12-22T16:00:12Z 8 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1680 We are using two NZ Databases. One is for QA server and the other is PRODUCTION server that have same setup.   The following query which is executed in QA consumes only 15-20 secs, rather it consumes 5-10 MINS in PRODUCTION server.     performance Fri, 30 Oct 2009 09:43:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1680 2009-10-30T09:43:12Z 10 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1988 I am trying to create a procedure that has a for v_row in select..... loop  .... end loop; logic  and i want to be able to dynamically use a different table each time it is called   so...for example  this procedure CREATE OR REPLACE PROCEDURE Tue, 22 Jun 2010 17:16:08 GMT john.townley@datalogix.com http://www.enzeecommunity.com/thread/1988 2010-06-22T17:16:08Z 2 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1972 Hi All,   While i try to create a table i get the following error:   /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; _i_object_name create table Mon, 07 Jun 2010 04:39:02 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1972 2010-06-07T04:39:02Z 3 months, 2 days ago 9 8 http://www.enzeecommunity.com/thread/2076 Hi, I am new to Nettezza community Could you please tell me whether Nettezza suit of produts'  trial version is  available or not. If complete set of products are not available which are the products availble in trial version.   Thanks, MoonwalaPL trial version database Tue, 24 Aug 2010 09:04:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2076 2010-08-24T09:04:10Z 2 weeks, 1 day ago 2 1 http://www.enzeecommunity.com/thread/1786 Hi Folks   I was googling on net and found  some intresting question on select  count prefomance on netezza. Thought will post it here..     http://netezzaforum.com/nps-advanced-concepts/select-query-performance-t19.html Do any one have any select count performance Wed, 20 Jan 2010 05:02:23 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1786 2010-01-20T05:02:23Z 7 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/2027 Hi ,   Does Netezza support "TYPE_SCROLL_INSENSITIVE" result set type.? If so how?   I am trying to fetch resultset as follows:   ResultSet rs=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,                     Mon, 19 Jul 2010 18:30:47 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2027 2010-07-19T18:30:47Z 1 month, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1462 Hi,     I have a curiosity ! What's the price of neteeza machine in Brazil we have just one company with this system.     Thanks   Antonio Rodrigues. Fri, 13 Mar 2009 02:47:32 GMT antonio.rodrigues@teraban.com.br http://www.enzeecommunity.com/thread/1462 2009-03-13T02:47:32Z 1 year, 4 months ago 4 3 http://www.enzeecommunity.com/thread/1812 Folks For removing duplicate records from a table in Netezza, what is the most efficient way?   I am thinking something like:     delete from dupl where rowid in (   select a.rid     from     (       select rowid rid, row_number() over Fri, 05 Feb 2010 15:46:42 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1812 2010-02-05T15:46:42Z 7 months, 4 days ago 9 8 http://www.enzeecommunity.com/thread/1930 I am new to netezza. I am trying to load data from database using netezza driver. Sometime its works fine but in some cased if no data exist in database getting following exception.   java.lang.NullPointerException -->>      abstractjdbc2statement getfetchsize netezzadriver nullpointerexception Tue, 27 Apr 2010 10:12:40 GMT revathy2.p@tcs.com http://www.enzeecommunity.com/thread/1930 2010-04-27T10:12:40Z 4 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1711 hi is there any utilities available in netezza like we used to have in teradata.   also please clarify the followig     1. is it true that netezza doesnt use - stored procedures, indexes, partitioning concept etc etc 2. how does the Sat, 28 Nov 2009 16:27:30 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1711 2009-11-28T16:27:30Z 9 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1989 Hi All,   I Just now joined this community so first first a big Hello to all of you.   I have a quick query. As per my understanding a stored procedure in netezza can return a result set. My tried following steps   (1) Create a temprary Wed, 23 Jun 2010 13:09:32 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1989 2010-06-23T13:09:32Z 2 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/2008 Folks Does anyone know what the error "org.netezza.error.NzSQLException: The action you have attempted has caused the back end to close the connection." means.   This occurs in a system once in a while. When we repeat the same transaction later error Wed, 30 Jun 2010 17:25:52 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2008 2010-06-30T17:25:52Z 2 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1901 Does anyone have the approach in which we can get the outdated columns of all the tables in a database so we can run generate statistics on these.   T use the nz_get and nz_genstats -infor which are GREAT!  nz_genstats goes to the whole db and netezza generate statistics sql optimizer Tue, 06 Apr 2010 14:43:45 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1901 2010-04-06T14:43:45Z 5 months, 1 day ago 7 6 http://www.enzeecommunity.com/thread/1731 On executing the below query, we are getting the below error: select regexp_instr(cast('53d9bfe1-1bc6-4ccd-a115-f50104d55a4b' as varchar(48)),cast( '[:alpha:]' as varchar(48)) ,1,1);   Error: ERROR: Function 'REGEXP_INSTR(VARCHAR, VARCHAR, INT4, Thu, 17 Dec 2009 12:34:28 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1731 2009-12-17T12:34:28Z 8 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1905 Hi All,   Is "with recursive" supported in netezza, and if so what is the usage.       here is the usage in Teradata:   /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; recursive with Fri, 09 Apr 2010 04:35:16 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1905 2010-04-09T04:35:16Z 5 months, 1 day ago 3 2 http://www.enzeecommunity.com/thread/2004 Not sure if this was posted already... just noticed that Netezza does not follow the Banker's Rounding Method... is there an easy workaround in Netezza to follow that method of rounding?   ex. CAST(0.125 AS DECIMAL(7,2)) In netezza, its output is  Tue, 29 Jun 2010 08:59:48 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2004 2010-06-29T08:59:48Z 2 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1941 Folks I am running into the "Could not serialize - transaction aborted". It happens when I am updating a table.     From the database user's guide document "Netezza SQL does not use conventional locking to enforce consistency among Wed, 05 May 2010 17:03:13 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1941 2010-05-05T17:03:13Z 4 months, 8 hours ago 11 10 http://www.enzeecommunity.com/thread/1912 Hi,   where could I get some documentation for advance query history (table desrc, ...)   thanks and bye d history Wed, 14 Apr 2010 11:54:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1912 2010-04-14T11:54:50Z 4 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1633 Hi,   Can someone guide me how to send parameters from a shell script to my nzsql script. I am able to call the nzsql script for inserting values into a table. But i need to send some parameters as values for inserting the values into the table. I Mon, 28 Sep 2009 20:09:23 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1633 2009-09-28T20:09:23Z 11 months, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/2026 Hi All,   I am completely new to netezza,i am working as an intern in my company and am trying to see if i can put an image file in netezza and how do i retrieve the image file from netezza.I have AQT on my desktop and Netezza ODBC driver.If anyone Mon, 19 Jul 2010 13:10:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2026 2010-07-19T13:10:57Z 1 month, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1850 We have a billion row standard fact table (integer/bigint surrogate keys, fact columns are all in numeric(p,s) format).   The NZ document recommends: Always use the smallest integer or fixed-point numeric whenever possible. When converting source numeric data exact types Wed, 24 Feb 2010 17:04:17 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1850 2010-02-24T17:04:17Z 6 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1638 Hi,   I have been working on teradata for quite some time and i wanted to know if there are any load and export utlities in netezza also. I.e. in teradata we have utilities like fast load( to bulk load) and fast export ( to bulk export data) from Thu, 01 Oct 2009 11:54:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1638 2009-10-01T11:54:12Z 11 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1848 I currently have a table with about 500 million rows.  Each row represents one transaction and includes 10 financial columns.  In order to support international business we need to add the ability to support optionally having different currencies for Tue, 23 Feb 2010 20:42:23 GMT ddenardo@invitemedia.com http://www.enzeecommunity.com/thread/1848 2010-02-23T20:42:23Z 6 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1672 I would use a non-printable character as a delimiter for external table to avoid load errors.  I tried (CTRL-SHIFT-‘_’) by entering directly (it displays as a box) but got an error saying the delimeter had to be a single, unsigned character.  Any external_table nzload Sun, 25 Oct 2009 14:20:34 GMT mark@edwblog.com http://www.enzeecommunity.com/thread/1672 2009-10-25T14:20:34Z 6 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1950 Hey All,      I am running a 64 bit machine attempting to connect Business Objects XI R2 Desginer to Netezza.  I can not find any drivers or patches to support the connection on my own so does anyone else have a solution. Thanks.   -RychieRych 64-bit boxi 64-bit_drivers Mon, 17 May 2010 16:34:28 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1950 2010-05-17T16:34:28Z 3 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/2028 I have 2 Twinfin Netezza boxes and I would like them to do cross machine/database connections, as with nz_migrate, nz_ddl, etc.  What are the basic requirements on each box as to the hosts file, env, or other LInux setup items?   Thanks,   connectivity netezza Mon, 19 Jul 2010 21:21:00 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2028 2010-07-19T21:21:00Z 1 month, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1566 Hi All,   I am new for netezza, having earlier experience with Oracle. Can any body please provide me some statement that how to create primary key/index , Procedure and function in Netezza?   problem is that I do not have netezza software so Fri, 31 Jul 2009 06:35:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1566 2009-07-31T06:35:53Z 1 year, 1 month ago 8 7 http://www.enzeecommunity.com/thread/1856 Hi,   i have table t1(with n columns) and t2 (with n+1 columns) and t3(PK_T1, GEN_KEY) .   for loop read data from t1   if PK_T1 in T3      take GEN_KEY from T3   else     next val from seque -> GEN_KEY.   end if      write GEN_KEY + inserts stored nzsql Tue, 02 Mar 2010 13:20:01 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1856 2010-03-02T13:20:01Z 6 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/2019 We've been looking into row-level security to see if it might be useful for us. In a row-secure table, there is an automatically generated column called _sec_label, which has three attributes:  security level, category, and cohort. Users can be given security netezza multi-level row-level twinfin Wed, 14 Jul 2010 15:08:12 GMT drosenthal@valuecap.com http://www.enzeecommunity.com/thread/2019 2010-07-14T15:08:12Z 1 month, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1959 Hi All, My client has several openings for ETL BACKEND DATABASE DEVELOPER/ENGINEERs in the North of Boston area. If you are interested please contact me at Gil Roeder VP Starpoint Solutions 155 Federal Street Boston MA gil.roeder@gmail.com datastage abinitio jobs neteeza datawarehouse Fri, 21 May 2010 16:38:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1959 2010-05-21T16:38:59Z 3 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1485 Will Java remain open and free? Will Oracle attempt an appliance with Oracle on Solaris? Thoughts? Tue, 21 Apr 2009 03:11:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1485 2009-04-21T03:11:25Z 11 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1934 I'm using version 4.5 of the driver and get below exception. Is there a later version of the driver that supports prepared statements? Exception in thread "main" org.netezza.util.PSQLException: This method prepareCall(String,int,int) is not yet Wed, 28 Apr 2010 22:26:39 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1934 2010-04-28T22:26:39Z 4 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1911 Folks We have been getting what seens to be broken/lost connections in Netezza.   While executing the patch, we got an error "pqFlush() -- connection not open".   Similarly our etl process (that connects using JDBC) gives intermittent error error lost-connection Tue, 13 Apr 2010 23:02:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1911 2010-04-13T23:02:53Z 4 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/2002 I am interested to know the challenges involved in migrating an application from Oracle to Netezza. Can you share some case studies highlighting the facts that needs to be taken in consideration.Also, please can you suggest how multiple indexes on a db Mon, 28 Jun 2010 03:05:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2002 2010-06-28T03:05:53Z 2 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/2001 Hi, I am using nzsql through unix script to fetch some records from netezza DB. I exported following variables:     export NZ_USER=admin export NZ_PASSWORD=password export NZ_DATABASE=system   Everything works fine.   Is there any Sat, 26 Jun 2010 18:58:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2001 2010-06-26T18:58:06Z 2 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1948 I am trying to use Netezza sequence in JDBC.   With the jdbc driver version 4.6.6, I consistently get one of the two exceptions:   Exception in thread "main" org.netezza.error.NzSQLException: FATAL 1:  Socket command type   unknown at Wed, 12 May 2010 21:26:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1948 2010-05-12T21:26:07Z 3 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1976   /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; Wed, 09 Jun 2010 20:03:43 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1976 2010-06-09T20:03:43Z 3 months, 1 day ago 1 http://www.enzeecommunity.com/thread/1724 I would like to know if it possible to use nzsql utility like a client tool on machines different from Netezza server.   I know that nzload is available as an "external" client tool: for instance, i can use nzload utility on my laptop to load data client utility nzsql Thu, 10 Dec 2009 15:13:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1724 2009-12-10T15:13:10Z 9 months, 2 days ago 7 6 http://www.enzeecommunity.com/thread/1505 Hello:      Is there anyway I could download data from NZ table to my local Unix box ?   'External table' seems create files in NZ box that I have no access to.   Thanks, Sid. Sun, 17 May 2009 12:37:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1505 2009-05-17T12:37:29Z 1 year, 2 months ago 15 14 http://www.enzeecommunity.com/thread/1671 Hi,   How can i spool data from a table into a file? something similar to the 'spool' command in Oracle. Would appreciate if anyone can help me with this query. I am using WinSql for quering the NZ database.   Thanks and regards,   Samir Fri, 23 Oct 2009 15:33:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1671 2009-10-23T15:33:44Z 10 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1783 Hi   We are migrating our datawarehousing application from Oracle to NZ.   Is there any concept in Netezza that is similar to table partitionaing in Oracle?   Here in Oracle we have a table split up into partitions and storing data for 36 Tue, 19 Jan 2010 10:20:22 GMT arun.sreekanth@cognizant.com http://www.enzeecommunity.com/thread/1783 2010-01-19T10:20:22Z 7 months, 2 weeks ago 14 13 http://www.enzeecommunity.com/thread/1683 What is the best way to dissect this error?  I know that I am getting this due to bad data, but Im trying to figure out the best solution to find the culprits when dealing with 70 billion rows.   Im trying to load click stream data and turning a Mon, 02 Nov 2009 16:33:28 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1683 2009-11-02T16:33:28Z 10 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1681 Hello all,   I am new to netezza and this in my first post in this community.   I need some help to create a generic sql script which will read records from numerous tables and insert into a target table. A generic SELECT statement which will generic_sql dynamic_sql parameterized sql Sat, 31 Oct 2009 02:53:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1681 2009-10-31T02:53:06Z 10 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1984 Hi,   why is this query     SELECT A.LETO_EFT,        B.KONSOLIDIRANA_DAVCNA_ST, SUM(A.KOMAD_ZAVAROVANJA) ST_KOMADOV_ZAVAROVANJ   FROM DIM..OSEBE B, POL_SNP..CRM A WHERE ( B.OSEBA_ID = A.PRVI_ZAVAROVANEC_ID OR         B.OSEBA_ID = join sql_performance Mon, 21 Jun 2010 12:49:08 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1984 2010-06-21T12:49:08Z 2 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1773 Hi all   Netezza rocks, as well the users. Found a new website http://netezzaforum.com Users & Moderators are Welcome!!! Lets build a Strong Netezza User Competancy Group across the world   Cheers Superuser http://netezzaforum.com netezza forum Wed, 13 Jan 2010 06:58:57 GMT srinivas.blademaster@gmail.com http://www.enzeecommunity.com/thread/1773 2010-01-13T06:58:57Z 7 months, 4 weeks ago 3 2 http://www.enzeecommunity.com/thread/1990 Hi,      On Unix AIX, I'm trying to connect via Netezza ODBC 4.5 but it can't logon even I input correct username and password.     I got error msg as: Client unable to establish connection, sqlstate = 08001, native code = 1.      I don't know what's odbc netezza Thu, 24 Jun 2010 04:06:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1990 2010-06-24T04:06:25Z 2 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1728 Hi ,   can anyone tell me that how to create sequence in Netezza? when i an trying to create for 85,000 rows, it is startibg taking random values after some time. So can anyone please tell me how to create and use the sequence generating unique and Mon, 14 Dec 2009 09:05:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1728 2009-12-14T09:05:24Z 8 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1690 Dear experts ;   I had created a procedure .But now I wnat to see the code of the procedure . when i am doing show procedure procedure_name(arguments) it is not showing the code details . So is there any way so that I can see the detailed code of show procedure Thu, 12 Nov 2009 14:09:46 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1690 2009-11-12T14:09:46Z 3 months, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/1729 Hi,   I tried to post this in the "Prospective Users" list, but it didn't give me that option.   We're on MySQL, and we'd like to port over to Netezza.  I have several questions:   1)  Is Netezza strictly designed for only DW type netezza mysql Wed, 16 Dec 2009 19:10:05 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1729 2009-12-16T19:10:05Z 7 months, 1 week ago 11 10 http://www.enzeecommunity.com/thread/1657 Hi All,   I am stuck to populate surrogate key in my target table.   My scanario is that I have feed file with three columns and target table contains four columns.   I want to populate surrogate key as primary key for fourth column with nzload netezza Mon, 19 Oct 2009 12:32:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1657 2009-10-19T12:32:44Z 10 months, 3 weeks ago 17 16 http://www.enzeecommunity.com/thread/1622 Hi , i got error when i run a stored procedure with the sequence generation. Actually i need a self generated column in my database table. my procedure goes like this. i have created a sequence first as   CREATE SEQUENCE prodcategory_seq INCREMENT netezza active twinfin Thu, 17 Sep 2009 15:15:03 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1622 2009-09-17T15:15:03Z 11 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1734 Trying to follow the post from Shawn Fox describing the use of HERE document to pass variable from a shell script to nzsql.   Have the following code that is resulting in an error when executed from the command line.   #!/bin/sh # # nzsql Sat, 19 Dec 2009 13:28:55 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1734 2009-12-19T13:28:55Z 8 months, 3 weeks ago 5 4 http://www.enzeecommunity.com/thread/1978 Im trying to test my new nzsql procedure - is there the equivalent of oracle's dbms_output.put_line so i can test?    any other suggestions on helpful testing of procedures? Thu, 10 Jun 2010 17:17:11 GMT john.townley@datalogix.com http://www.enzeecommunity.com/thread/1978 2010-06-10T17:17:11Z 2 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1700 Hi,   Can anyone please let me know about a way to send e-mail from Netezza Database. using procedure or scripts.   Thanks Krish mail procedures Wed, 18 Nov 2009 03:58:51 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1700 2009-11-18T03:58:51Z 9 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1942 Is there a Netezza function to convert IP address to Numbers and vice-versa? If not, is there a UDF or has someone created a stored procedure for this? function ip address Wed, 05 May 2010 19:03:08 GMT bichonfrise74@gmail.com http://www.enzeecommunity.com/thread/1942 2010-05-05T19:03:08Z 4 months, 5 days ago 2 1 http://www.enzeecommunity.com/thread/1974 I'm new in the Netezza space and was hoping there was some handy documentation regarding the _t_user, _t_usrobj_priv, _t_database and similar tables that would assist in doing a direct look up for users, databases, groups, and permissions.   Thanks odbc primary_key practices user Wed, 09 Jun 2010 15:34:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1974 2010-06-09T15:34:07Z 3 months, 1 day ago 1 http://www.enzeecommunity.com/thread/1975 Folks,   I have been using the Netezza XML functions  XMLSerialize, XMLAGG & XMLElement found in the Netezza SQL Toolkit.   Problem I have, is that the XMLagg function is not behaving in the same manner as the XMLagg function on Oracle.   xml xmlagg xmlelement Wed, 09 Jun 2010 16:38:37 GMT ian.wylie@bskyb.com http://www.enzeecommunity.com/thread/1975 2010-06-09T16:38:37Z 2 months, 4 weeks ago 11 10 http://www.enzeecommunity.com/thread/1816 We've encountered this error during our ETL load which uses a NZSQL script. Could anyone let me know the cause of the error? The current NPS version is 4.6.2. Thanks! error Thu, 11 Feb 2010 09:28:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1816 2010-02-11T09:28:57Z 6 months, 4 weeks ago 2 1 http://www.enzeecommunity.com/thread/1886 Hi All,   Can anyone please explain me in detail by giving example that what a transaction means?   Thanks and Regards, Varun Tripathi Mon, 29 Mar 2010 14:20:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1886 2010-03-29T14:20:12Z 5 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1884 Hi all,   Can anyone please tell me that why TRUNCATE TABLE command does not work inside a procedure and works as a single command??   Thanks and Regards, Varun Tripathi Mon, 29 Mar 2010 06:04:45 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1884 2010-03-29T06:04:45Z 5 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1843 Hi All,   I have created one procedure in Netezza called "P_REP_GET_BLOCK_COUNTS". Now if i am trying to GRANT the permission to PUBLIC, it is npt allowing me to do that.   twin discuss active netezza twinfin procedures queries Mon, 22 Feb 2010 07:37:14 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1843 2010-02-22T07:37:14Z 6 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1888 Hi, We are getting ERROR: SPU Swap partition: Disk temporary work space is full error message in one of our environment. Same query runs fine in another environment with similar server configuration.. My Netezza admin says that we have 25GB memory on Tue, 30 Mar 2010 21:10:10 GMT aagrawal@infocepts.com http://www.enzeecommunity.com/thread/1888 2010-03-30T21:10:10Z 5 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1810 Hi All,   I have account and can access to the partner server of Netezza from https://partner.netezza.com/ . Under windows, I can login and it change the host file and  will start a session, I can use 127.0.1.10 as server address of odbc. I can unix netezza partner Fri, 05 Feb 2010 07:02:14 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1810 2010-02-05T07:02:14Z 7 months, 5 days ago 3 2 http://www.enzeecommunity.com/thread/1705 Hi all, We are currently doing a POC on netezza. To get the data in the netezza, we dump ,through datastage, the data of an oracle table in a CSV file, then use nzload to upload the data to the netezza database. This is working fine except with some Fri, 27 Nov 2009 09:30:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1705 2009-11-27T09:30:59Z 9 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1737 hi Is there any way to find out distribution column while creating tables,other than manually checking the sql which column we are using more frequently for joins   Thanks Tue, 22 Dec 2009 20:42:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1737 2009-12-22T20:42:35Z 8 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1715 Hi, when i use Netezza jdbc driver connect to Netezza  database, i meet a problem ------------------------------------------------------------------------------------------------- Connect to Netezza database by Netezza jdbc driver Commit some sql Tue, 01 Dec 2009 10:15:22 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1715 2009-12-01T10:15:22Z 9 months, 4 days ago 5 4 http://www.enzeecommunity.com/thread/1986 Hi         We are working currently to design and develop UDF in Netezza. Can you please let me know the c++ compiler version that i need to use for the development.   Thanks udf Tue, 22 Jun 2010 07:06:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1986 2010-06-22T07:06:10Z 2 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1892 For example, you have group A with 10 members. I want to clone group B from group A so that group B will have the 10 members and all the privileges from group A. The purpose of this is to have 2 groups A & B, and I will be making a small change in Thu, 01 Apr 2010 21:35:33 GMT bichonfrise74@gmail.com http://www.enzeecommunity.com/thread/1892 2010-04-01T21:35:33Z 5 months, 5 days ago 2 1 http://www.enzeecommunity.com/thread/2016 Here is the source code for a UDF that I wrote (based on Oleg's example: http://www.aginity.com/Blog/tabid/182/PostID/55/Creating-a-Netezza-User-Defined-Function-(UDF).aspx )   SELECT TEST_NVL(null, 'world') returns 'world'   SELECT udf oracle string function udx user defined empty nvl Thu, 08 Jul 2010 20:54:48 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2016 2010-07-08T20:54:48Z 1 month, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1489 has anyone every tried deployed a column based db like kx etc on netezza-style architecture Wed, 22 Apr 2009 16:41:52 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1489 2009-04-22T16:41:52Z 1 year, 4 months ago 3 2 http://www.enzeecommunity.com/thread/1648 hi, i have tried putty for nzload and also using command prompt to do loading of files.using nzload in command prompt shell its giving error in takin ',' (comma) separated records.Is it like it will not take  -delim ',' separated files to load... which discuss netezza active enzee_universe twinfin twin fin Mon, 12 Oct 2009 09:30:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1648 2009-10-12T09:30:12Z 3 months, 4 weeks ago 13 12 http://www.enzeecommunity.com/thread/2023 While analysing the plan file, I could see a term mentioned as Cardinality.Can anyone please let me know what it means and the reason for its occurance.   Thanks In Advance!!! Fri, 16 Jul 2010 14:51:47 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2023 2010-07-16T14:51:47Z 1 month, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1490 Hi i m new to netezza and i hope this is where i should post my questions....   I know you can add say 30 minutes to a datetime field by using interval statement and the minutes in single quote. What happen if the minutes you are adjusting are a Fri, 24 Apr 2009 15:02:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1490 2009-04-24T15:02:37Z 1 year, 4 months ago 6 5 http://www.enzeecommunity.com/thread/1927 Hi,   In Netezza, user can check the  stored procedure content by   SHOW PROCEDURE  procedure_name VERBOSE;   is there a way to hide the content of stored procedure by all users?   Thanks, Frank Fri, 23 Apr 2010 04:17:34 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1927 2010-04-23T04:17:34Z 3 months, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/1902 Get this message when executing query - ERROR: CLI execute error: Unable to retrieve error message.   Unfortunately, query is so complex it would have been nice if Netezza could have given me a hint. Query is a SAS PROC SQL with ODBC connections generic_sql queries netezza Tue, 06 Apr 2010 16:06:04 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1902 2010-04-06T16:06:04Z 5 months, 3 days ago 3 2 http://www.enzeecommunity.com/thread/1903 Can Netezza store the object name in a Case-sensitive way?   I can find following sentence in Netezza database use-guide:   NPS system converts any regular identifer you specify into uppercase characters when it is saved in the database   Wed, 07 Apr 2010 02:48:34 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1903 2010-04-07T02:48:34Z 5 months, 4 days ago 6 5 http://www.enzeecommunity.com/thread/1973 Hi,   To verify for any query performance in NZ,suggest any commands like nzsqa .... Mon, 07 Jun 2010 18:56:33 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1973 2010-06-07T18:56:33Z 2 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/2009 There are various data load job running on netezza database while a complex select query is also used to retrieve data. I have found that this SQL take quite long to return results. I have observed that the performance improves when data load is not Thu, 01 Jul 2010 14:33:01 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2009 2010-07-01T14:33:01Z 2 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1578 Attched the NZ Load information, with syntax and options.   ############################################################################################ To load the database dev as user admin with the password production, specifying the table name Thu, 06 Aug 2009 05:42:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1578 2009-08-06T05:42:25Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1933 Folks, I have a file (containing double quote delimited data) that has sometimes '\n' as part of the string character (supposed to be loaded into a table's varchar column) Is there an option in netezza loader that makes it ok to have '\n' as part of the Wed, 28 Apr 2010 15:54:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1933 2010-04-28T15:54:29Z 4 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1733 http://googlefight.com/index.php?lang=en_GB&word1=Exadata&word2= Netezza exadata netezza oracle Thu, 17 Dec 2009 20:06:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1733 2009-12-17T20:06:24Z 8 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1796 We are running DataFlux on Red Hat Linux.  We are trying to figure out a way to have DataFlux connect to Netezza in Linux so we can run server-side jobs.   We can connect to Netezza with the DataFlux client using the normal Netezza ODBC driver in connection dataflux Fri, 22 Jan 2010 21:25:56 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1796 2010-01-22T21:25:56Z 6 months, 3 weeks ago 6 5 http://www.enzeecommunity.com/thread/1592 Hi,      I am new to netezza and my project is using netezza.   In Oracle we have the Ntile() command to do the market basket analysis, what is the equivalent in Netezza?     Please help me       Regards skarthi Mon, 17 Aug 2009 21:42:48 GMT skarthi98@hotmail.com http://www.enzeecommunity.com/thread/1592 2009-08-17T21:42:48Z 1 year, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1765 Hi i have created table below i wanted change the distribution key from random to aqaycd   CREATE TABLE PSTALWAA (   AQAYCD   NUMERIC(7)                       NOT NULL,   AQSABB   VARCHAR(2)                       NOT NULL,   AQAYSS   Thu, 07 Jan 2010 19:55:16 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1765 2010-01-07T19:55:16Z 8 months, 12 hours ago 3 2 http://www.enzeecommunity.com/thread/1721 Is there a possible to do CDC in Netezza? Can we use deletexid, rowid, createxid to get this information? or does incremental backup allows to get CDC on plain text?   -Bala cdc Tue, 08 Dec 2009 19:18:04 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1721 2009-12-08T19:18:04Z 9 months, 4 days ago 2 1 http://www.enzeecommunity.com/thread/1701 I am trying to move data from a table in SQL Server to Netezza. I have created a format file with column delimit as "|" and row delimit as \r\n. looks like there is a carriage return in one of my varchar field. it is creating a new line in my textfile Wed, 18 Nov 2009 16:06:39 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1701 2009-11-18T16:06:39Z 9 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1664 is there a way to collect the number of row affected due to update or delete or insert statement row count Thu, 22 Oct 2009 12:45:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1664 2009-10-22T12:45:25Z 10 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1693 Colud some one let me the query to list the columns of a table in NETEZZA. I'm new to the netezza queries Fri, 13 Nov 2009 06:40:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1693 2009-11-13T06:40:15Z 9 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/2006 hi all, how could I check if  a character column has and character value in it? since ISNUMERIC function is not supported in Netezza is there any other function which would let me do this? for  example, if a column contains 100, 200, 1AA1, abcd. I isnumeric select character values Wed, 30 Jun 2010 05:52:17 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/2006 2010-06-30T05:52:17Z 2 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1922 Hi All,   I am trying to do Connection Pooling for Netezza db from java. I am using nzjdbc.jar. I created datasource for the db using NZConnectionPoolDataSource,through this data source, i get a PooledConnection. The PooledConnection object gives Thu, 22 Apr 2010 12:36:21 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1922 2010-04-22T12:36:21Z 3 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1991 Hi Guys,   Just want to know, which SQL is faster...   insert to TableX select <all_fields> from   Table2 t2 where not exists (select 1 from Table1 t1 where t1.field1 = t2.field1)   or   insert to TableX select Thu, 24 Jun 2010 11:41:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1991 2010-06-24T11:41:31Z 2 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1468 Hello enzees,   We're pleased to announce the dates and locations for Enzee Universe 2009! This year, we're bringing Enzee Universe to you in seven cities worldwide starting on 6/10/09 in Boston, MA. Each program will be a one-day event with universe conference enzees agenda netezza enzee user Tue, 24 Mar 2009 19:19:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1468 2009-03-24T19:19:37Z 1 year, 5 months ago 1 http://www.enzeecommunity.com/thread/1562 I'm wondering if anyone out there has first-hand experience of using Affinium Campaign Management software with Netezza? Specifically regarding how much of the 'grunt' work can be pushed down to the database.. e.g. does the SQL generated by Affinium application_integration affinium pushdown_processing Wed, 29 Jul 2009 12:45:44 GMT dave.shuttleworth@edge-a.co.uk http://www.enzeecommunity.com/thread/1562 2009-07-29T12:45:44Z 1 year, 1 month ago 5 4 http://www.enzeecommunity.com/thread/1883 I am new to Netezza and would like to mimic some functionality I have in Oracle.  I would like to create a stored procedure that generates statistics on a table.  I've created the stored proc but get the following error when I run it - "GENERATE Thu, 25 Mar 2010 20:53:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1883 2010-03-25T20:53:07Z 5 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1916 Is there any system table in Netezza like ALL_TABLES in oracle which stores the total number of records in each table ? Kindly Assist. Thu, 15 Apr 2010 04:50:04 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1916 2010-04-15T04:50:04Z 3 months, 4 weeks ago 4 3 http://www.enzeecommunity.com/thread/1919 I have a 267 column table and has a datatype distribution as follows: [nz@hostname temp]$ cat loan_tab.txt | grep -i Varying | wc -l 118 [nz@hostname temp]$ cat loan_tab.txt | grep -i date | wc -l 45 [nz@hostname temp]$ cat loan_tab.txt | grep -i bigint Mon, 19 Apr 2010 20:06:58 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1919 2010-04-19T20:06:58Z 4 months, 3 weeks ago 8 7 http://www.enzeecommunity.com/thread/1669 Hi Folks,   Can any body help me out the reason of below error?   nzsql:MODFCTPRDHLD_2.SQL:1470: ERROR:  5134 : Not enough memory for n-squared jo in   Regards Hemant nzload netezza enzee_universe Fri, 23 Oct 2009 10:26:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1669 2009-10-23T10:26:57Z 10 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1929 Hi, I am using a 4.6.6 NPS box. When I created the external table with 'Ç' as delimiter, I am getting the error "ERROR:  Input is not UTF-8".   PFB the external table description   create external table ext_template_table sameas template_table Tue, 27 Apr 2010 04:47:43 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/1929 2010-04-27T04:47:43Z 4 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1716 We've encountered this error a few times while processing our loads in Netezza. We use 'select now()' to insert the current timestamp into a column in the Log table. Since we have concurrent jobs running, it may so happen that multiple commands are timestamp" error "bad Wed, 02 Dec 2009 11:44:11 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1716 2009-12-02T11:44:11Z 8 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1985 The below is my input.   Numeric128Val* inputvalue=numeric128Arg(0);   How do i perform addition and subtraction like this *input_value->value+=0.5; or *ret->value+=-0.5; external addition netezza rountine numeric128val Mon, 21 Jun 2010 14:00:05 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1985 2010-06-21T14:00:05Z 2 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1805 all   I am trying to enforce primary key and foriegn key relationship, I would want my sql should fail if there is no primary key , based on documentation I understand you can not enforce the priamy key check is that true?   this is what Iam primary key foriegn Mon, 01 Feb 2010 16:53:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1805 2010-02-01T16:53:37Z 7 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1615 I want to write a query to basically replicate the Active Queries information available through the Netezza Performance Server Administrator. What system table or view do I need to refer to retrieve this information via a query? active netezza queries Fri, 11 Sep 2009 15:46:58 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1615 2009-09-11T15:46:58Z 4 months, 4 days ago 9 8 http://www.enzeecommunity.com/thread/1937 Hello Friends, I was trying to reclaim space from a table that  occupies about 900 GB.  I got the below error Error: ***  (event895) 23: spu 10.0.5.6 disk error DISK_UNCORR_DATA_ERROR at 1724419  in  Mon, 03 May 2010 11:20:30 GMT ksampath@firstam.com http://www.enzeecommunity.com/thread/1937 2010-05-03T11:20:30Z 4 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1726 I am VERY new to nzsql and have a question.   nzsql -db dbname -host hostname -o file123 -c"sql"   I have one nzsql command that writes the return to a file say file123 just fine... I then have another nzsql command I want to append the new Fri, 11 Dec 2009 22:03:46 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1726 2009-12-11T22:03:46Z 8 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1939 hi, i am new to this  group. appreciate any help on this question. I am receiving "SPU Oversubscribed memory" while generating statistics on few tables. These tables are not that big (<1000000 rows). Wed, 05 May 2010 02:56:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1939 2010-05-05T02:56:25Z 4 months, 5 days ago 4 3 http://www.enzeecommunity.com/thread/1761 Hi   Can we create materialised view groups in Netezza the same way as in Oracle?   If yes,do we have any procedure(sthg like DBMS_REFRESH.REFRESH() in Oracle) to refresh such MV groups created in Netezza?   Thanks, Arun Thu, 07 Jan 2010 08:08:31 GMT arun.sreekanth@cognizant.com http://www.enzeecommunity.com/thread/1761 2010-01-07T08:08:31Z 8 months, 4 days ago 2 1 http://www.enzeecommunity.com/thread/1691 Is there a way to create a first row of column names in a remote odbc text table export ?   Thanks odbc netezza Thu, 12 Nov 2009 22:13:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1691 2009-11-12T22:13:50Z 10 months, 2 hours ago 2 1 http://www.enzeecommunity.com/thread/1968 Hi all,   I have in issue with a procedure returning reftable. Could anyone suggest how to return a resultset in sorted form?   I have even tried using following logic:   -inserted record in tem_table -inserted in reftable using order by Thu, 03 Jun 2010 17:53:38 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1968 2010-06-03T17:53:38Z 3 months, 6 days ago 3 2 http://www.enzeecommunity.com/thread/1792 Hi,   I'm trying to send an email using Netezza's sendMail option, upon success/failure inside a Korn shell script.   Here's how I'm using it - sendMail -dst ops@aaa.com -bodyText "Success"   where ops@aaa.com is the distribution list Thu, 21 Jan 2010 18:35:27 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1792 2010-01-21T18:35:27Z 7 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1625 Hi All,   Along with investigating ETL tools for the NPS we also have a requirement for a data mining tool that works with the NPS, specificallty around EPoS data. Having looked at SPSS & SAS, based on experiences, can anybody point me in any Tue, 22 Sep 2009 08:18:11 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1625 2009-09-22T08:18:11Z 11 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1720 Hi,   I can find two cloumns in _v_function system tables, but these columns(arguments, functionsignature ) only have the variable type eq:TESTXML_ABC(DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, Tue, 08 Dec 2009 02:04:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1720 2009-12-08T02:04:06Z 9 months, 4 days ago 4 3 http://www.enzeecommunity.com/thread/1981 Hi,   I am new to Netezza, and I have back-read here something about it having a threshold of  31 concurrent processes only at the same time..   So does this mean if a I have multiple input tables(having same table definition)...   Tue, 15 Jun 2010 07:59:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1981 2010-06-15T07:59:06Z 2 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1447 Visit www.dataliberators.com and check out the video today!! Wed, 18 Feb 2009 21:36:22 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1447 2009-02-18T21:36:22Z 1 year, 6 months ago 1 http://www.enzeecommunity.com/thread/1915 Is there a way to change the command line editing mode of nzsql to be vi style instead of emacs style?   thanks,   Rob nzsql Wed, 14 Apr 2010 20:06:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1915 2010-04-14T20:06:50Z 4 months, 14 hours ago 5 4 http://www.enzeecommunity.com/thread/1846 Hi,   We are trying to calculate count for different gouping (8 Levels of grouping) using a single qurey. The query works fine with 2-3 level of grouping but anything above 3 level Netezza throws up the below error.   Error: ERROR: 65534 : analytic functions Tue, 23 Feb 2010 08:48:27 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1846 2010-02-23T08:48:27Z 6 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1924 Is there a metadata property that flags views as "invalid" because of a change to an underlying table?  I would like to directly check for invalid views without actually executing the views.  If no flag, can I compare timestamps of the view and the Thu, 22 Apr 2010 22:26:37 GMT mark@edwblog.com http://www.enzeecommunity.com/thread/1924 2010-04-22T22:26:37Z 4 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1853 Hi ,   We have an implementation of a data warehouse. These are the high level details.   Dimensions   Product hierarchy   T1 (Highest level)   T2                          T3   PK1                      PK2 (=T1.FK1)        PK3 Thu, 25 Feb 2010 16:01:09 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/1853 2010-02-25T16:01:09Z 6 months, 1 week ago 10 9 http://www.enzeecommunity.com/thread/1953 We've got good news. Both of these conferences are taking place in Boston the week of June 21st. So, if you are looking to make a week out of it, come to Enzee Universe and then head to JBoss World. For ore details on Enzee Universe visit linux netezza enzee universe Wed, 19 May 2010 04:33:46 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1953 2010-05-19T04:33:46Z 3 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1852 Hi,   Input file:   aaa| |  | bbb|mm|| ccc|  |nnn   table col1 col2 col3   I used nzload to load the data into this table datas are getting loaded.   After loading i am able to see the data.   But when i try to execute .. Thu, 25 Feb 2010 09:04:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1852 2010-02-25T09:04:44Z 6 months, 1 week ago 7 6 http://www.enzeecommunity.com/thread/1923 Just wondering if anyone knows why some queries have an initial sql_text of #system-generated sample scan of "table name"    before the query starts running?  Is this just the optimizer at work or is it an indication that a particular table is having Thu, 22 Apr 2010 19:14:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1923 2010-04-22T19:14:12Z 4 months, 2 weeks ago 7 6 http://www.enzeecommunity.com/thread/1855 Hi, is it posible to do in netezza sometnig like than (sample from Oracle):   trec  t%ROWTYPE;     INSERT INTO t   VALUES trec;   I would'n like to name all columns in INSERT statement,   thanks in bye darko nzsql Tue, 02 Mar 2010 08:43:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1855 2010-03-02T08:43:53Z 6 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1749 All I am getting the following error when I try to run the below sql, what is the best way to rewirte     SELECT * FROM table1 A WHERE  (         (EXISTS                 (SELECT b.col1                 FROM table2 B                 WHERE Mon, 04 Jan 2010 17:39:27 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1749 2010-01-04T17:39:27Z 8 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1780 Are there any pseudo columns for a table in netezza? Fri, 15 Jan 2010 16:23:47 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1780 2010-01-15T16:23:47Z 7 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/2031 Hi folks I have a  set of tables with the same column name (say mod_ts). Some of them have a default value of "current_timestamp" (i.e. the table column mod_ts was created with clause "mod_ts timestamp not null default current_timestamp), and some do column-default-values Wed, 21 Jul 2010 14:30:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2031 2010-07-21T14:30:50Z 1 month, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1496 Hello experts,                            I'm a newbie to Netezza. But I'd like to know if there are any 32-bit ODBC drivers available to work/install on a 64-bit Suse Linux OS. Appreciate your inputs!   Regards, -N. driver 64-bit linux 32-bit odbc suse Tue, 05 May 2009 16:19:07 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1496 2009-05-05T16:19:07Z 1 year, 4 months ago 6 5 http://www.enzeecommunity.com/thread/1768 Hi,   I have a update statement in teradata happening on a set table, when i convert the same to netezza, how do i handle the set condition, without creating a staging table?   The update could also happen on any type of teradata tables, for set/multiset update teradata. in netezza equivalent Mon, 11 Jan 2010 06:59:49 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1768 2010-01-11T06:59:49Z 7 months, 4 weeks ago 10 9 http://www.enzeecommunity.com/thread/1521 Hi, i'm having problems by loading data with nzload utiliy. Our data have some ESC chars and i don't want do drop them, i would like to transfer data as it is. I have tried with ctrlChars and crInString switch. Example: <CR><LF>, crInString nzload Wed, 27 May 2009 07:41:17 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1521 2009-05-27T07:41:17Z 1 year, 3 months ago 2 1 http://www.enzeecommunity.com/thread/1841 I appologize in advance if this is the wrong part of the forum to post tuning questions on but I am brand spanking new to Netezza.  Let me know where to post it if so and thanks in advance.   I have a query that is taking 1400+ seconds to return in Fri, 19 Feb 2010 22:09:18 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1841 2010-02-19T22:09:18Z 6 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1962 Hi-   I have values with epoch values like 1274863165319, 1274862988124.   I need to get them converted into timestamp.   Please help me out on this.   Thanks Harish Thu, 27 May 2010 19:09:18 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1962 2010-05-27T19:09:18Z 3 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1523 Neteeza has a optimizer setting called factrel_size_threshold which sets a table size threshold, in rows, above which the table will be treated as a fact table.  I believe the default is 100 million rows.  As I understand it, tables above the factrel optimizer Thu, 28 May 2009 12:17:11 GMT mark@edwblog.com http://www.enzeecommunity.com/thread/1523 2009-05-28T12:17:11Z 1 year, 3 months ago 2 1 http://www.enzeecommunity.com/thread/1770 Hi All   Could someone tell me which are the system tables in Netezza.   To be specific,i want the NZ counterparts of all_tables,user_tables,dba_tables in Oracle.   Thanks, Arun Sreekanth Mon, 11 Jan 2010 08:37:04 GMT arun.sreekanth@cognizant.com http://www.enzeecommunity.com/thread/1770 2010-01-11T08:37:04Z 8 months, 13 hours ago 2 1 http://www.enzeecommunity.com/thread/1682 I've encountered the following error while executing SQL queries a couple of times.   ERROR:  23 : spu 10.0.15.4 disk error DISK_BLOCK_VERIFY_ERROR at 257208837   I'd appreciate if anyone could let me know what this error exactly signifies and disk_error Mon, 02 Nov 2009 09:16:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1682 2009-11-02T09:16:15Z 10 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1861 Hi All, I want to create a log file for a sql script which is running from a file. Please help me to do that. I tried with the below script. ---------------------------------------------------------------------------------------------------------- spool logfile Fri, 05 Mar 2010 10:01:43 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1861 2010-03-05T10:01:43Z 6 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1742 Hi All,   I am facing problem while loading insert,update and delete(hard delete) on same Netezza table in a single Informatica mapping . The mapping is working fine if there is only (inserts and one update combination)or (inserts and one delete Wed, 30 Dec 2009 03:53:01 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1742 2009-12-30T03:53:01Z 8 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1741 Hi All,   Can i write sql query in nzload command as we do in bcp command in sql server?   Thanks in Advance Varun Tripathi Mon, 28 Dec 2009 15:09:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1741 2009-12-28T15:09:15Z 8 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1925 Calling all Enzees! Universe is less than 60 days away, taking place June 21-23rd in Boston.Will you be there? Check out the exciting agenda including a full-day Best Practices session, expanded training options, numerous industry expert sessions, the enzee universe netezza boston birmingham Fri, 23 Apr 2010 03:42:03 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1925 2010-04-23T03:42:03Z 4 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1649 Hi,   In one of my queries i am concatenating a few varchar columns. I observed that when anyone of the columns has a 'null' value the query does not return the concatenated value for that record. Instead it displays null. While i resolved this by Mon, 12 Oct 2009 13:59:38 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1649 2009-10-12T13:59:38Z 11 months, 1 day ago 3 2 http://www.enzeecommunity.com/thread/1740 Hi All,   I am trying to load a table in Netezza using a flat file. The data in flat file is coming from SQL Server table which has two columns. But the target table has one more extra column current_time which has to be populated with the current Mon, 28 Dec 2009 14:50:58 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1740 2009-12-28T14:50:58Z 8 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1837 Hi,   I wanted to know that Why temp tables are better than explicit tables in netezza?       Regards, Anu Thu, 18 Feb 2010 10:23:38 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1837 2010-02-18T10:23:38Z 6 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1713 hi is there any utilities available in netezza like we used to have in teradata.   also please clarify the followig     1. is it true that netezza doesnt use - stored procedures, indexes, partitioning concept etc etc 2. how does the Sat, 28 Nov 2009 16:29:54 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1713 2009-11-28T16:29:54Z 9 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1801 Can anyone tell me how to convert whole table into UPPER CASE?  i had this requirement,  i know to do this every column wise in each table.  I have this requirement for many tables.    Thanks. Tue, 26 Jan 2010 23:03:08 GMT vamsisingh9@gmail.com http://www.enzeecommunity.com/thread/1801 2010-01-26T23:03:08Z 7 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1659 Hi,   Can any body tell me that how can I provide bad files and log files location details while creating external table?   My script is below:   CREATE EXTERNAL TABLE EXTPRD_HLDG_TRANS (SK_TRANSACTION_ID  INTEGER, SK_ECUST_ID        netezza nzload Tue, 20 Oct 2009 13:00:56 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1659 2009-10-20T13:00:56Z 10 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1800 Hi   how to solve below error,i am getting below error while i am loading the data     syntax: /vol/edws/Netezza/linux/4.5.4/bin/nzload -host nznwtest -u spl_poc_dev -pw Netezza1 -db specialty_poc -t PSUBINC -delim '|' -datestyle Y2MD Tue, 26 Jan 2010 19:52:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1800 2010-01-26T19:52:15Z 7 months, 2 weeks ago 8 7 http://www.enzeecommunity.com/thread/1580 could some 1 tell me the datatypes in Teradata and their corresponding Netezza datatypes.   Caro. twinfin Fri, 07 Aug 2009 03:30:17 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1580 2009-08-07T03:30:17Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1832 Hi All,   I have a procedure which is creating a view for a particular month. Now when next time , i ll run this procedure, i want that the view should be created for the new month data but the old data should also be intact and not loast. Can Tue, 16 Feb 2010 10:08:33 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1832 2010-02-16T10:08:33Z 6 months, 3 weeks ago 5 4 http://www.enzeecommunity.com/thread/1833 Hi,   How could we implement date function like NEXT_DAY(sysdate, 'monday') (as in Oracle) in Netezza?     Thanks, Vijayanand. Tue, 16 Feb 2010 10:37:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1833 2010-02-16T10:37:44Z 6 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1623 Hi   I have two sql statements in one .sql file   select count(*) form a;   select count(*) from b;   the first is a bad sql (from clause misspelled) but when I run through nzsql , its showing the error but not stopping there.. also Fri, 18 Sep 2009 19:08:48 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1623 2009-09-18T19:08:48Z 11 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1766 Hi folks I am being told that in Netezza updates are in general slower than deletes and that for big tables they are not scalable.   I know they are two different statements but in a solution where you have two alternatives - one involving Fri, 08 Jan 2010 22:22:23 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1766 2010-01-08T22:22:23Z 7 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1582 Has anyone created a median function yet for netezza?  I find it strange that they do not have one.  It gets pretty hairy when you are using this with multipass SQL.     Im looking for a .cpp to install.   Currently I use the following median krust functions Fri, 07 Aug 2009 22:23:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1582 2009-08-07T22:23:24Z 1 year, 1 month ago 3 2 http://www.enzeecommunity.com/thread/1767 If a table width is too long, does the performance of reading certain columns (10% of the columns) and certain rows will require Netezza to read all the columns? Does this result in degraded performance as the system need to read too many blocks? Does Mon, 11 Jan 2010 02:28:43 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1767 2010-01-11T02:28:43Z 8 months, 21 hours ago 5 4 http://www.enzeecommunity.com/thread/1476 Hi , I am new to Netezza .......I need some material to learn abt Netezza.   Thanks Ayaz456 Thu, 02 Apr 2009 18:22:09 GMT ayaz456@gmail.com http://www.enzeecommunity.com/thread/1476 2009-04-02T18:22:09Z 10 months, 3 weeks ago 6 5 http://www.enzeecommunity.com/thread/1875 Dear all,   Evaluating Netezza and it seems to be a great product. Are there any major weaknesses ?   I guess distributions can make life hard sometimes? Mixed workloads etc ?   All informations is appreciated.   /Best regards, Mats Fri, 19 Mar 2010 15:29:30 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1875 2010-03-19T15:29:30Z 5 months, 1 week ago 4 3 http://www.enzeecommunity.com/thread/1945 http://www.rexeranalytics.com/Data-Miner-Survey-2010-Intro2.html   Your responses are completely confidential; no information you provide on the  survey will be shared with anyone outside of Rexer Analytics.  All  reporting of the survey findings predictive analytics data mining rexer Fri, 07 May 2010 17:25:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1945 2010-05-07T17:25:06Z 4 months, 4 days ago 1 http://www.enzeecommunity.com/thread/1980 Hi Is there any way we can translate gopobjpriv, gopadmpriv column (_v_sys_group_priv), for eg list it gives value of 1, and when I add alter privilege gives me 129..   Any help would be appreciated. Fri, 11 Jun 2010 17:32:18 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1980 2010-06-11T17:32:18Z 2 months, 4 weeks ago 3 2 http://www.enzeecommunity.com/thread/1877 Hi-   Is anyone familiar with errors like   ERROR:  Missing fragments in '_t_actionfrag' for 26975312   The error cannot be consistently reproduced, but it occurs during the creation of a view in a script.   I've searched and asked fragments missing Sat, 20 Mar 2010 00:06:48 GMT scott.nicholson@opinmind.com http://www.enzeecommunity.com/thread/1877 2010-03-20T00:06:48Z 5 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1504 I have a requirement where I need to join a big table with another smaller table and get summaries (sums, counts etc.) but the join needs to be on various groups of columns which is specified at run time. I was hoping to use the analytics to set up the error:_477 join big_table analytics Fri, 15 May 2009 16:04:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1504 2009-05-15T16:04:59Z 1 year, 3 months ago 6 5 http://www.enzeecommunity.com/thread/1913 Hi,      I am trying to load a temporary table from our main table(which contains nearly 50 billion records) based on few filter conditions. Main table contains a DATE column and the data is stored in the descending order based on the Date. It is Wed, 14 Apr 2010 12:42:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1913 2010-04-14T12:42:57Z 4 months, 3 weeks ago 9 8 http://www.enzeecommunity.com/thread/1695 If I have 5 columns in a table and created a view that shows only 3 columns, How do I give SELECT access on the view (view only - not the underlying table) to a user? Fri, 13 Nov 2009 21:08:14 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1695 2009-11-13T21:08:14Z 9 months, 4 weeks ago 2 1 http://www.enzeecommunity.com/thread/1723 All:   Given the following scenario: Standard star schema Fact joined to dimensions via integer keys Six standard dimension table   A query is run where it asks the time dimension 'show me this weeks' data. This will imply that I'll have some Thu, 10 Dec 2009 10:56:55 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1723 2009-12-10T10:56:55Z 9 months, 2 days ago 4 3 http://www.enzeecommunity.com/thread/1564 http://www.dbms2.com/2009/07/30/netezza-enzee-univers/ monash universe netezza Fri, 31 Jul 2009 04:51:02 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1564 2009-07-31T04:51:02Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1954 How can i call a C function for e.g say rounding decimals in Netezza.As it is possible in Netezza with a external C routine but don't the way to proceed.Can anyone please help me out.....?? netezza Wed, 19 May 2010 07:46:42 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1954 2010-05-19T07:46:42Z 3 months, 3 weeks ago 7 6 http://www.enzeecommunity.com/thread/1748 Hi,   I am an Informatica developer trying to find the help manuals to learn about Netezza appliance. For the last 2 months I am using Netezza as a source to pull the data using ETL tool Informatica. Now I am so curious to know about this Netezza. Mon, 04 Jan 2010 11:36:00 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1748 2010-01-04T11:36:00Z 8 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1642 Thanks to all of the users who participated in the Enzee Universe World Tour 2009! We enjoyed sharing TwinFin with the world and hope you enjoyed meeting with your peers and learning about the latest from Netezza. Stay tuned for highlights for the event comments twinfin enzee universe 2009 Thu, 01 Oct 2009 19:12:17 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1642 2009-10-01T19:12:17Z 11 months, 1 week ago 1 http://www.enzeecommunity.com/thread/1844 Thanks in advance. I am trying to create a udf in Netezza but I couldn't find any example or introduction to SQL sytax. could some help me? netezza functions udf create Mon, 22 Feb 2010 21:09:08 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1844 2010-02-22T21:09:08Z 6 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1982 Hi All   We have multiple Informatica sessions (all in different workflows) which are updating a single Netezza table. These workflows are executed in parallel and are triggered off automatically based on the presence of a trigger file in the parallel_insert update insert Wed, 16 Jun 2010 15:39:03 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1982 2010-06-16T15:39:03Z 2 months, 3 weeks ago 5 4 http://www.enzeecommunity.com/thread/1983 We are looking at rearchitecturing a application that is currently using Oracle to Netezza platform. All the functional requirements and business rules are extensively handled using Stored process and cross database connectivity through db links. What Sat, 19 Jun 2010 18:02:34 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1983 2010-06-19T18:02:34Z 2 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1838 what is PqFlush() -- connection not found error and how to resolve this. im getting this error while executing stored procedure Thu, 18 Feb 2010 13:59:00 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1838 2010-02-18T13:59:00Z 6 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1932 Hello,   I have a large table where I would like to create M samples of N items with replacement to create M summary statistics, then summarize these M values into a single value.  The underlying tables are large, M is a hundred to a thousand and N procedures analytics functions Wed, 28 Apr 2010 15:36:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1932 2010-04-28T15:36:57Z 4 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1736 I keep getting an illegal size passed to alloc error.        SELECT t1.c1, Tue, 22 Dec 2009 19:14:49 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1736 2009-12-22T19:14:49Z 8 months, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1840 Hi All,   My requirement is that i have to pass 2,3,4,5 as input parameter to a procedure but as a varchar string. It is not able to parse the ',' in between.Can anyone please help me out.   Thanks in Advance Fri, 19 Feb 2010 06:29:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1840 2010-02-19T06:29:59Z 6 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1987 How to use "CURRENT ROW" in LEAD/LAG analytical function in Netezza. Tue, 22 Jun 2010 11:06:51 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1987 2010-06-22T11:06:51Z 2 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/2022 We implemented row secure tables on a sample database and everything looks good. Now, we are planning to implement on our real time fact tables, and we encountered an error in the first step, where the system is not let us to create Foreign Key security row Thu, 15 Jul 2010 16:33:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2022 2010-07-15T16:33:12Z 1 month, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1775 Hi   i am trying to load data using nzload i am getting below error   $ ls -1 $(pwd)/newpollist.txt /thidata/dwload/pictsftp/newpollist.txt $ cd /vol/edws/Netezza/linux/4.5.4/bin/ $ |' -t NEWPOLLIST -df Wed, 13 Jan 2010 19:23:48 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1775 2010-01-13T19:23:48Z 7 months, 3 weeks ago 7 6 http://www.enzeecommunity.com/thread/1928 Hi All,   I have recently upgraded my Netezza 4.0.8 box to 4.6 but there are some issues that I have hit in 4.6   I am using Informatica 8.1.1 as the ETL tool and ODBC version is 4.6   The issue is that the INFA sessions are failing with Fri, 23 Apr 2010 17:55:21 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/1928 2010-04-23T17:55:21Z 4 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1650 Hi,   Can any body help me out to get the reason of below error?   nzsql:TEST.sql:2868: ERROR: pg_atoi: error in "U": can't parse "U"   I have same source and target data type, Only difference between three, which are below:     enzee netezza Tue, 13 Oct 2009 07:19:32 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1650 2009-10-13T07:19:32Z 10 months, 4 weeks ago 14 13 http://www.enzeecommunity.com/thread/1802 Hi All,   I have such error message while working with simple query in Netezza.   Error: ERROR:  Memory exhausted in AllocSetAlloc() (State:HY000, Native Code: 2D) Is anyone faced this error ? Please if anyone can help in this. Thanks in twinfin netezza stored twin procedures queries active Thu, 28 Jan 2010 09:43:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1802 2010-01-28T09:43:15Z 7 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1938 I am new to the enzee community, therefore, I am hoping this is the correct forum to ask this question.  We are looking for a SHA-1 function in Netezza.  Does anyone know of or have a working function for SHA-1?  We are currently running TF 5.0.8. functions Tue, 04 May 2010 14:59:38 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1938 2010-05-04T14:59:38Z 4 months, 6 days ago 6 5 http://www.enzeecommunity.com/thread/1831 Hi All,   Can anyone please tell me that what is the way to drop an existing column from a table in Netezza?   Thanks in Advance Mon, 15 Feb 2010 12:36:58 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1831 2010-02-15T12:36:58Z 6 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/1727 Hi, I am evaluating netezza for a large defense system.   the system will hold around 1,000,000,000 records, and do inserts\updates at a rate of 1000 per second.   Is it possible to "trickle feed" those records into netezza ? can the Sun, 13 Dec 2009 14:04:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1727 2009-12-13T14:04:29Z 7 months, 3 weeks ago 4 3 http://www.enzeecommunity.com/thread/2044 We finished our proof of concept using a Twinfin. The results were amazing! We have an Oracle 10g RAC transaction system we just implemented into production at the end of 2009.  The system didn't have any reporting so we decided to build a reporting data Fri, 30 Jul 2010 14:59:32 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2044 2010-07-30T14:59:32Z 1 month, 5 days ago 2 1 http://www.enzeecommunity.com/thread/1573 will the new appliance be in every Enzee Universe location? enzee_universe twinfin Tue, 04 Aug 2009 14:03:50 GMT brian@enzeecommunity.com http://www.enzeecommunity.com/thread/1573 2009-08-04T14:03:50Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1791 Hi,   Am new to Netezza,  can anyone tell me the concept of skew in the Netezza Aritecture.  How does that effect the distribution key when creating a table.  I see in the NPS Administrator tool the skew values for different table, its high for Thu, 21 Jan 2010 18:32:03 GMT vamsisingh9@gmail.com http://www.enzeecommunity.com/thread/1791 2010-01-21T18:32:03Z 7 months, 5 days ago 6 5 http://www.enzeecommunity.com/thread/1572 We are very excited about the announcment of the Netezza TwinFin(tm) appliance, announced today http://www.netezza.com/releases/2009/release080409.htm . Please use this as a place to discuss and ask questions about the fourth generation appliance from netezza twinfin video discuss Tue, 04 Aug 2009 13:43:56 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1572 2009-08-04T13:43:56Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1752 Hi All   can you plz tell me how to load the data from xl sheet to netezza tables if i need to use nzload can you please give me the syntax   Thanks Tue, 05 Jan 2010 16:43:28 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1752 2010-01-05T16:43:28Z 8 months, 9 hours ago 7 6 http://www.enzeecommunity.com/thread/1577 Will TwinFin finally allow us to use that cool database monitoring application that was shown two years ago at the user conference? Wed, 05 Aug 2009 02:11:49 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1577 2009-08-05T02:11:49Z 3 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1756 Hi   i transferd the table data from toad to a txt file with delimiter (|) option,i am trying to load the data to netezza tables by using nzsql i am getting below error   nzload -host nzsam -u spsdev -pw netezza -db nightly -delim '|' -t Wed, 06 Jan 2010 04:15:05 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1756 2010-01-06T04:15:05Z 8 months, 5 days ago 9 8 http://www.enzeecommunity.com/thread/1575 Hey - the best practice forums at each of the World Tour conferences will be a great place to gain knowledge and share your own experiences.   I am tapped to be the moderator/emcee at each of the conferences in the US plus London, and I have to say Tue, 04 Aug 2009 14:56:40 GMT dbirmingham@virtualmach.com http://www.enzeecommunity.com/thread/1575 2009-08-04T14:56:40Z 1 year, 1 month ago 2 1 http://www.enzeecommunity.com/thread/1722 All:   Does the definition of a primary/foreign key in a 'CREATE TABLE' play any role in the optimizers decision?   CREATE TABLE... ... PRIMARY KEY ( column_name [, ... ] ) | FOREIGN KEY ( column_name [, ... ] ) ...   In other words, Thu, 10 Dec 2009 10:40:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1722 2009-12-10T10:40:50Z 7 months, 3 weeks ago 6 5 http://www.enzeecommunity.com/thread/1851 Just want to check if this possible   when I created a table using xyz_id (user) , table created and when I browse from winsql/ or any other GUI tool ,  the object name  shows ADMIN.tablename and the owner shows as xyz_id which is correct   Is Wed, 24 Feb 2010 21:55:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1851 2010-02-24T21:55:29Z 6 months, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1745 Hi All!   I'm interested in BAR for our new Netezza platform.  I've heard from "some" that we s/b backing up using a method that employs the host to pass data from the SPUs to the destination backup device. In the Netezza Underground book by David Mon, 04 Jan 2010 01:56:10 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1745 2010-01-04T01:56:10Z 8 months, 1 week ago 1 http://www.enzeecommunity.com/thread/1849 Mark C. Aukeman MicroStrategy, Event-based Integration, Data Warehouse End-to-End Control, ETL, BI, Data Quality Control 11.9999 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; Wed, 24 Feb 2010 00:01:30 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1849 2010-02-24T00:01:30Z 6 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/2025 Hi I am getting the below error while I loading the file in to a table of single column.   bad #: input row #(byte offset to last char examined) [field #, declaration] diagnostic, "text consumed"[last char examined] error nzload load Mon, 19 Jul 2010 13:00:53 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/2025 2010-07-19T13:00:53Z 1 month, 2 weeks ago 4 3 http://www.enzeecommunity.com/thread/1813 Hello,   we are having a requirement for logging the steps in stored procedure.   However, the problem is that if any step errors out, the entire procedure, including the logging (done by calling logging procedures in main procedure) gets Mon, 08 Feb 2010 09:37:18 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1813 2010-02-08T09:37:18Z 7 months, 2 days ago 3 2 http://www.enzeecommunity.com/thread/1952 How do I return a result from a call to a stored procedure from a stored procedure using dynamic sql to pass parameters?   FOR temp_rec IN EXECUTE dynamic_sql LOOP   --  I want to return the result from a call to a stored procedure   END LOOP; value netezza stored procedures dynamic_sql Tue, 18 May 2010 14:59:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1952 2010-05-18T14:59:50Z 3 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1951 Could one of you help me find out how to get the last assigned value for a sequence?   I know that the 'select next val' gives us the next value in the sequence and i understand that the next value is not predictable. But is there any sys table value sequence last Mon, 17 May 2010 18:27:02 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1951 2010-05-17T18:27:02Z 3 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1854 Hi All,   I have a very simple doubt.   Consider a STAR schema as below. D1,D2,D3 and D4 are dimension tables with Keys K1,K2,K3 and K4. FACT is the fact table with a surrogate key S1 and dimension keys(foriegn keys) K1,K2,K3 and K4. Also you Sun, 28 Feb 2010 12:12:20 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/1854 2010-02-28T12:12:20Z 6 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1858 I was trying to search on what the solutions available are for true business continuity (the 5 9's kind)..  I could find info on backups, but I was looking for some sort of synchronous replication between datacenters.  I saw some documents referencing Thu, 04 Mar 2010 21:03:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1858 2010-03-04T21:03:44Z 6 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1643 Take a look at the latest from Netezza's Tim Young and let us know your thoughts.... http://www.enzeecommunity.com/blogs/crossing . larry netezza oracle tim exadata young twinfin Thu, 01 Oct 2009 19:18:20 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1643 2009-10-01T19:18:20Z 11 months, 1 week ago 1 http://www.enzeecommunity.com/thread/1556 One of our previous clients had a similar business problem, the business wanted to change the SCD type 1 to SCD type 2. Well if you are trying to model the SCD in such a way that the business wants to see a comparative analysis of current items & type analytics 1 2 scd comparative Thu, 16 Jul 2009 01:17:55 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1556 2009-07-16T01:17:55Z 1 year, 1 month ago 5 4 http://www.enzeecommunity.com/thread/1494 Hi folks I am trying to set up netezza jdbc connection pool on tomcat using Apache dbcp. I am using driver nzjdbc3.jar. In the same tomcat, I also am connecting to a mysql database. I use two properties file for my connection pool.   I keep seeing tomcat connection pool netezza Fri, 01 May 2009 14:49:32 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1494 2009-05-01T14:49:32Z 1 year, 4 months ago 1 http://www.enzeecommunity.com/thread/1806 Hello Guys,   We have been using old version of Netezza and intrested to know about Twin Fin. Do any of you guys mind sharing the V5.0 manuals that came with the twinfin   Thanks, Deepak Wed, 03 Feb 2010 18:59:22 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1806 2010-02-03T18:59:22Z 7 months, 6 days ago 3 2 http://www.enzeecommunity.com/thread/1717 i want to know whether netezza had database products.. like Oracle RDBMS. i know that Netezza is a data warehouse Appliance..but i want to know whether there is a netezza RDBMS ..like we have oracle or MS sql server or DB2...If there is one..where can i Fri, 04 Dec 2009 09:24:55 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1717 2009-12-04T09:24:55Z 9 months, 4 days ago 3 2 http://www.enzeecommunity.com/thread/1804 Hi All,   Can anyone please tell me that what is the equivalent or RIGHT('ABCDEF',3) in Netezza??   Thanks in advance Mon, 01 Feb 2010 13:35:33 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1804 2010-02-01T13:35:33Z 7 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1677 Hi Folks,   I created below proc to check the date in a varchar field.   Create or replace procedure dbf_dt_valid (varchar(10)) returns DATE LANGUAGE NZPLSQL AS begin_proc declare v_ret_dt date; v_num int; v_dt alias for $1; BEGIN v_ret_dt := netezza Wed, 28 Oct 2009 06:41:26 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1677 2009-10-28T06:41:26Z 10 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1557 I was wondering & hesitant about whether this is the right platform to share my views on this topic but after a thought process I understood that we are trying to associate our selves with new tecnology then why not discuss about XBRL hence this best_practices next_generation_of_financial_reporting financial_reporting business_intelligence Sat, 18 Jul 2009 01:52:08 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1557 2009-07-18T01:52:08Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1712 hi is there any utilities available in netezza like we used to have in teradata.   also please clarify the followig     1. is it true that netezza doesnt use - stored procedures, indexes, partitioning concept etc etc 2. how does the Sat, 28 Nov 2009 16:27:42 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1712 2009-11-28T16:27:42Z 9 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1866 Hi All, I am unable to reclaim space on my NETEZZA server. This is the Scenario: I created a table: CREATE TABLE ABCD ( column1 smallint NULL ) distribute on random; --INserted Data to this table INSERT INTO ABCD select 1234 INSERT INTO ABCD select 1234 Thu, 11 Mar 2010 13:08:16 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1866 2010-03-11T13:08:16Z 5 months, 3 weeks ago 15 14 http://www.enzeecommunity.com/thread/1457 Check out http://www.dataliberators.com/ and find out about Bob Doyle, leader of the Data Liberation Movement! dlm data movement liberation Wed, 04 Mar 2009 03:41:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1457 2009-03-04T03:41:31Z 1 year, 6 months ago 1 http://www.enzeecommunity.com/thread/1685 I could not find much information about how backup and restore is performed for Netezza appliances on web. But looks like there is utility like nzbackup and nzrestore which are used for this purpose. Also I got to know that netezza appliances are tivoli nzbackup api Wed, 04 Nov 2009 23:45:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1685 2009-11-04T23:45:35Z 10 months, 1 week ago 1 http://www.enzeecommunity.com/thread/1966 Hi All ! Can I know the difference between GENERATE STATISTICS and GENERATE EXPERATE STATISTICS? I feel both are same. Both are obtaining information on database, tables and columns. It provide the info for the optimiser to generate the query plan. generate statistics express Thu, 03 Jun 2010 14:23:52 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1966 2010-06-03T14:23:52Z 3 months, 1 week ago 6 5 http://www.enzeecommunity.com/thread/1794 In TwinFin system, there are 2 on-board network ports 4 PCIe 1Gbits ports 2 PCIe 10Gbits ports   The default configuration is the create a virtual IP 192.168.99.100 for the host named ports 192.168.99.102 & 192.168.99.103 lacp fec trunking virtual ipconfig bonding drbd Fri, 22 Jan 2010 15:42:39 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1794 2010-01-22T15:42:39Z 7 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1821 Hi All,   execute immediatE 'SELECT DATE_PART('||'''YEAR'', '||v_Date||') INTO '||'v_Year';   In the above statement, i am trying to run the dynamic query passing v_Date as parameter and storing the resukt in variable v_Year. But i am getting Thu, 11 Feb 2010 15:19:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1821 2010-02-11T15:19:50Z 6 months, 4 weeks ago 2 1 http://www.enzeecommunity.com/thread/1697 We are in the process of creating a new DWH and right now Table structure and attributes change based on the recommendations from the Business analysts. I came accross a situation where in i have to change the datatype of a column   Is it possible alter table column datatype Tue, 17 Nov 2009 00:01:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1697 2009-11-17T00:01:44Z 6 months, 4 days ago 4 3 http://www.enzeecommunity.com/thread/1666 I am Sr.Developer/Architect having about 13 years experience in Oracle. I set-up 4 data warehouses. I want to learn the Netezza. I saw only one book in Amazon (Netezza Underground by David Birmingham) but software is an issue. Can someone email good Thu, 22 Oct 2009 20:21:57 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1666 2009-10-22T20:21:57Z 10 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1753 CREATE TABLE PSALVAGE (   CLAIM_NO               VARCHAR(11),   LINCVG                     INTEGER,   FEAT_NO                  BYTEINT,   OWN_RETD              VARCHAR(1),   DEPOSIT_DATE         DATE,   GROSS                      INTEGER(10,2),   Tue, 05 Jan 2010 18:26:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1753 2010-01-05T18:26:37Z 8 months, 6 days ago 3 2 http://www.enzeecommunity.com/thread/1632 Hi,   I am looking for a command in NZSQL that will give me the query execution time. Like 'Set timing on' found in Oracle. Would appreciate if anyone can guide me in this direction.   Thanks and with regards,   Samir Mon, 28 Sep 2009 14:24:35 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1632 2009-09-28T14:24:35Z 11 months, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/1818 Hi, I am new to Netezza and I want to enter a value in the table of netezza DB, but this value has characters as well as numbers. For ex:- the column name is Month_Desc and the value I want to enter is 'DEC 2007'.. For this which data type shall I Thu, 11 Feb 2010 11:10:32 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1818 2010-02-11T11:10:32Z 6 months, 4 weeks ago 3 2 http://www.enzeecommunity.com/thread/1881 Hi,        I am having difficulty getting FIRST_VALUE (TIMESTAMP DESC) /LAST_VALUE (TIMESTAMP ASC) to work. It brings back the first value of a partitioned column all right, but I want the other columns in the row as well.   For example..... functions Wed, 24 Mar 2010 15:42:22 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1881 2010-03-24T15:42:22Z 5 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1696 Hello everybody , I am ner to netezza .I want to know how to give user in put while execution a SQL script.   Actually i got a small casestudy like   1) Write a .SQL script in which ,take a input parameter (date) from USER Ex - 20091201 sql script Mon, 16 Nov 2009 09:14:21 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1696 2009-11-16T09:14:21Z 3 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1758 Hi All,   Can anyone please tell me that how i can specify or enforce the row delimiter in the create external table command?   Thanks in Advance Wed, 06 Jan 2010 10:23:21 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1758 2010-01-06T10:23:21Z 8 months, 5 days ago 3 2 http://www.enzeecommunity.com/thread/1574 I posted sentiments here:   http://www.netezzacommunity.com/blogs/grill/2009/08/04/the-other-mans-game     but the short version is - I want one! Or at least access to one     Does the Netezza training site have the new systems Tue, 04 Aug 2009 14:17:41 GMT dbirmingham@virtualmach.com http://www.enzeecommunity.com/thread/1574 2009-08-04T14:17:41Z 1 year, 1 month ago 1 http://www.enzeecommunity.com/thread/1746 Hi, I'm having an issue with trying to use external tables created with compress options. I was able to create and insert data into compressed external tables, but am getting the following error when trying to load data into new tables using these Mon, 04 Jan 2010 06:08:59 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1746 2010-01-04T06:08:59Z 8 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1847 hi all,   when I create a table as CTAS, the distribution column in the target table is the first column of the source table, even though the source table is distributed on random.     Could i change the distribution column while running column ctas distribution Tue, 23 Feb 2010 09:05:07 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1847 2010-02-23T09:05:07Z 6 months, 2 weeks ago 9 8 http://www.enzeecommunity.com/thread/1637 Hi,   Can someone guide me in calling sql files from a NZPLSQL procedure?   Thanks and regards,   Samir Wed, 30 Sep 2009 19:22:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1637 2009-09-30T19:22:24Z 11 months, 1 week ago 1 http://www.enzeecommunity.com/thread/1885 Hi All,   Why we cannot create a table by the name same as the name of database in Netezza?   Thanks and Regards, Varun Tripathi Mon, 29 Mar 2010 06:59:50 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1885 2010-03-29T06:59:50Z 5 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1676 Hi Folks,   I created below proc to check the date in a varchar field.   Create or replace procedure dbf_dt_valid (varchar(10)) returns DATE LANGUAGE NZPLSQL AS begin_proc declare v_ret_dt date; v_num int; v_dt alias for $1; BEGIN v_ret_dt := procedures netezza Wed, 28 Oct 2009 06:35:30 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1676 2009-10-28T06:35:30Z 10 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1469 enzee_universe world_tour t-shirt register enzee user Tue, 24 Mar 2009 21:25:54 GMT karina@netezza.com http://www.enzeecommunity.com/thread/1469 2009-03-24T21:25:54Z 1 year, 5 months ago 1 http://www.enzeecommunity.com/thread/1750 Hi All,   I am new to NZ and I am trying to migrate an Oracle PL/SQL code to NZ PL/SQL.   The O-PL/SQL however uses a gather stats function---sthg like   execute DBMS_STATS.GATHER_TABLE_STATS (ownname => 'CDW_ADS', tabname => Tue, 05 Jan 2010 04:12:31 GMT arun.sreekanth@cognizant.com http://www.enzeecommunity.com/thread/1750 2010-01-05T04:12:31Z 8 months, 11 hours ago 6 5 http://www.enzeecommunity.com/thread/1891 Every once in a while in my ETL system (that uses the nzjdbc3 driver), I get the error that states: "org.netezza.util.PSQLException: The backend has broken the connection. Possibly t he action you have attempted has caused it to close" My initial take Thu, 01 Apr 2010 20:05:20 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1891 2010-04-01T20:05:20Z 5 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1640 Hi,   I am looking for some help in passing parameters between procedures. Individually my procedures work just fine but i am unable to pass any parameters. Would appreciate if someone can guide me in this area.   Thanks and regards,   Thu, 01 Oct 2009 17:09:08 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1640 2009-10-01T17:09:08Z 11 months, 1 week ago 7 6 http://www.enzeecommunity.com/thread/1811 I have to load the data from Fixed width flatfile to Table using NZLOAD. Can any one can help me to get the syntax for nzload with fixed width. Fri, 05 Feb 2010 14:03:02 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1811 2010-02-05T14:03:02Z 7 months, 5 days ago 3 2 http://www.enzeecommunity.com/thread/1495 Curt Monash will be Netezza's featured keynote speaker at Enzee Universe Boston, DC, Chicago, San Francisco, and London . Better yet, he's opened a whole can of worms by asking readers of his DBMS2 blog to contribute to the content of his monash enzee_universe curt keynote dbms2 presentation Fri, 01 May 2009 17:30:24 GMT karina@netezza.com http://www.enzeecommunity.com/thread/1495 2009-05-01T17:30:24Z 1 year, 4 months ago 1 http://www.enzeecommunity.com/thread/1845 Hi All, I have a doubt. When a query is fired. Does the query snippet goes to all the SPUs or it goes to only the necessary SPUs. If it goes to only the necessary SPUs, how will the SMP know which all SPUs to hit spu smp Tue, 23 Feb 2010 04:15:17 GMT vijaytrix@gmail.com http://www.enzeecommunity.com/thread/1845 2010-02-23T04:15:17Z 6 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1887 Is there any qucik way to find out databases space on netezza, I am able to get by table using _v_table_storage_stat.   we have around 20 databases and I want to get how much space each one allocated and used.   Thanks Mon, 29 Mar 2010 15:41:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1887 2010-03-29T15:41:24Z 5 months, 3 days ago 7 6 http://www.enzeecommunity.com/thread/1963 Hi all,   is there any equivalent for CHAR2HEXINT in netezza (function to convert char to hexadecimal)   for example the below query in teradata gets the hexadecimal value of column1 and casts it as float.   char2hexint Tue, 01 Jun 2010 09:20:08 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1963 2010-06-01T09:20:08Z 3 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1961 Hi Team ! Can you please help me in resolving this below error? SPU swap partition: Disk temporary work space is full I am getting this error while I am running my queries. Please can you suggest me solutions to resolve this error? And also please partition spu error swap storage Thu, 27 May 2010 13:10:18 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1961 2010-05-27T13:10:18Z 3 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1774 Hi   i am trying to load netezza tables by taking the data from oracle spool file   but i am getting spaces in between records i have used set pagesize 0,but i am not seeing any record in target file if i use this option     spool Wed, 13 Jan 2010 17:49:41 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1774 2010-01-13T17:49:41Z 7 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1651 can anyone please tell the way to get the name of workstation from which a query is being run.... some thing like host_name() in sql server Thu, 15 Oct 2009 13:30:41 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1651 2009-10-15T13:30:41Z 10 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1799 What is the major difference between varchar and nvarchar datatypes in netezza?  Does it have the same meaning with the oracle aswell? Tue, 26 Jan 2010 17:28:08 GMT vamsisingh9@gmail.com http://www.enzeecommunity.com/thread/1799 2010-01-26T17:28:08Z 7 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1759 Has anyone come across a need to have MDIFF function in Netezza? This function calculates the Moving difference in any other database (like Teradata).   Thanks in advance. netezza mdiff Wed, 06 Jan 2010 11:35:03 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1759 2010-01-06T11:35:03Z 6 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1689 all   I am having issues on the following nzload   nzload -cf controlfilename -t tablename -df datafilename controlfile.cf { delim quotedvalue double crinstring ctrlchars ignorezero true } Error: parse error: unexpected keyword or token '{' is nzload Wed, 11 Nov 2009 22:20:09 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1689 2009-11-11T22:20:09Z 10 months, 10 hours ago 3 2 http://www.enzeecommunity.com/thread/1971 Hi all ! While I am reading a nz community question, a question struk my brain. The question is, how to create object by including the symbol '£' in the identifier? We dont have that symbol '£' in the keyboard. I have put this value '£' in the object '£' identifier symbol Sun, 06 Jun 2010 07:22:16 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1971 2010-06-06T07:22:16Z 3 months, 3 days ago 6 5 http://www.enzeecommunity.com/thread/1593 Hi all,   I'm starting a new Netezza job on Monday. I've no Netezza experience, but 7 years Teradata DBA experience (Certified Teradata Master).   There doesn't seem to be a great deal of reading material around on Netezza!   Anyone sql_performance alerting_tools Fri, 21 Aug 2009 10:24:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1593 2009-08-21T10:24:31Z 1 year, 2 weeks ago 2 1 http://www.enzeecommunity.com/thread/1873 I am new to Netezza DB. Now I am not able to query from a particular table say "load_tab". Actually the table was accessing by different session and its running for long time, and in my current session i am not able to query anything from this table. I Thu, 18 Mar 2010 13:01:22 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1873 2010-03-18T13:01:22Z 5 months, 3 weeks ago 5 4 http://www.enzeecommunity.com/thread/1591 If you have been reading about TwinFin and want to see it for yourself, come to Enzee Universe 2009 and see what all the excitement's about. For details on the agenda, the TwinFin sessions and more, visit www.enzeeuniverse.com today. twin twinfin conference fin netezza universe Mon, 17 Aug 2009 19:04:29 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1591 2009-08-17T19:04:29Z 1 year, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1935 Hi All,   I have doubt regarding the redistribution technique in Netezza.   Consider that both the tables involved in join are not distributed on the same join key. In such a scenario, a collocated join cannot be performed. How does the NPS Thu, 29 Apr 2010 10:43:47 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/1935 2010-04-29T10:43:47Z 4 months, 1 week ago 2 1 http://www.enzeecommunity.com/thread/1936 Hi all,   I have this command: set timezone="America/Chicago";   and then I do the select: select current_timestamp, 'GMT' ZoneType; and it sets the time zone successfully.  However, after I \q to quit then go back in I find it doesn't keep it Thu, 29 Apr 2010 14:04:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1936 2010-04-29T14:04:15Z 4 months, 12 hours ago 3 2 http://www.enzeecommunity.com/thread/1732 Calling all Enzees! Enzee Universe 2010 is coming to the Westin Waterfront Hotel, Boston from June 21-23, 2010. Early event details and registration are available at www.enzeeuniverse.com . There are several new agenda additions this year including a enzee universe netezza user registration analytics conference boston Thu, 17 Dec 2009 14:39:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1732 2009-12-17T14:39:31Z 8 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1699 Is there any way I can find in netezza when the user was last logged on ?   Thanks users Tue, 17 Nov 2009 19:01:47 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1699 2009-11-17T19:01:47Z 9 months, 3 weeks ago 1 http://www.enzeecommunity.com/thread/1754 HI   I am trying to create table synonym   CREATE PUBLIC SYNONYM PSUBINC FOR PSUBINC; Error: ^ found "PUBLIC" (at char 8) expecting `VIEW' (State:HY000, Native Code: 6C) CREATE SYNONYM PSUBINC FOR PSUBINC; error: CREATE SYNONYM: object Tue, 05 Jan 2010 18:45:00 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1754 2010-01-05T18:45:00Z 8 months, 5 days ago 2 1 http://www.enzeecommunity.com/thread/1784 Hi,   Which is the best way to export data from Netezza tables?. I tried external tables.But in that case I have to literally login to the database server to get the data file back.I can also use NZSQL but if I have too many records to export it is Tue, 19 Jan 2010 11:04:45 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1784 2010-01-19T11:04:45Z 7 months, 3 weeks ago 5 4 http://www.enzeecommunity.com/thread/1757 Hi All,   I am trying to migrate the data from Netezza table to SQL Server table. For data unloading in Netezza, i am using externat table command. After generating a file, when i am trying to run the "bcp" command in SQL Server, it is getting Wed, 06 Jan 2010 09:43:37 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1757 2010-01-06T09:43:37Z 8 months, 5 days ago 1 http://www.enzeecommunity.com/thread/1634 In TD mload I can specify the field lengths by using .FIELD  WatercraftDiscountSurcharge_Id *       CHAR(18);   do you have a similar in nzload, I read that nzload only takes delimited data file not a fixed length file.. Is this a true statement..? Tue, 29 Sep 2009 17:24:05 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1634 2009-09-29T17:24:05Z 11 months, 1 week ago 3 2 http://www.enzeecommunity.com/thread/1675 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in Mon, 26 Oct 2009 13:34:41 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1675 2009-10-26T13:34:41Z 10 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1815 Hi All, PFB a delete statement that deletes records from Table_1 which are present in Table_2 and Table_3. Is there any other better way to do the same on Netezza.Kindly advice.   DELETE FROM Table_1 t WHERE (event_id,sub_event_id) IN (SELECT Wed, 10 Feb 2010 06:36:03 GMT sebastiandenny_k@infosys.com http://www.enzeecommunity.com/thread/1815 2010-02-10T06:36:03Z 7 months, 18 hours ago 2 1 http://www.enzeecommunity.com/thread/1674 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in enzee_universe netezza_nzload Mon, 26 Oct 2009 13:28:55 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1674 2009-10-26T13:28:55Z 10 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1781 Hi All,   Can anyone please tell me what is the alternative for the "with" clause that we use in oracle, in Netezza??   Thanks in Advance Mon, 18 Jan 2010 07:26:25 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1781 2010-01-18T07:26:25Z 7 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1769 Hi All,   Can anyone please tell me that AND CAST(col1 AS VARCHAR(7)) || col2 IS NULL is the condition i am giving in my procedure. The error i am getting is   Error: ERROR: right-hand side of AND is type 'VARCHAR', not 'BOOL' (State:HY000, Mon, 11 Jan 2010 07:28:47 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1769 2010-01-11T07:28:47Z 8 months, 11 hours ago 3 2 http://www.enzeecommunity.com/thread/1839 Hi All,   I am very new to Netezza database. Can any one give the query how to display all schema tables which contains specific column.   Thanks in advance   Best regards Rp Fri, 19 Feb 2010 01:17:39 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1839 2010-02-19T01:17:39Z 6 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1644 Hi Folks,   Do we have any hint or something like so that I can improve my insert statement in Netezza?   Actually I am using temporary table before insert data into target table as Update is taking too much time. But creating a temp table is netezza nzload enzee inserts Mon, 05 Oct 2009 05:35:45 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1644 2009-10-05T05:35:45Z 11 months, 1 week ago 5 4 http://www.enzeecommunity.com/thread/1807 Hi All,   I want a equivalent neteeza update statement for the below mentioned Oracle update   UPDATE SHIPMENT   s1 SET ORIGIN_SIC_ID = (SELECT sic.sic_id sic_id   FROM sic_location sic WHERE s1.orig_trmnl_sic_cd = sic.sic_code and netezza Thu, 04 Feb 2010 10:56:15 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1807 2010-02-04T10:56:15Z 7 months, 6 days ago 4 3 http://www.enzeecommunity.com/thread/1862 Hi All,   Please help me out, i am gettinf this error while doing select on some projection of tables.   Error: ERROR:  69088 : Not enough stack space (State:HY000, Native Code: 2D)   Thanks in advance, Ravi stored twin active forum netezza procedures queries row sql twinfin view Sat, 06 Mar 2010 13:17:31 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1862 2010-03-06T13:17:31Z 6 months, 4 days ago 2 1 http://www.enzeecommunity.com/thread/1679 All   Is there a way we can write UDF's in Netezza.. I heard that there is a tool helps you to write a UDF..   Any help would be appreicated   Thanks udf Thu, 29 Oct 2009 15:24:12 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1679 2009-10-29T15:24:12Z 10 months, 2 weeks ago 5 4 http://www.enzeecommunity.com/thread/1864 Hi!  We're looking at using the encryption feature in the Extended SQL Toolkit to support our encryption requirements.  Sensitive data and such.  So it looks like it will work, and that's good.  Is this what people are using? But also, will this work generic_sql netezza sql Wed, 10 Mar 2010 17:34:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1864 2010-03-10T17:34:24Z 6 months, 1 day ago 4 3 http://www.enzeecommunity.com/thread/1863 Hi,   Getting the o/p for select current_timestamp - 90 as 2009-12-08 (date format)   Can you please help me out to get the o/p in timestamp format.?   Many thanks.. Mon, 08 Mar 2010 14:59:17 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1863 2010-03-08T14:59:17Z 6 months, 4 days ago 2 1 http://www.enzeecommunity.com/thread/1958 Does anyone know if there is a system table that registers the status of a reclaim state that can be read periodically. What I mean here is the equivalent of the content received from the nzstats -type reclaim.   One check is to script and scan the nzreclaim nzstats nzsql Fri, 21 May 2010 14:34:08 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1958 2010-05-21T14:34:08Z 3 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1739 Hi,   I am a new Netezza user and am trying to write a NZ procedure.   I'm getting various errors trying to pass a 'quoted' variable to the 'Create External Table..' statement. Thing is, since the external table name and Datafile name need to quotes Fri, 25 Dec 2009 17:31:06 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1739 2009-12-25T17:31:06Z 8 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1836 Hi, Can some one give me inputs on the different loops available in netezza (with examples). like for , while, if ........... I'm a new user......... Thanks in Advance... Wed, 17 Feb 2010 11:27:40 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1836 2010-02-17T11:27:40Z 6 months, 3 weeks ago 3 2 http://www.enzeecommunity.com/thread/1760 Hi   i tried spoll file option below spool example select POLNUM||'|'||POLREN||'|'||POLSEQ from NEWPOLLIST; spool off;   it is created a example.LST on desktop   i am loading it to netezza like below   nzload -host nznwtest -u Wed, 06 Jan 2010 16:39:41 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1760 2010-01-06T16:39:41Z 8 months, 5 days ago 2 1 http://www.enzeecommunity.com/thread/1686 i am getting different results for the keyword USER if i run it from a stored procedure as compared to if  run it as a statement outside stored procedure. can someone please provide insight. Fri, 06 Nov 2009 10:02:44 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1686 2009-11-06T10:02:44Z 10 months, 6 days ago 1 http://www.enzeecommunity.com/thread/1906 Is there a listing of monitor components that are deprecated or indeed no longer needed in Twin Fin from the Mustang 10XXX.  Primarily concerned with SPU's and their performance e.g, SPU regeneration and double duty issues in the past.  I suspect they Mon, 12 Apr 2010 17:57:45 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1906 2010-04-12T17:57:45Z 4 months, 4 weeks ago 1 http://www.enzeecommunity.com/thread/1790 Hi   i am using below syntax to load data:   /vol/edws/Netezza/linux/4.5.4/bin/nzload -host nznwtest -u spl_poc_dev -pw Netezza1 -db specialty_poc -t PLOSSES -delim '|' -datestyle DMY -maxErrors 100 -df /thidata/dwload/pictsftp/plosses.txt Thu, 21 Jan 2010 18:29:52 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1790 2010-01-21T18:29:52Z 7 months, 2 weeks ago 6 5 http://www.enzeecommunity.com/thread/1817 Hi All,   I have created a procedure in which i am creating an external table in step1 then using it in step 2 and dropping it in step 3.Due to some error, i am getting error that the external table cannot be dropped, premission denied. Can anyone Thu, 11 Feb 2010 10:47:24 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1817 2010-02-11T10:47:24Z 6 months, 4 weeks ago 2 1 http://www.enzeecommunity.com/thread/1879 Hello Friends,   We currently have an urgent opening with our Client in MD. Please go through the following description of the requirement and let me know if you have any suitable resume.   Title: Netezza Consultant Location: MD Duration: Tue, 23 Mar 2010 18:47:59 GMT raj@sageitinc.com http://www.enzeecommunity.com/thread/1879 2010-03-23T18:47:59Z 5 months, 2 weeks ago 1 http://www.enzeecommunity.com/thread/1914 I have table which has 13 Billion rows and the table is not partitioned. In order to partition the table i need seg regate the data into 10 or 11 batches is there any way I can easily find the range of data in netezza ? Wed, 14 Apr 2010 14:15:42 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1914 2010-04-14T14:15:42Z 4 months, 3 weeks ago 2 1 http://www.enzeecommunity.com/thread/1662 Can we have optional parameters to stored procedures in netezza? can we assign default values to parameter while creating a proc. optional stored value parameters to procedures default Thu, 22 Oct 2009 07:52:00 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1662 2009-10-22T07:52:00Z 10 months, 2 weeks ago 3 2 http://www.enzeecommunity.com/thread/1819 Hi guys,   I got this error while i was trying to update a view, could some one tell me how  do this?   ERROR:  Cannot update a view without an appropriate rule     I am able to update the table though, is it possible to update views update view twinfin Thu, 11 Feb 2010 11:37:31 GMT karthik_forums@yahoo.com http://www.enzeecommunity.com/thread/1819 2010-02-11T11:37:31Z 6 months, 4 weeks ago 2 1 http://www.enzeecommunity.com/thread/1944 Hi All   I am new to the Netezza TwinFin and am exploring the possibility of utilizing the nzload.Could someone help me guide through the details on it and how it differs from SQL Loaders. Also, are there any advantages of this over loading files nzload Thu, 06 May 2010 14:45:03 GMT Communityadmin@netezza.com http://www.enzeecommunity.com/thread/1944 2010-05-06T14:45:03Z 4 months, 11 hours ago 13 12