st_1.out

derby database source code.good for you.

ij> -- simple SYSCS procedures test - just test if we can call them
-- other tests will check that they work, this is just a quick test
-- that they can be called.  For the purpose of this test "works", 
-- means function called with no errors.  Other tests will check if
-- function did the right thing.
autocommit off;
ij> maximumdisplaywidth 9000;
ij> create table foo(a int);
0 rows inserted/updated/deleted
ij> -- check if unqualified schema call works.
set schema SYSCS_UTIL;
0 rows inserted/updated/deleted
ij> call SYSCS_FREEZE_DATABASE();
0 rows inserted/updated/deleted
ij> call SYSCS_UNFREEZE_DATABASE();
0 rows inserted/updated/deleted
ij> call SYSCS_CHECKPOINT_DATABASE();
0 rows inserted/updated/deleted
ij> call SYSCS_SET_DATABASE_PROPERTY('foo', 'bar');
0 rows inserted/updated/deleted
ij> call SYSCS_BACKUP_DATABASE('extinout/mybackup');
0 rows inserted/updated/deleted
ij> call SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE('extinout/mybackup2', 0);
0 rows inserted/updated/deleted
ij> call SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE('extinout/mybackup2', 1);
0 rows inserted/updated/deleted
ij> call SYSCS_DISABLE_LOG_ARCHIVE_MODE(0);
0 rows inserted/updated/deleted
ij> call SYSCS_DISABLE_LOG_ARCHIVE_MODE(1);
0 rows inserted/updated/deleted
ij> call SYSCS_COMPRESS_TABLE('APP', 'FOO', 0);
0 rows inserted/updated/deleted
ij> call SYSCS_COMPRESS_TABLE('APP', 'FOO', 1);
0 rows inserted/updated/deleted
ij> -- system funtions
set schema SYSCS_UTIL;
0 rows inserted/updated/deleted
ij> values SYSCS_GET_DATABASE_PROPERTY('foo');
1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
bar                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
ij> values SYSCS_CHECK_TABLE('APP', 'FOO');
1          
-----------
1          
ij> call SYSCS_SET_RUNTIMESTATISTICS(1);
0 rows inserted/updated/deleted
ij> call SYSCS_SET_STATISTICS_TIMING(1);
0 rows inserted/updated/deleted
ij> select * from APP.foo;
A          
-----------
ij> -- TODO, figure out how to test with a master file, that timings are non-zero,
-- without having them diff everytime.  Ran this once and hand checked that
-- it was working.
-- values SYSCS_GET_RUNTIMESTATISTICS();
call SYSCS_SET_STATISTICS_TIMING(0);
0 rows inserted/updated/deleted
ij> select * from APP.foo;
A          
-----------
ij> values SYSCS_GET_RUNTIMESTATISTICS();
1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Statement Name: 
	null
Statement Text: 
	select * from APP.foo
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text: 
Table Scan ResultSet for FOO at read committed isolation level using instantaneous share row locking chosen by the optimizer
Number of opens = 1
Rows seen = 0
Rows filtered = 0
Fetch Size = 16
	constructor time (milliseconds) = 0
	open time (milliseconds) = 0