What's wrong here?

Hi,



We have an SQL statement that is run by an RUNSQLSTM at our client's IBM i
servers. It runs fine on 4 out of 6 of their servers. The failures say it's
a syntax error.

Here's the SQL source.



And here's the error.





I'm at a loss what's wrong here. It works on 4 out of 6 servers, all at v7r2
and all at same PTF level, and it works here on v5r4, v7r1, and v7r3.



Here's the RUNSQLSTM in use.

RUNSQLSTM SRCFILE(INSTFRLIB/QSQLTXT) +

SRCMBR(LICKTYSPLT) COMMIT(*NONE) +

ERRLVL(20) DBGVIEW(*LIST) +

CLOSQLCSR(*ENDMOD) USRPRF(*OWNER) +

DYNUSRPRF(*OWNER)

Any suggestions will be gratefully received.



Kind Regards,



Thomas Garvey