Re: DDS help please

You mean like this:
> CREATE TABLE ROB/WENZLOFF1 (INVOICEDEC DEC (6 , 0) NOT NULL WITH
  DEFAULT, SOMESTUFF CHAR (15 ) NOT NULL WITH DEFAULT) 
  Table WENZLOFF1 in ROB created but could not be journaled. 
> INSERT INTO ROB/WENZLOFF1 VALUES(1, 'test') 
  1 rows inserted in WENZLOFF1 in ROB. 
> CREATE TABLE ROB/WENZLOFF2 (INVOICECHAR CHAR (22 ) NOT NULL WITH
  DEFAULT, OTHERSTUFF CHAR ( 15) NOT NULL WITH DEFAULT) 
  Table WENZLOFF2 in ROB created but could not be journaled. 
> INSERT INTO ROB/WENZLOFF2 VALUES('000001', 'yadda yadda') 
  1 rows inserted in WENZLOFF2 in ROB. 
> CREATE VIEW ROB/wenzloffv AS SELECT 
  Prompting was cancelled by the user. 
> CREATE VIEW ROB/wenzloffv as 
   select a.invoicedec as invoicenbr, 
          a.somestuff as FirstField, 
          b.invoicechar as invchar, 
          b.otherstuff as Otherfield 
   from wenzloff1 a 
         join 
        wenzloff2 b 
         on digits(a.invoicedec) = substr(b.invoicechar,1,6)
  View WENZLOFFV created in ROB. 
> select * from wenzloffv 
....+....1....+....2....+....3....+....4....+....5....+....6....+...
INVOICENBR  FIRSTFIELD       INVCHAR                 OTHERFIELD 
        1   test             000001                  yadda yadda 
********  End of data  ******** 

Now I can Query/400 wenzloffv to my heart's content.

Rob Berendt