Data Integrator (ODBC) defining varchar(max) in bind paramet

I have a situation where I want to exchange varchar(max) parameters with a stored procedure (happens to be SQL Server but that does not matter).

When binding the parameter is there a way to allow the length associated with the storage buffer to be acquired rather than specifically stating a length? Or must one state the length as the maximum size that a varchar(max), for example, can have.

If the length must be specified, this seems to defeat the puprose of the (max) attribute which is to allow dynamic space allocation.

This is using the Cloverelaf Data Integrator (Data Direct ODBC Drivers).

I also may have a need to handle varbinary(max) as well so the answer has far reaching implications.

Thanks