发布时间：2015-06-30 11:33:32
create table with1 ( id int, name char(10));
create table with2 ( id int, name char(10));
create table with3 ( id int, name char(10));
create table with4 ( id int, name char(10));
insert into with1 values ( 1, 'a') ;
insert into with2 values ( 1, 'a') ;.........【阅读全文】
发布时间：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-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 (.........【阅读全文】
