RE: Joining of 2 files

You have something FUBAR in your statement. For example the following immediately pops out as an error:
SELECT A.FLD1 , B.FLD2)

This ran fine and returned three rows:
create table qtemp.b (
fld2 char(9),
fldb char(1)
);

insert into qtemp.b values('000002044', 'A');
insert into qtemp.b values('00 2044', 'B');
insert into qtemp.b values('2044ABCDE', 'C');

select b.fld2, INT(NULLIF(REGEXP_REPLACE(B.FLD2, '[^0-9]',''),''))
from qtemp.b;

create table qtemp.a (
fld1 dec(6,0),
fldx char(10));

insert into qtemp.a values(2044, 'HI');

CREATE VIEW qtemp.FILE3 ( FLD1 , fld2 ) AS ( SELECT A.FLD1 , B.FLD2 FROM
qtemp.a a JOIN qtemp.b b ON
A.FLD1 = INT(NULLIF(REGEXP_REPLACE(B.FLD2, '[^0-9]',''),'')));

select * from qtemp.file3;

Rob Berendt