Re: SQLLEN of variable length character field in SQLDA

Gene,

If you use SQL function DESCRIBE of the result set into SQLDA (after a
PREPARE) you will receive the length of the VARCHAR in the SQLDA. The
length of a VARCHAR column in SQL is the actual length in bytes. So option
b SQLLEN = %len(varfld) shpuld be SQLLEN = %size(varfld)

You have to assign a pointer to the variable to store the value. You can
use the lenth of that variable.

I always store character columns in a fixed length character variable (32
bytes), no matter whether the column is fixed CHAR or VARCHAR; with VARCHAR
I have to deal with the first two bytes being the length of the value. No
problems with that.

Regards,
Carel Teijgeler

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

On 14-6-2007 at 13:35 Gene Burns wrote:

I am trying to use open using descriptor :SQLDA in an SQLRPGLE program. I

am able to calculate the value for SQLLEN for a numeric and a fixed-length

character field and the program works.

However, I cannot figure out the length for the variable-length character

field.

I have tried all of the following without success.

SQLLEN = %len(varfld) * 256
SQLLEN = %len(varfld)
SQLLEN = *zero

The message I am getting is below with the specified length changing with

different entries to the field.

Message . . . . : Length in a varying-length or LOB host variable not

valid.

Cause . . . . . : Host variable *N was specified. The value in the

length portion of the variable length or LOB host variable is either
negative or

greater than the declared length. If the host variable is graphic the

length should be the number of DBCS characters. The host variable number is

1. The specified length is 50902. The variable is declared to have

length 3840.

Recovery . . . : Change the length portion of the varying-length or LOB

host variable to a valid positive number or zero. Try the request again.

Anyone have any ideas?