I did not see the exact code in question but do you have a pgm described varaible as the “Library name”? That is not allowed when SQL is embedded in RPGLE.
…….. Yes, it is allowed. You just have to code it properly. — Tom
Is commitment control on?
If not, are you setting commit option to *none
Exec SQL set option commit = *none;