PICXBINDING

Syntax:

PICXBINDING={DEFAULT | FIXED | VARIABLE}

DEFAULT

When DBMAN=ODBC

Trim trailing spaces and set ColumnSize to the size of the host variable.

When DBMAN=ADO

Trim trailing spaces.

Depending on the setting of ADOPICXISANSI:

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.

Default:

DEFAULT

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

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

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

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