The error message for "no data" in an exec sql insert select from statementhas to be 100.sqlwarn[6] should be 'W' if the PRECISION or SCALE value specified in a SETDESCRIPTOR statement will be ignored.it would be nice to be able to use :var[:index] as cvariable