Re: Create view over multiple files

That was it - it did not like the "with tempfile".
It works fine now.

Thanks,
Lance

<rob@xxxxxxxxx> 7/29/2009 8:23 AM >>>

What happens if you replace the initial
CREATE TABLE
with
CREATE VIEW
and drop the WITH DATA at the end?

Or does it not like with "with tempfile"? If so don't use tempfile. What
you're doing really doesn't need it.

CREATE TABLE ROB/GM310AP (GMTDY CHAR (5 ) NOT NULL WITH DEFAULT,

GMDAMT DEC (5 , 0) NOT NULL WITH DEFAULT, GMCAMT DEC (5 , 0) NOT
NULL WITH DEFAULT, GMPROJ CHAR (1 ) NOT NULL WITH DEFAULT)
Table GM310AP created in ROB.

CREATE TABLE ROB/GM310GP (GMTDY CHAR ( 5) NOT NULL WITH DEFAULT,

GMDAMT DEC ( 5, 0) NOT NULL WITH DEFAULT, GMCAMT DEC ( 5, 0) NOT
NULL WITH DEFAULT, GMPROJ CHAR ( 1) NOT NULL WITH DEFAULT)
Table GM310GP created in ROB.

create VIEW rob/GMCVWD01 as (

SELECT
GMTDY as gmyy,
(GMdAMT - GMcAMT) as transamt,
'AJ' AS FLAG
FROM rob/gm310ap WHERE gmproj <> ' '
UNION ALL
SELECT
GMTDY as gmyy,
GMdAMT as transamt,
'AP' AS FLAG
FROM rob/gm310gp WHERE gmproj <> ' ')
View GMCVWD01 created in ROB.

Rob Berendt