Interactive SQL prerequisites

For Interactive SQL to function correctly, $HOME must exist and must be writable by the user.

Interactive SQL requires that you set the QUOTED_IDENTIFIER database option ON because a number of database functions, including some statements, rely on this setting to function. Interactive SQL automatically sets this option ON when connecting to a database.