#SQLcandoit #SYSTOOLS.LPRINTF() A good IBM i user asked me why the Gist to generate a spreadsheet into the IFS via an SQL query was failing. turns out that the SYSTOOLS.LPRINTF() procedure needed to be enhanced:

#SQLcandoit #SYSTOOLS.LPRINTF()
A good IBM i user asked me why the Gist to generate a spreadsheet into the IFS via an SQL query was failing. gist.github.com/forstie/2deda5…
It turns out that the SYSTOOLS.LPRINTF() procedure needed to be enhanced:gist.github.com/forstie/314dde…

– Scott Forstie (@Forstie_IBMi)12:43 – Oct 19, 2022

Verified by MonsterInsights