Pro*C Help Needed

I'm trying to use a host variable within a select clause as follows:

EXEC SQL BEGIN DECLARE SECTION
char HostVar[10][15];
EXEC SQL END DECLARE SECTION strcpy(HostVar[0], 'string1');
strcpy(HostVar[1], 'string2');

	select somefield
	from   table
	where  value in (:Hostvar);

This does not return any values unless I fill up the entire array. Any help would be appreciated! Thanks. Received on Wed Aug 13 1997 - 00:00:00 CDT