Could you please suggest how I should define the logic for my below requirement in Pl/1. I have very minimal knowledge in PL/1.
1) I have a file for which each Sequence no, I need to find the Branch number in one table TAB1.
File 1:
Seq-No Reg-No
100 1111
100 2222
101 3333
102 4444
100 1111
100 2222
101 3333
102 4444
TAB1
Seq-No Branch-No
100 12345
100 12121
102 13131
100 12345
100 12121
102 13131
2) Need to concatenate both like Reg-No || Branch and search in another table. If it is not found then write to an error file.
For ex: 1111 || 12345
1111 || 12121
2222 || 12345
2222 || 12121
Kindly suggest