Error SQL 22002

Hi all

In a RPG program execute SQL : below what i do:

when i run the program i receive SQL Error 22002 An indicator variable is
required.



Where am i wrong ? how can solve this error ?






Dcl-Ds MainDs;

xAnnoc Char(2);

xMesec Char(2);

xImpo Packed(30:9);

End-Ds;





mainStatement = ' SELECT '

+ ' Substr(xdtr, 1, 2), '

+ ' Substr(xdtr, 3, 2), '

+ ' SUM((xqty * (prc - xsc) ) * §CSEG ) AS impo '

+ ' FROM myfile m '

+ ' left join myile 2 t '

+ ' on xcax = §cax '

+ ' Group by substr(xdtr, 1, 2) , substr(xdtr, 3, 2)'

+ ' order by substr(xdtr, 1, 2) , substr(xdtr, 3,2)';



ExEC SQL

FETCH NEXT FROM mainCursor INTO :MAINDS ;