I am going to need to write a CL program that will read a list downloaded from an Excel spreadsheet onto the AS/400. The CL will scan through the file that will delete the job description associated with the user profile in QGPL and will replace the deleted job description with a new JOBD that has a different library list. Because two plants are being sold off, we need to separate the two companies that will be running on one system, but keeping users from either company from accessing the other companies' data.
My other CL will add a group profile to everyone either companyA or companyB. There will be two group profiles defined. Also, probably another CL that will put *EXCLUDE authority on libraries of the opposite group profile.
Thanks for any help you can offer.