informix能不能像db2在终端直接select

Question

db2在安装的服务端可以通过db2 connect to dbname后用db2 “select.…“。informix能不能也一样做到？

Answer 1

informix执行dbaccess命令进入客户端

>dbaccess

create table test (name varchar(20),age integer);

insert into test(name , age ) values("aaa",10);
insert into test(name , age ) values("bbb",11);
insert into test(name , age ) values("ccc",12);

select * from test;

delete from test where age = 10;

update test set age=9 where age=11