The -b option

The -b option controls binding of host variables used in statements that retrieve result data from Adaptive Server. When used in conjunction with the -p option, it controls binding of host variables in select and exec statements. When the -b option is used by itself, it can only control statements that fetch with a cursor.

Thus, generally, the -b option controls binding of host variables (output variables, result variables, status variables, indicator variables, and so on) whose values are passed from Adaptive Server. (Information about “host output variables” also applies to any other variables whose values are output from Adaptive Server.) More precisely, the -b option controls whether binding occurs at each execution of Client-Library’s ct_fetch routine. (The ct_fetch routine retrieves a single row of data from Adaptive Server.)