Can you give examples of what is considered good joins
For example
File1/Field1 value of 293
File2/Field2 value of '293 ', ' 293 ', ' 293 ', ' 293' would be all good joins (different number of leading spaces)
But what about '000293', '00293 ', '0293 '?
Then what about 'a293 ' - if the File2/Field2 contains anything NON numeric - that record is NOT to be considered
Hope this makes sense
Alan Shore
Solutions Architect
IT Supply Chain Execution
[NHScsignaturelogo]
60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx
'If you're going through hell, keep going.'
Winston Churchill
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of jerry ven
Sent: Wednesday, June 29, 2022 11:35 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] joining of two files
Hi,
I have two files lets say file1 and file2.
file1 has multiple fields but let's say currently we are just focused for
it's field1 and similarly file2 have multiple such fields and we are just
concerned with field2.
field1 of file1 is of packed decimal with 6 length.
field2 of file2 is of character data type and of length 9.
Now we want to join file1's field1 to the fiel2's field2 in such a way that
we are sure that field2 (would have that matching value from file1's field1
in it's( inside field2) first 6 positions only.
and even if it's found in field2 beyond 6th position then we are not
concerned with that match.
So how to join these files to get the matching records from fiile1's field1
to file2's field2.
I mean what should be the join SQL query to get these matching records?
Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l<
https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l<
https://archive.midrange.com/midrange-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com<
https://amazon.midrange.com>
midrange.com
