PICXBINDING

Specifies the handling of fixed-length input host variables.

Syntax:

PICXBINDING={DEFAULT | FIXED | VARIABLE}

Parameters:

DEFAULT
When DBMAN=ODBC
Trim trailing spaces and set ColumnSize to the size of the host variable.
  • SBCS locales bind as SQL_CHAR
  • DBCS locales bind as SQL_VARCHAR
When DBMAN=ADO
Trim trailing spaces.

Depending on the setting of ADOPICXISANSI:

  • SBCS locales bind as DbType.StringFixedLength or DbType.AnsiStringFixedLength
  • DBCS locales bind as DbType.StringLength or DbType.AnsiStringLength
FIXED
When DBMAN=ODBC
Trim trailing spaces and set ColumnSize to the size of the host variable.

Bind as SQL_CHAR.

When DBMAN=ADO
Trim trailing spaces.

Bind as DbType.StringFixedLength or DbType.AnsiStringFixedLength, depending on the setting of ADOPICXISANSI.

VARIABLE
When DBMAN=ODBC
Trim trailing spaces and set ColumnSize to the size of the host variable.

Bind as SQL_VARCHAR.

When DBMAN=ADO
Trim trailing spaces.

Bind as DbType.String.Length or DbType.AnsiString.Length, depending on the setting of ADOPICXISANSI.

Properties:

Default: DEFAULT

Dependencies:

If ALLOWNULLCHAR is also specified, trailing spaces are not trimmed as described in the Parameters section above.

Scope:

Used at compile time: No
Behavior at run time: Source file

See Scope - OpenESQL SQL Compiler Directive Options for more information.

Comments:

With SQL Server, you should only need to use this directive when using PIC X(n) host variables with the LIKE expression.