PICXBINDING

Specifies the handling of fixed-length input host variables.

Syntax:

PICXBINDING={DEFAULT | FIXED | VARIABLE}

DEFAULT

When DBMAN=ODBC

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

When DBMAN=JDBC

SQL Server Connections: Do not trim trailing spaces.

DBCS locales and other database connections: Trim trailing spaces.

FIXED

When DBMAN=ODBC: Trim trailing spaces and set ColumnSize to the size of the host variable.
Bind as SQL_CHAR.
When DBMAN=JDBC: Do not trim trailing spaces.

VARIABLE

When DBMAN=ODBC: Trim trailing spaces and set ColumnSize to the size of the host variable.
Bind as SQL_VARCHAR.
When DBMAN=JDBC: Trim trailing spaces.

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.