- Startup

$ oninit
$ onstat -

- Shutdown

$ onmode -ky
$ onstat -

- unload(dbaccess)

unload to "license.csv" delimiter ","
select * from license

- load(dbaccess)

load from "license.csv" delimiter ","
insert into test

- dbschema(os)

dbschema -d < database-name > -t < table-name > -ss <script file-name>.sql
dbschema -d license -t license -ss license.sql

- show database information(dbaccess)

select * from sysdatabases; 

- show table information(dbaccess)

select * from dbname:systables;
select * from dbname:syscolumns;

select t.tabname, c.* from systables t, syscolumns c
where t.tabid=c.tabid and tabname='test'
order by colno;

- change lock mode(dbaccess)

ALTER TABLE tab_name LOCK MODE (ROW);
ALTER TABLE tab_name LOCK MODE (PAGE);