I have third party application software where the location master file has two fields for the key. The first field is 16 alphanumeric and the second field is 2 numeric. The other files that reference this location master file has a single key of 18 alphanumeric. The problem is I need to link to the location master file to get the most important information, address. Our users have a report writer using ODBC to access these files on the AS/400. Does anyone know how or if I can join these files? All responses will be appreciated. Thanks. Diana Hicks Town of Jupiter email@example.com +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.