Withthe new release it is possible to perform the following sequence:
XSQLCMD>create table foo(name string primary key);
XSQLCMD>start transaction;
XSQLCMD>insert into foo values ('one');
XSQLCMD>select * from foo;
name
------------------------------------------------------------------------------
Selected records: 0
XSQLCMD>checkpoint transaction;
XSQLCMD>select * from foo;
name
------------------------------------------------------------------------------
one
Selected records: 1
XSQLCMD>commit transaction;