MVSFORUMS.com

[gore]

Hi
I am using a host variable in COBOL : V1 pic x(15) in which the following value has been moved '9999999999999 '. (2 trailing spaces.)
The same value exists in DB row also with trailing spaces.

When i use the following cursor

select * from table where search_field = :V1.

It is not able to retrive the row from the table and gives me SQL code of +100.

When I hardcode the same value in Cursor it fetches the row.
I am using the Move statement to populate the host variable.
Please note that both the table column and the variable from which host variable is populated are of same length pic x(15).
What could be the reason for its inability to find the match? Are the two trailing spaces being ignored in host variable?

Any pointers would be highly appreciated.

[help_me]

Inspect for removing the SPACES before Opening the Cursor
EXEC SQL
SET :WS-VARV1 = STRIP(:V1)
END-EXEC.

And then Open the CURSOR

Hope this helps.
Rgds
Srinivas

[kolusu]

gore,


Are you pretty sure that the value in the table has indeed two trailing spaces in it. I suspect that you have binary zeroes in the last 2 bytes which will look like spaces. If you hex on then you should have a hex value x'40' in the last 2 bytes.

Kolusu

[gore]

Thanks everyone, the problem was due to movement of spaces to host varible just before opening the cursor.