Sun's RI J2EE server and Cloudscape database

set CLASSPATH=%CLASSPATH%;d:\j2sdkee1.2.1\lib\cloudscape\tools.jar;d:\j2sdkee1.2.1\lib\cloudscape\cloudscape.jar;d:\j2sdkee1.2.1\lib\cloudscape\RmiJdbc.jar

java COM.cloudscape.tools.ij

ij> connect 'jdbc:cloudscape:rmi:CloudscapeDB';

ij> create table Demo (name varchar(20), age int, weight int);
ij> insert into Demo values('tom', 30, 180);
ij> insert into Demo values('dick', 20, 120);
ij> insert into Demo values('harry', 40, 200);
ij> insert into Demo values('bubba', 10, 150);
ij> select * from Demo'
ij> select * from Demo order by age;
ij> select name,weight from Demo where weight > 140 order by weight;
ij> select min(age) from Demo;
ij> select avg(age) from Demo;
ij> update Demo set age = age + 1;
ij> drop table Demo;

ij> exit;