Eric,

>I need to read a flat file but this file may be too big for filetostr.
>Is there a way to read a line at the time ?

Another way to tackle this (especially if the lne length isn't too big)

create cursor xtemp ( cline c(254) )
append from TheFile type sdf

This lets yoy SCAN or use other DML commands to process the file