Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
SQL or stored procedure in a CL program???
has no ratings.
Published: 21 May 2012
Revised: 23 Jan 2013 - 3448 days ago
Last viewed on: 02 Jul 2022 (5866 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL or stored procedure in a CL program??? Published by: Chris Proctor on 21 May 2012 view comments(5)

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?



Return to midrangenews.com home page.
Sort Ascend | Descend