× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.