Hello, We recently upgraded our development IBM i OS to V7.3 from V7.1. The query below is executed from an existing CL program and still functions normally on our production machine, which is still on V7.1. On the development machine we get the following error:
Function EDIT not found in library *N.
Query definition template 1 not valid.
Ownership of object SQLEXEC in QTEMP type *USRSPC changed.
Function EDIT not found in library *N.
15 object links removed. 0 object links not removed.
Query definition template 1 not valid.
Here is the query:
EXECUTE SQL('select vdate, actyr, netwrt, netern, paid,
reserv, netinc, edit(lratio,5,4," . 0%")
len(7) name(lratio) colhdg("Loss" "Ratio") from
re0052 order by actyr') ALWNULL(*NO) PCFMT(*XLSX)
TOSTMF('/edi/WCP_9x1.xlsx') REPLACE(*YES)
RECIPIENT('
[email protected]') TEXT('WCP XOL to $10MM AAD -
Working Layer')
I have not been able to locate anything on this in the knowledgebase or elsewhere online.
Thanks for any assistance you can provide.