RE: imbedded sql sytax question

Alan,
You mean like this?

CREATE TABLE QTEMP/FILE01 (MYCHAR CHAR (10 ) NOT NULL WITH DEFAULT,

  MYNBR DEC (5 , 2) NOT NULL WITH DEFAULT) 
  Table FILE01 created in QTEMP. 

CREATE TABLE QTEMP/FILE02 (MYCHAR CHAR ( 10) NOT NULL WITH DEFAULT,

  MYNBR DEC ( 5, 2) NOT NULL WITH DEFAULT) 
  Table FILE02 created in QTEMP. 

INSERT INTO QTEMP/FILE01 VALUES('A', 1.2) 

  1 rows inserted in FILE01 in QTEMP. 

INSERT INTO QTEMP/FILE02 VALUES('B', 2.3)

  1 rows inserted in FILE02 in QTEMP. 

CREATE VIEW QTEMP/FILE0102 AS( 

  SELECT * FROM FILE01 
  UNION 
  SELECT * FROM FILE02 
  ) 
  View FILE0102 created in QTEMP. 

SELECT * FROM FILE0102 

....+....1....+...
MYCHAR       MYNBR
A             1.20
B             2.30


Rob Berendt