RPG Host variable in dynamic SQL ?

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Hi everyone,

I have replaced this :

wSql2 =

'SELECT COUNT(*), SUM(MyField) ' +

'INTO : RPGfield2, : RPGfield2 ' +

'FROM MyFile' +

' WHERE SUBSTR(DAENRE, 22, 3) = ''210''';

EXEC SQL

PREPARE S3 FROM : wSql2;





with this :

EXEC SQL

SELECT COUNT(*),SUM(MyField)

INTO : RPGfield2, : RPGfield2

FROM MyFile

WHERE SUBSTR(DAENRE, 22, 3) = '210';


In the first case, I was getting SQL0312 at the PREPARE. Is it because of the host variables? The second case works fine. MyFile was also supposed to be in a host variable as its name is composed with the year.
I will probably override its name in a CL.

I'd be grateful if anyone can explain why the first case is not possible and how it should be done.

TIA.