Preventing persistent binding for all cursor host variables

If you omit both the -b and -p options when precompiling the above example, no bindings persist. Instead, the generated code binds the host variables each time the fetch statement executes, regardless of whether the variable is input to Adaptive Server or output from it.