ECPG (usage of simple select statement)

Hi,

 

I'm using ECPG in my C code and I want to display the result of a simple select statement.

 

If i write something like

EXEC SQL select * from abc ; (which as of now is not working)

 

wouldn't this display the result staright away or its always mandatory to use a cursor and then do printf() for

each row retrieved?

 

Thanks,

Jas