All,
I am trying to use indicator variable arrays in my fetch statement and i am getting error. This particular chunk of code used to work fine on redhatLinux for past 2 or 3 years. and now we wanted to move to enterprise linux and it is not accepting indicator variable arrays. But it is accepting indicator variables. here is what it looks like
EXEC SQL FETCH X INTO :fmt :mind;
OR
EXEC SQL FETCH MRPTC INTO :fmt INDICATOR :mind;
"fmt" is nothing but the struct of the columns i am pulling and mind is the indicator variable array. something like
struct report {
long a
long b
} fmt;
short mind[2];
when i compile this is what i get
767 SQL0104N An unexpected token ":" was found following ":".Expected tokens may include: "END-OF-STATEMENT".
But as i said..this used to work fine. Any help is greatly appreciated.
I am trying to use indicator variable arrays in my fetch statement and i am getting error. This particular chunk of code used to work fine on redhatLinux for past 2 or 3 years. and now we wanted to move to enterprise linux and it is not accepting indicator variable arrays. But it is accepting indicator variables. here is what it looks like
EXEC SQL FETCH X INTO :fmt :mind;
OR
EXEC SQL FETCH MRPTC INTO :fmt INDICATOR :mind;
"fmt" is nothing but the struct of the columns i am pulling and mind is the indicator variable array. something like
struct report {
long a
long b
} fmt;
short mind[2];
when i compile this is what i get
767 SQL0104N An unexpected token ":" was found following ":".Expected tokens may include: "END-OF-STATEMENT".
But as i said..this used to work fine. Any help is greatly appreciated.