* *** FEFRH1016-1 !
file CONNECT ( KERN TEST !
CREATE TABLE TAB1 ( a001     char (5) key, 
                    a002     char (5) key, 
                    a003     char (5) key, 
                    a004     varchar (5) default '12345', 
                    a005     varchar (5) default '12345', 
                    a006     varchar (5) default '12345', 
                    a007     varchar (5) default '12345', 
                    a008     varchar (5) default '12345', 
                    a009     varchar (5) default '12345', 
                    a010     varchar (5) default '12345', 
                    a011     varchar (5) default '12345', 
                    a012     varchar (5) default '12345', 
                    a013     varchar (5) default '12345', 
                    a014     varchar (5) default '12345', 
                    a015     varchar (5) default '12345', 
                    a016     varchar (5) default '12345', 
                    a017     varchar (5) default '12345', 
                    a018     varchar (5) default '12345', 
                    a019     varchar (5) default '12345', 
                    a020     varchar (5) default '12345', 
                    a021     varchar (5) default '12345', 
                    a022     varchar (5) default '12345', 
                    a023     varchar (5) default '12345', 
                    a024     varchar (5) default '12345', 
                    a025     varchar (5) default '12345', 
                    a026     varchar (5) default '12345', 
                    a027     varchar (5) default '12345', 
                    a028     varchar (5) default '12345', 
                    a029     varchar (5) default '12345', 
                    a030     varchar (5) default '12345', 
                    a031     varchar (5) default '12345', 
                    a032     varchar (5) default '12345', 
                    a033     varchar (5) default '12345', 
                    a034     varchar (5) default '12345', 
                    a035     varchar (5) default '12345', 
                    a036     varchar (5) default '12345', 
                    a037     varchar (5) default '12345', 
                    a038     varchar (5) default '12345', 
                    a039     varchar (5) default '12345', 
                    a040     varchar (5) default '12345', 
                    a041     varchar (5) default '12345', 
                    a042     varchar (5) default '12345', 
                    a043     varchar (5) default '12345', 
                    a044     varchar (5) default '12345', 
                    a045     varchar (5) default '12345', 
                    a046     varchar (5) default '12345', 
                    a047     varchar (5) default '12345', 
                    a048     varchar (5) default '12345', 
                    a049     varchar (5) default '12345', 
                    a050     varchar (5) default '12345' ) !
insert tab1 set a001 = 'abcde',
                a002 = 'abcde',
                a003 = 'abcde' !
create index "tab1.a031"
	on tab1( a031 ) !
 ***********************************************************!
CREATE TABLE TAB2 ( b001     char (5) key, 
                    b002     varchar (5) default '12345', 
                    b003     varchar (5) default '12345', 
                    b004     varchar (5) default '12345', 
                    b005     varchar (5) default '12345', 
                    b006     varchar (5) default '12345', 
                    b007     varchar (5) default '12345', 
                    b008     varchar (5) default '12345', 
                    b009     varchar (5) default '12345', 
                    b010     varchar (5) default '12345', 
                    b011     varchar (5) default '12345', 
                    b012     varchar (5) default '12345', 
                    b013     varchar (5) default '12345', 
                    b014     varchar (5) default '12345', 
                    b015     varchar (5) default '12345', 
                    b016     varchar (5) default '12345', 
                    b017     varchar (5) default '12345', 
                    b018     varchar (5) default '12345', 
                    b019     varchar (5) default '12345', 
                    b020     varchar (5) default '12345', 
                    b021     varchar (5) default '12345', 
                    b022     varchar (5) default '12345', 
                    b023     varchar (5) default '12345', 
                    b024     varchar (5) default '12345', 
                    b025     varchar (5) default '12345', 
                    b026     varchar (5) default '12345', 
                    b027     varchar (5) default '12345', 
                    b028     varchar (5) default '12345', 
                    b029     varchar (5) default '12345', 
                    b030     varchar (5) default '12345', 
                    b031     varchar (5) default '12345', 
                    b032     varchar (5) default '12345', 
                    b033     varchar (5) default '12345', 
                    b034     varchar (5) default '12345', 
                    b035     varchar (5) default '12345', 
                    b036     varchar (5) default '12345', 
                    b037     varchar (5) default '12345', 
                    b038     varchar (5) default '12345', 
                    b039     varchar (5) default '12345', 
                    b040     varchar (5) default '12345', 
                    b041     varchar (5) default '12345', 
                    b042     varchar (5) default '12345', 
                    b043     varchar (5) default '12345', 
                    b044     varchar (5) default '12345', 
                    b045     varchar (5) default '12345', 
                    b046     varchar (5) default '12345', 
                    b047     varchar (5) default '12345', 
                    b048     varchar (5) default '12345', 
                    b049     varchar (5) default '12345', 
                    b050     varchar (5) default '12345' ) !
insert tab2 set b001 = 'abcde',
                b002 = 'abcde',
                b003 = 'abcde' !
 ***********************************************************!
CREATE TABLE TAB3 ( c001     char (5) key, 
                    c002     varchar (5) default '12345', 
                    c003     varchar (5) default '12345', 
                    c004     varchar (5) default '12345', 
                    c005     varchar (5) default '12345', 
                    c006     varchar (5) default '12345', 
                    c007     varchar (5) default '12345', 
                    c008     varchar (5) default '12345', 
                    c009     varchar (5) default '12345', 
                    c010     varchar (5) default '12345', 
                    c011     varchar (5) default '12345', 
                    c012     varchar (5) default '12345', 
                    c013     varchar (5) default '12345', 
                    c014     varchar (5) default '12345', 
                    c015     varchar (5) default '12345', 
                    c016     varchar (5) default '12345', 
                    c017     varchar (5) default '12345', 
                    c018     varchar (5) default '12345', 
                    c019     varchar (5) default '12345', 
                    c020     varchar (5) default '12345', 
                    c021     varchar (5) default '12345', 
                    c022     varchar (5) default '12345', 
                    c023     varchar (5) default '12345', 
                    c024     varchar (5) default '12345', 
                    c025     varchar (5) default '12345', 
                    c026     varchar (5) default '12345', 
                    c027     varchar (5) default '12345', 
                    c028     varchar (5) default '12345', 
                    c029     varchar (5) default '12345', 
                    c030     varchar (5) default '12345', 
                    c031     varchar (5) default '12345', 
                    c032     varchar (5) default '12345', 
                    c033     varchar (5) default '12345', 
                    c034     varchar (5) default '12345', 
                    c035     varchar (5) default '12345', 
                    c036     varchar (5) default '12345', 
                    c037     varchar (5) default '12345', 
                    c038     varchar (5) default '12345', 
                    c039     varchar (5) default '12345', 
                    c040     varchar (5) default '12345', 
                    c041     varchar (5) default '12345', 
                    c042     varchar (5) default '12345', 
                    c043     varchar (5) default '12345', 
                    c044     varchar (5) default '12345', 
                    c045     varchar (5) default '12345', 
                    c046     varchar (5) default '12345', 
                    c047     varchar (5) default '12345', 
                    c048     varchar (5) default '12345', 
                    c049     varchar (5) default '12345', 
                    c050     varchar (5) default '12345' ) !
insert tab3 set c001 = 'abcde',
                c002 = 'abcde',
                c003 = 'abcde' !
 ***********************************************************!
 ***********************************************************!
create view vj as SELECT * 
FROM TAB1, TAB2, TAB3 where 
a001 = b001 and a002 = c002 and a003 = c003 and 
a004 = b004 and a005 = c005 and a006 = c006 and 
a007 = b007 and a008 = c008 and a009 = c009 and 
a010 = b010 and a011 = c012 and a013 = c013 !
commit !
parsing !
select * from vj where
a021 = b021 and a022 = c022 and a023 = c023 and 
a024 = b024 and a025 = c025 and a026 = c026 and 
a027 = b027 and a028 = c028 and a029 = c029 and 
a030 = b030 and a031 = :a and a001 = :b !
executing !
data !
select !
1
c 5 '12345'
c 5 'abcde'

pars_then_ex!
nodata !
FETCH !
pars_execute !
commit work release !
