RE: joining 3 files

[Stephen Landess <steve_landess@xxxxxxxxxxx>]

Jerry -

There is only so much I can do without seeing examples of YOUR data.  

Obviously, if there is any sensitive information contained therein you may need to mask certain field values, but I assumed from your previous posts that FLD1 of File2 only contained numbers and no alpha values, which appears to have been an incorrect assumption.

Regards,
Steve Landess
512-289-0387

Jerry Ven wrote:
> when i ran this view file3 it showed  matching records of  FLD1 of file 2 
> ( which is of 9 length and  character data type and where that 6 digit number
> ( consecutive 6 digits) is present at random location ) 
> like these records for example in my data  i got it like 111111xy ,
> i mean for some of the fields it's showing correctly up to exactly matching length of 6 
> but for some of the fields i am getting two extra characters like 111111xy.
> So how to get that exact 6 digit number from file2 for FLD1 which should match 
> FLD1 of file1 here so that in result of 
> Select * from QTEMP/FILE3 i should not see those extra characters in  FLD1 of file2 here.