RE: joining 3 files -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.