Hello,
I currently have two linked tables in my DB2 Database:
Table1: Reservations
Fields:
Reservation_Number (ABC123456)
Status
Table2: Docs
Doc Number:
Reservation_Number (ABC123456000)
I'm trying to match Reservation Number in both tables but table 2 has added three zeros at the very end therefore brings back no matches.
I've tried converting Reservation Number in Table2 by creating a new field doing the following:
NEW_NBR: Mid([Reservation_Number],1,9)
However if it does bring back any results it takes a HUGE amount of time.
Is there any other way I can try to do this so it can give me quick results?
Limitations: I cannot save the tables as local tables as I need to have live information from customers as they arrive or are updated.
Please help.
Regards,