Re: joining 3 files

[jerry ven <jerryven95@xxxxxxxxx>]

if it's getting complicated  then just for first 2 files:-



file1 :-  fld1  decimal     6(length)

file2  :- fld2   character  9 (length) ( it's consecutively 6 numeric
digits needs to be extracted for comparison and they have  random start
positions
 in this field )


so what should be the correct version of this SQL query-  select * from
file1 A left join file2 B  ON A.FLD1 = CAST(B.FLD2  AS INT)

so that i could get all the 6 numeric digits which are although in
consecutive in nature but their start positions  may vary in this field2
(fld2) which is of character data type and of 9 length.



Thanks.

On Wed, 22 Jun 2022 at 23:57, Stephen Landess <steve_landess@xxxxxxxxxxx>
wrote:

> Jerry -
>
> It's not my intention to be ugly, but you should really think more
> carefully about your questions and give more background information.
>
> From the types of questions I have seen from you, it seems that you are a
> newbie to the platform.  Being new to IBM i is a /good/ thing, but please
> consider that most of us have daytime jobs and don't have that much time
> for guesswork at helping you solve your problems, and I'd rather spend my
> evenings with the family, not answering technical questions.
>
> For example,  in this case, I would have at least given the names and
> attributes of the files/fields that you are attempting to join so as to
> eliminate confusion on the part of those of us who are attempting to help
> you.
>
> Perhaps cut and paste portions of the DDS/DDL used to create the files,
> showing the relevant fields, thus eliminating the guesswork.
>
> Also, Eric Raymond wrote an excellent blog on 'How to Ask Question the
> Smart Way."
>
> Everyone should read/re-read/review this page:
> http://www.catb.org/~esr/faqs/smart-questions.html
>
> Regards,
> Steve Landess
> 512-289-0387
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com