Q: What is the value used with -C flag of BEGIN-SELECT?

A: BEGIN-SELECT -Cflag (Oracle, Ingres, SQL Base) - sets query buffer size. If the value of the -C flag is up to 256 it is in kilobytes, any number over 256 is in bytes only. For Oracle the default is set by the context_area parameter in the init.ora file - the default is 4096.