Sybase Iq数据库的建表、导数据脚本片断

前段时间Sybase公司的人来公司测试Sybase和本公司BI报表工具的应用合作，下面是一部分SybaseIq的建表、导数据脚本51Testing软件测试网s0C y:~ko3u

51Testing软件测试网%T&i\+lmzhB&M
select * into JF1 from JF1_P where 1=2;
J_?zVwq0;

el$l`W.x7XO2g0 51Testing软件测试网"i2]P l;f.Wi

jB(O X)moF0insert into JF151Testing软件测试网,b-OW&p)F,L8k4G
location 'test.test'51Testing软件测试网!@RoL~0q
{select * from JF1_P};51Testing软件测试网jfuw^5lr1I

;51Testing软件测试网5i5}|6o&N0A
commit;51Testing软件测试网;\]/LMY'~!h$Y2Z9_*h

S2BO~o1d0;51Testing软件测试网jC)g+O'b}
set option public.ASE_BINARY_DISPLAY='Off';51Testing软件测试网F}CKb&g
set option public.append_load = 'off'; -- IQ 12.4.2 and later51Testing软件测试网zAS&xe?g6b.|Q
set option public.NOTIFY_MODULUS=1000000;51Testing软件测试网x9E3kB f0s
set option public.load_memory_mb=50;
5j8VV ^(ip,CD0set option public.parallel_gbh_enabled='on';  ---允许Group 并行使用多CPU
(cY sb6JC!o [0set option public.Parallel_GBH_Units=20;51Testing软件测试网&Y N!xsqd0Q5]
set option Public.query_temp_space_limit=0;
.a%?Y!e\j;v ?H0set option public.minimize_storage='ON';51Testing软件测试网5fd} q b!L4I*W1z
set option Public.Disk_Striping = 'ON';51Testing软件测试网.{)YEHw
set option Public.Disk_Striping_Packed = 'ON' ;
9m@2s&lIICE2D0----set option public.IQMSG_LENGTH_MB=1000;
I"x}j'Cc(b H+t0set option Public.Query_Plan ='OFF' ;
:g7c?.]k9v A/t;Z#[.E0set option Public.Force_No_Scroll_Cursors ='ON' ;
p,i&a_et!H0set option public.HASH_THRASHING_PERCENT=50;51Testing软件测试网~2XT2Mr:m8V`0}
set option public.max_hash_rows = 50000000;51Testing软件测试网~E6K&C\-dg
;51Testing软件测试网1kA*K9jr]!pk
select * into JF from JF151Testing软件测试网3I+M^0A4c$Vy
;51Testing软件测试网}5}4}6i4@H/W
commit;
a|QD+o&w%p0;
/?6ENv.B\ vv0o0drop table JF1;51Testing软件测试网0v|eZ0OX IDu'v'q
alter table  JF  rename to JF1; 
;sEYiO&e/W#a0;
;^y.KWfBy q`5V1x-Q0 51Testing软件测试网+B
y Z9z8xRYd
alter table  JF  rename  JF1; 
,@0at%nCEw2c[0;51Testing软件测试网2N0]"qTd#w W~ Sp
select *  from  JF1; 51Testing软件测试网X2h J)F0mz
;51Testing软件测试网"sLS]7}t-JL W
select * into WAJ04 from WAJ04_P where 1=2;;51Testing软件测试网$x*u$|%Cb$C*J#M
select *  from WAJ04 ;
1fuQ9ku9o4z0truncate table WAJ04;
1tnc1?3Cz0insert into WAJ0451Testing软件测试网_[0k*TT)a(~)SR
location 'test.test'
bf7o.jj4L
iK0{select * from WAJ04_P};

.`2}1CS2J'[ ^UY0select *  from WAJ04 ;51Testing软件测试网|4f.f0ObP9|p-U8m
select *  from JF1;;
?q1N#t$BwYg0insert into JF1
)^X(@/qf Q|4r!Z0location 'test.test'51Testing软件测试网2k5O+P*y!J+?Vy
{select * from JF1_P};
Bs?.}&Y9dOG0commit;51Testing软件测试网E2P!YbYA\!t

51Testing软件测试网5h CO,Dl0P'iP
select * into JF2 from JF2_P where 1=2;
Ll6F*O4Y/C'`$Qae0insert into JF251Testing软件测试网~+M!KxfYPP
location 'test.test'51Testing软件测试网b/La a9k5\
{select * from JF2_P};
X:L!N^b#K3Y"b0commit;51Testing软件测试网X;op(Q'yO!e7|J

ni QYJ5Z(d9@
g0select * into JF3 from JF3_F where 1=2;
)o?$C%Y/pP)vP0insert into JF3
%DauA3|9K#D&?0location 'test.test'
.RQx
V${l}U;G-T0{select * from JF3_F};51Testing软件测试网Q%~`CMvmW/p
commit;;
.@5[?'e#x4Vc9c0select count(*)  from JF3;
'O$`$Y[G0select count(*)  from JF2;
sI$Bc(y8y"pv0insert into JF3
&J{A7HU3d0location 'test.test'51Testing软件测试网 V2]Abh @G5vf,J
{select * from JF3_F};51Testing软件测试网 |7?}[l)K7kuv
commit;