cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
: "export entire data base, verbose"

empexpt -TESTMODE -v testout1 $MSTESTDB				
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'

**  Table: sys_attr_privs  **
    exporting lock levels...

**  Table: sys_attrs  **
    exporting lock levels...

**  Table: sys_dictionary  **
    exporting lock levels...

**  Table: sys_mod_file  **
    exporting lock levels...

**  Table: sys_modules  **
    exporting lock levels...

**  Table: sys_params  **
    exporting lock levels...

**  Table: sys_privs  **
    exporting lock levels...

**  Table: sys_rep_masters  **
    exporting lock levels...

**  Table: sys_rep_replicates  **
    exporting lock levels...

**  Table: sys_rep_tables  **
    exporting lock levels...

**  Table: sys_routines  **
    exporting lock levels...

**  Table: sys_tables  **
    exporting lock levels...

**  Table: sys_triggers  **
    exporting lock levels...

**  Table: mbuilder_application  **
    exporting the table definition...
    exporting data...
    exporting lock levels...

**  Table: mbuilder_compile  **
    exporting the table definition...
    exporting data...
    exporting lock levels...

**  Table: mbuilder_field  **
    exporting the table definition...
    exporting data...
    exporting lock levels...

**  Table: mbuilder_form  **
    exporting the table definition...
    exporting data...
    exporting lock levels...

**  Table: mbuilder_key  **
    exporting the table definition...
    exporting data...
    exporting lock levels...

**  Table: mbuilder_script  **
    exporting the table definition...
    exporting data...
    exporting lock levels...

**  Table: mbuilder_window  **
    exporting the table definition...
    exporting data...
    exporting indices...
    exporting lock levels...

**  Table: select table  **
    exporting the table definition...
    exporting data...
    exporting lock levels...
    exporting table comments...
    exporting range checks...

**  View: view  **
    exporting the view definition...
    exporting table comments...

*** export complete ***
<!HEADER!>

x
<262>
c
<1>

 <!ENDHEADER!>
<!MODHEAD!>
 <!ENDMODHEAD!>
<!TABHEAD!>
mbuilder_application
1
mbuilder_compile
1
mbuilder_field
4
mbuilder_form
1
mbuilder_key
0
mbuilder_script
0
mbuilder_window
2
select table
2
sys_attr_privs
0
sys_attrs
0
sys_dictionary
0
sys_mod_file
0
sys_modules
0
sys_params
0
sys_privs
0
sys_rep_masters
0
sys_rep_replicates
0
sys_rep_tables
0
sys_routines
0
sys_tables
0
sys_triggers
0
view
VIEW1
 <!ENDTABHEAD!>
