Good afternoon! I have been given the task of taking a CL program that creates a copy of large files (snapshot) then calls a rmtcmd on a server to get the files from the iSeries.
They're complaining because it's taking longer and longer as the files grow and now want to limit it to 2 years being extracted. I'm hoping to somehow call SQL or a stored procedure that I can pass the date range to extract, and have it do an insert into the output file for pick up.
Is that possible, and if not, any suggestions?