I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in another file say...
I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?