On 12/16/15 10:18 AM, Anjana Prakash wrote:
Hi,
Can derby system procedure SYSCS_FREEZE_DATABASE use before
SYSCS_EXPORT_TABLE and then SYSCS_UNFREEZE_DATABASE
After export table.
Will there be any impacts.
Appreciate help on same.
Thanks,
Anjana
The following script runs fine for me. Have you encountered a problem
with this approach?
connect 'jdbc:derby:memory:db;create=true';
create table t1( a int primary key );
insert into t1 values ( 1 );
call syscs_util.syscs_freeze_database();
-- succeeds
call syscs_util.syscs_export_table ( 'APP', 'T1', 't1.dat', null, null,
null );
-- this would hang if we attempted it
-- insert into t1 values ( 2 );
call syscs_util.syscs_unfreeze_database();
-- succeeds now
insert into t1 values ( 2 );
Hope this helps,
-Rick