<!TABLE!>
sys_attr_privs
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_attr_privs' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_attr_privs' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_attr_privs' is table
<!TABLE!>
sys_attrs
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_attrs' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_attrs' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_attrs' is table
<!TABLE!>
sys_dictionary
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_dictionary' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_dictionary' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_dictionary' is record
<!TABLE!>
sys_mod_file
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_mod_file' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_mod_file' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_mod_file' is record
<!TABLE!>
sys_modules
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_modules' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_modules' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_modules' is record
<!TABLE!>
sys_params
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_params' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_params' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_params' is record
<!TABLE!>
sys_privs
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_privs' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_privs' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_privs' is table
<!TABLE!>
sys_rep_masters
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_rep_masters' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_rep_masters' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_rep_masters' is record
<!TABLE!>
sys_rep_replicates
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_rep_replicates' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_rep_replicates' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_rep_replicates' is record
<!TABLE!>
sys_rep_tables
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_rep_tables' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_rep_tables' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_rep_tables' is record
<!TABLE!>
sys_routines
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_routines' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_routines' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_routines' is record
<!TABLE!>
sys_tables
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_tables' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_tables' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_tables' is record
<!TABLE!>
sys_triggers
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_triggers' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_triggers' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_triggers' is record
<!TABLE!>
mbuilder_application
<!CREATE!>
create table 'mbuilder_application' (attr 'name' character(32,1) Not Null,attr 'enter_script' text(20,71,124,1),attr 'exit_script' text(20,0,124,1),attr 'return_type' character(8,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_application' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_application' to user as 'CREATOR' with grant option;
<!DATA!>
1
4
name
enter_script
exit_script
return_type
mbuilder_field
call show_window ('sys_default_menu')
call show_window ('mbuilder_field')
call current_window ('mbuilder_field', 'name')
display from menu ()
open 'mbuilder_field' update
select from 'mbuilder_field' with display count
next_rec 'mbuilder_field'
display from display_record ()


<27>
<!LOCK!>
lock level on table 'mbuilder_application' is record
<!TABLE!>
mbuilder_compile
<!CREATE!>
create table 'mbuilder_compile' (attr 'name' character(32,1) Not Null,attr 'segment' integer Not Null,attr 'compile' bulk(20,469,508,1) Not Null)
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_compile' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_compile' to user as 'CREATOR' with grant option;
<!DATA!>
1
3
name
segment
compile
mbuilder_field
1
aabbccddeeff

<!LOCK!>
lock level on table 'mbuilder_compile' is record
<!TABLE!>
mbuilder_field
<!CREATE!>
create table 'mbuilder_field' (attr 'name' character(32,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'window_name' character(32,1) Not Null,attr 'enter_script' text(20,0,60,1),attr 'exit_script' text(20,70,60,1),attr 'mode' character(1,1) Not Null,attr 'data_type' character(8,1),attr 'next' character(32,1),attr 'previous' character(32,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_field' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_field' to user as 'CREATOR' with grant option;
<!DATA!>
4
9
name
application_name
window_name
enter_script
exit_script
mode
data_type
next
previous
name
mbuilder_field
mbuilder_field

check 'mbuilder_field'@'name' for 'mbuilder_field'.'name'
w
char


application_name
mbuilder_field
mbuilder_field

check 'mbuilder_field'
w
char


window_name
mbuilder_field
mbuilder_field

check 'mbuilder_field'
w
char


enter_script
mbuilder_field
mbuilder_field

check 'mbuilder_field'
w
char


<266>
<!LOCK!>
lock level on table 'mbuilder_field' is record
<!TABLE!>
mbuilder_form
<!CREATE!>
create table 'mbuilder_form' (attr 'name' character(32,1) Not Null,attr 'compile' bulk(20,471,508,1) Not Null)
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_form' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_form' to user as 'CREATOR' with grant option;
<!DATA!>
1
2
name
compile
mbuilder_field
00112233445566778899aabbccddeeff
<230>
<!LOCK!>
lock level on table 'mbuilder_form' is record
<!TABLE!>
mbuilder_key
<!CREATE!>
create table 'mbuilder_key' (attr 'name' character(12,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'window_name' character(32,1) Not Null,attr 'script' text(20,42,60,1),attr 'disable' character(1,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_key' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_key' to user as 'CREATOR' with grant option;
<!DATA!>
0
5
name
application_name
window_name
script
disable

<!LOCK!>
lock level on table 'mbuilder_key' is record
<!TABLE!>
mbuilder_script
<!CREATE!>
create table 'mbuilder_script' (attr 'name' character(32,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'script' text(20,47,60,1),attr 'return_type' character(8,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_script' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_script' to user as 'CREATOR' with grant option;
<!DATA!>
0
4
name
application_name
script
return_type

<!LOCK!>
lock level on table 'mbuilder_script' is record
<!TABLE!>
mbuilder_window
<!CREATE!>
create table 'mbuilder_window' (attr 'name' character(32,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'form_name' character(32,1) Not Null,attr 'form_instance' character(32,1),attr 'minrow' integer Not Null,attr 'mincol' integer Not Null,attr 'maxrow' integer Not Null,attr 'maxcol' integer Not Null,attr 'draw_box' character(1,1) Not Null)
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_window' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_window' to user as 'CREATOR' with grant option;
<!DATA!>
2
9
name
application_name
form_name
form_instance
minrow
mincol
maxrow
maxcol
draw_box
mbuilder_field
mbuilder_field
mbuilder_field

1
1
21
80
n
sys_default_menu
mbuilder_field
sys_default_menu

22
1
24
80
n
<32>
<!INDEX!>
create (1,0) index table 'mbuilder_window'('name','application_name','form_name')
<!INDEX!>
create (2,15) index 'app_index' table 'mbuilder_window'('application_name')
<!LOCK!>
lock level on table 'mbuilder_window' is record
<!TABLE!>
select table
<!CREATE!>
create table 'select table' (attr 'into' integer Not Null,attr 'attr' character(5,1),attr 'table' bulk(20,0,20,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'select table' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'select table' to user as 'CREATOR' with grant option;
<!DATA!>
2
3
into
attr
table
5
five
012304
5
five
9abcde
.<!LOCK!>
lock level on table 'select table' is table
<!TCMMT!>
create comment table 'select table' 'a test of complex names and bulk'
<!RANGE!>
create range 'select table'.'into' >= '1'
<!TABLE!>
view
<!VIEW!>
create view 'view' ( 'into', 'attr', 'table') as select attr 'into', attr 'attr', attr 'table' from 'select table'
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'view' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'view' to user as 'CREATOR' with grant option;
<!TCMMT!>
create comment table 'view' 'a view defined over select table'
 <!ENDFILE!>
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'

**  Table: sys_attr_privs  **
    å٥륨ݡ档...

**  Table: sys_attrs  **
    å٥륨ݡ档...

**  Table: sys_dictionary  **
    å٥륨ݡ档...

**  Table: sys_mod_file  **
    å٥륨ݡ档...

**  Table: sys_modules  **
    å٥륨ݡ档...

**  Table: sys_params  **
    å٥륨ݡ档...

**  Table: sys_privs  **
    å٥륨ݡ档...

**  Table: sys_rep_masters  **
    å٥륨ݡ档...

**  Table: sys_rep_replicates  **
    å٥륨ݡ档...

**  Table: sys_rep_tables  **
    å٥륨ݡ档...

**  Table: sys_routines  **
    å٥륨ݡ档...

**  Table: sys_tables  **
    å٥륨ݡ档...

**  Table: sys_triggers  **
    å٥륨ݡ档...

**  Table: mbuilder_application  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...

**  Table: mbuilder_compile  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...

**  Table: mbuilder_field  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...

**  Table: mbuilder_form  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...

**  Table: mbuilder_key  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...

**  Table: mbuilder_script  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...

**  Table: mbuilder_window  **
    ơ֥ݡ档...
    ǡݡ档...
    ǥåݡ档...
    å٥륨ݡ档...

**  Table: select table  **
    ơ֥ݡ档...
    ǡݡ档...
    å٥륨ݡ档...
    ơ֥륳ȥݡ档...
    󥸥åݡ档...

**  View: view  **
    ӥ塼ݡ档...
    ơ֥륳ȥݡ档...

*** ݡȽλ ***
<!HEADER!>

x
<262>
c
<1>

 <!ENDHEADER!>
<!MODHEAD!>
 <!ENDMODHEAD!>
<!TABHEAD!>
mbuilder_application
1
0000000000000004454
mbuilder_compile
1
0000000000000005313
mbuilder_field
4
0000000000000005835
mbuilder_form
1
0000000000000006936
mbuilder_key
0
0000000000000007421
mbuilder_script
0
0000000000000008000
mbuilder_window
2
0000000000000008546
select table
2
0000000000000009611
sys_attr_privs
0
0000000000000000892
sys_attrs
0
0000000000000001172
sys_dictionary
0
0000000000000001432
sys_mod_file
0
0000000000000001713
sys_modules
0
0000000000000001986
sys_params
0
0000000000000002255
sys_privs
0
0000000000000002520
sys_rep_masters
0
0000000000000002780
sys_rep_replicates
0
0000000000000003065
sys_rep_tables
0
0000000000000003362
sys_routines
0
0000000000000003643
sys_tables
0
0000000000000003916
sys_triggers
0
0000000000000004181
view
VIEW1
0000000000000010211
 <!ENDTABHEAD!>
<!TABLE!>
sys_attr_privs
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_attr_privs' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_attr_privs' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_attr_privs' is table
<!TABLE!>
sys_attrs
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_attrs' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_attrs' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_attrs' is table
<!TABLE!>
sys_dictionary
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_dictionary' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_dictionary' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_dictionary' is record
<!TABLE!>
sys_mod_file
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_mod_file' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_mod_file' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_mod_file' is record
<!TABLE!>
sys_modules
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_modules' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_modules' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_modules' is record
<!TABLE!>
sys_params
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_params' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_params' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_params' is record
<!TABLE!>
sys_privs
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_privs' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_privs' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_privs' is table
<!TABLE!>
sys_rep_masters
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_rep_masters' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_rep_masters' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_rep_masters' is record
<!TABLE!>
sys_rep_replicates
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_rep_replicates' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_rep_replicates' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_rep_replicates' is record
<!TABLE!>
sys_rep_tables
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_rep_tables' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_rep_tables' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_rep_tables' is record
<!TABLE!>
sys_routines
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_routines' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_routines' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_routines' is record
<!TABLE!>
sys_tables
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_tables' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_tables' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_tables' is record
<!TABLE!>
sys_triggers
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'sys_triggers' to 'DBA' as 'DBA';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'sys_triggers' to 'DBA' as 'DBA' with grant option;
<!LOCK!>
lock level on table 'sys_triggers' is record
<!TABLE!>
mbuilder_application
<!CREATE!>
create table 'mbuilder_application' (attr 'name' character(32,1) Not Null,attr 'enter_script' text(20,71,124,1),attr 'exit_script' text(20,0,124,1),attr 'return_type' character(8,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_application' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_application' to user as 'CREATOR' with grant option;
<!DATA!>
1
4
name
enter_script
exit_script
return_type
mbuilder_field
call show_window ('sys_default_menu')
call show_window ('mbuilder_field')
call current_window ('mbuilder_field', 'name')
display from menu ()
open 'mbuilder_field' update
select from 'mbuilder_field' with display count
next_rec 'mbuilder_field'
display from display_record ()


<27>
<!LOCK!>
lock level on table 'mbuilder_application' is record
<!TABLE!>
mbuilder_compile
<!CREATE!>
create table 'mbuilder_compile' (attr 'name' character(32,1) Not Null,attr 'segment' integer Not Null,attr 'compile' bulk(20,469,508,1) Not Null)
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_compile' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_compile' to user as 'CREATOR' with grant option;
<!DATA!>
1
3
name
segment
compile
mbuilder_field
1
aabbccddeeff

<!LOCK!>
lock level on table 'mbuilder_compile' is record
<!TABLE!>
mbuilder_field
<!CREATE!>
create table 'mbuilder_field' (attr 'name' character(32,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'window_name' character(32,1) Not Null,attr 'enter_script' text(20,0,60,1),attr 'exit_script' text(20,70,60,1),attr 'mode' character(1,1) Not Null,attr 'data_type' character(8,1),attr 'next' character(32,1),attr 'previous' character(32,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_field' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_field' to user as 'CREATOR' with grant option;
<!DATA!>
4
9
name
application_name
window_name
enter_script
exit_script
mode
data_type
next
previous
name
mbuilder_field
mbuilder_field

check 'mbuilder_field'@'name' for 'mbuilder_field'.'name'
w
char


application_name
mbuilder_field
mbuilder_field

check 'mbuilder_field'
w
char


window_name
mbuilder_field
mbuilder_field

check 'mbuilder_field'
w
char


enter_script
mbuilder_field
mbuilder_field

check 'mbuilder_field'
w
char


<266>
<!LOCK!>
lock level on table 'mbuilder_field' is record
<!TABLE!>
mbuilder_form
<!CREATE!>
create table 'mbuilder_form' (attr 'name' character(32,1) Not Null,attr 'compile' bulk(20,471,508,1) Not Null)
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_form' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_form' to user as 'CREATOR' with grant option;
<!DATA!>
1
2
name
compile
mbuilder_field
00112233445566778899aabbccddeeff
<230>
<!LOCK!>
lock level on table 'mbuilder_form' is record
<!TABLE!>
mbuilder_key
<!CREATE!>
create table 'mbuilder_key' (attr 'name' character(12,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'window_name' character(32,1) Not Null,attr 'script' text(20,42,60,1),attr 'disable' character(1,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_key' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_key' to user as 'CREATOR' with grant option;
<!DATA!>
0
5
name
application_name
window_name
script
disable

<!LOCK!>
lock level on table 'mbuilder_key' is record
<!TABLE!>
mbuilder_script
<!CREATE!>
create table 'mbuilder_script' (attr 'name' character(32,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'script' text(20,47,60,1),attr 'return_type' character(8,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_script' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_script' to user as 'CREATOR' with grant option;
<!DATA!>
0
4
name
application_name
script
return_type

<!LOCK!>
lock level on table 'mbuilder_script' is record
<!TABLE!>
mbuilder_window
<!CREATE!>
create table 'mbuilder_window' (attr 'name' character(32,1) Not Null,attr 'application_name' character(32,1) Not Null,attr 'form_name' character(32,1) Not Null,attr 'form_instance' character(32,1),attr 'minrow' integer Not Null,attr 'mincol' integer Not Null,attr 'maxrow' integer Not Null,attr 'maxcol' integer Not Null,attr 'draw_box' character(1,1) Not Null)
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'mbuilder_window' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'mbuilder_window' to user as 'CREATOR' with grant option;
<!DATA!>
2
9
name
application_name
form_name
form_instance
minrow
mincol
maxrow
maxcol
draw_box
mbuilder_field
mbuilder_field
mbuilder_field

1
1
21
80
n
sys_default_menu
mbuilder_field
sys_default_menu

22
1
24
80
n
<32>
<!INDEX!>
create (1,0) index table 'mbuilder_window'('name','application_name','form_name')
<!INDEX!>
create (2,15) index 'app_index' table 'mbuilder_window'('application_name')
<!LOCK!>
lock level on table 'mbuilder_window' is record
<!TABLE!>
select table
<!CREATE!>
create table 'select table' (attr 'into' integer Not Null,attr 'attr' character(5,1),attr 'table' bulk(20,0,20,1))
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'select table' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'select table' to user as 'CREATOR' with grant option;
<!DATA!>
2
3
into
attr
table
5
five
012304
5
five
9abcde
.<!LOCK!>
lock level on table 'select table' is table
<!TCMMT!>
create comment table 'select table' 'a test of complex names and bulk'
<!RANGE!>
create range 'select table'.'into' >= '1'
<!TABLE!>
view
<!VIEW!>
create view 'view' ( 'into', 'attr', 'table') as select attr 'into', attr 'attr', attr 'table' from 'select table'
<!PRIVILEGE!>
grant alter,drop,empty,index,sort on 'view' to 'CREATOR' as 'CREATOR';
<!PRIVILEGE!>
grant delete,insert,select,update,display on 'view' to user as 'CREATOR' with grant option;
<!TCMMT!>
create comment table 'view' 'a view defined over select table'
 <!ENDFILE!>
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test export utility, export entire data base.
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
