Re: SQLLEN of variable length character field in SQLDA

Gene,

In that case I would pass a pointer to a fixed length character variable
and define SQLLEN with SQLLEN = %len(%trimr(varfld)), i.e. use the %trimr
BIF on the variable.

Be aware to use wildcards in the value and putting the value in the
character varible does not require additional quotes. Just a reminder..

Regards,
Carel Teijgeler


*********** REPLY SEPARATOR ***********

On 14-6-2007 at 15:10 Gene Burns wrote:

I guess I wasn't very clear on what I was trying to accomplish.

The variable-length field is not in the database. It is a selection

criteria used for a substitution parameter in the where clause of the
select.

This is provided by the OPEN USING DESCRIPTOR :SQLDA statement.

This process works fine when the variable is a numeric or fixed-length and

the comparison is field = ?

But in this case I am trying to SELECT FLD1, FLD2, FLD3... WHERE FLD2 like

?

and have the OPEN USING DESCRIPTOR :SQLDA provide the value found in the

variable length field, which could be anything from 1 to 15 characters. I

am just having trouble getting the OPEN to work if the field is a

variable-length. I don't know how to determine the SQLLEN to use.