IBM i Global

 View Only

 DB2 Systools : Generate spreadsheet

Shannon Montague's profile image
Shannon Montague posted Thu July 17, 2025 12:27 PM

Hi everyone,

I'm currently trying to use runSQL Scripts to automate a report to be automatically sent out as a spreadsheet. I've gotten it to work a few times, but it seems like more often than not the spreadsheet will not populate within the IFS. I've double checked my queries and statements, and they do work just fine. However when I go on the green screen and check the spoolfiles I see one regarding CLDOWNLOAD syntax being incorrect. 

I was wondering if anyone has seen this before and if there are any fixes they have found for it.

Thank you so much for your time and any help or insight you're able to provide.