发布时间：2015-03-05 23:52:13

### to check all the existing event rules [nz@vmtest ~]$ nzevent show |more Name                        On  Event Type        .........【阅读全文】

发布时间：2015-03-05 18:51:41

drop table test_a;create table test_a(name1 char(1));create table test_m(name1 char(1));select * from test_a;insert into test_a values('a');insert into test_a values('b');insert into test_a values('c');insert into test_a values('d');#### netezza cursor declarecur RECORD beginFOR cu.........【阅读全文】

发布时间：2015-02-17 10:32:09

 The test  process as following :--create a test partition tablecreate table test_part3(id number,aaa varchar2(30),bbb varchar2(30),date1 date default sysdate,name1 varchar2(25),name2 varchar2(25),name3 varchar2(25),name4 varchar2(25),name.........【阅读全文】

发布时间：2015-02-11 16:50:23

netezza command manual: nz_genstats当表没有记录的时候,Statistics Status  也会显示Unavailable.[nz@hlixau1105 log]$ nz_genstats -full  db_name test_t1Database:  db_name# Tables: 1    #  Table Name         .........【阅读全文】

发布时间：2015-02-11 14:10:04

Netezza -- join columns of the 2 table should be same dataType , or there will be data distribution or broadcastcreate table test_a (id int) distribute on (id);create table test_b (id char(10)) distribute on (id);insert into test_a values (1001);insert into test_b values (.........【阅读全文】