Block cursors are ON (1) by default. To disable block cursors for the entire connection, set this option to OFF (0). The connection-level setting can be overridden for a specific query with the query-tuning option: QUERY-TUNING(NO-LOOKAHEAD).