ECPG Select Multiple lines into an array

select_multi.ec

#include <stdio.h>

int main()
{
    int i;
    EXEC SQL BEGIN DECLARE SECTION;
    int db_tar_id[20];
    EXEC SQL END DECLARE SECTION;
    EXEC SQL CONNECT TO stars;

    EXEC SQL SELECT tar_id INTO :db_tar_id FROM targets ORDER BY tar_id LIMIT 20;

    for (i=0; i<20; i++)
        printf("%d\n", db_tar_id[i]);

    EXEC SQL COMMIT;
    EXEC SQL DISCONNECT ALL;
    return 0;
}