Re: Create view over multiple files

["Lance Gillespie" <lgillespie@xxxxxxxx>]

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