&sql(.....) not working in and returns SQLCODE -400 if try to execute in non persistent cls , -30 in other persist cls
I have written below method inbound adapter myAdapter Extends Ens.InboundAdapter [ ProcedureBlock ] returns -400
If i have written in any other
&sql(SELECT count(ID) INTO :msgCount FROM Ens.MessageHeader)
If SQLCODE=0 Quit msgCount
Could you please some one tell me where should write this class method? What I am doing wrong?