I am trying to build a static cursor using an embedded SQL query that has an 'IN' clause containing a variable number of parameters. The purpose of this query is to pull from a table the subjects to run the query against. Since the actual query takes 160 lines, the pertinent line is as follows:

EXEC SQL DECLARE count_cursor CURSOR FOR
SELECT
a.value,
COUNT(DISTINCT a.column1 || a.column2 || a.column3)
FROM
table1 a,
table2 b
WHERE
a.key = b.key
AND a.key2 IN (:list_key2)



This is what :list_key2 is assigned in Pro*C. Key2 is a NUMBER(9):

if ( ( exit_status != EXIT_FAILURE ) && ( *rpt_type == 'N' ) )
{
while ( sqlca.sqlcode == 0 )
{
/* Get a row. */
EXEC SQL FETCH payer_cursor
INTO :key2;
if ( sqlca.sqlcode != 0 )
{
fprintf( stderr, "SQLCODE = %d, MESSAGE = %s\n",
sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc );

exit_status = EXIT_FAILURE;
}
else if ( sqlca.sqlcode == 0 )
{
/* Append payer to the payer list */
strcat( payer_list, ", " );
sprintf( tmp_buf, "%d", key2 );
strcat( payer_list, tmp_buf );
}
}
}


I realize this is pseudocode, but the concept is clearly represented, and I hope is simple enough to generate an example.