RE: SQL finally "free'd"???

[rob@xxxxxxxxx]

So what you are saying is that if my host array in RPGLE is 
MyDivision(x).MyPlant(y).MyLocation(z) I may have to change it to some 
format like
exec sql fetch c1 into:.....;    where ..... may be a totally reformatted 
MyDivision(x).MyPlant(y).MyLocation(z)?
and then you'll take this reformatted variable and do something like
>C                   Z-ADD     -4            SQLER6
>C                   CALL      SQLROUTE
>C                   PARM                    SQLCA
>C                   PARM                    SQL_00006
>C     SQL_00009     IFEQ      '1'
>C                   EVAL      ...TotallyReformattedVariable... = 
SQL_00011

Won't that make it hard to find where the variable is used in the EXEC SQL 
if it won't match the format of the variable in the RPGLE?

Or were you thinking of getting the RPG compiler people to change the 
layout of subscripting arrays?

Or is the change simply in the C specs generated by the precompiler and 
you have to make sure that the generated RPG's
>C                   EVAL      ...TotallyReformattedVariable... = 
SQL_00011
matches some SQL standard?

Now I am really confused.

Rob Berendt