MVSFORUMS.com

[visa]

Hi all,

We are facing some problem with string manipulations. The problem is as follows.

We are getting a varchar(253) value from a DCLGEN variable into a working storage variable.

The obtained string contains data as follows

<start of string>Xxxxxxxxxxxxxxxxx yyyyyyyyyyyyy <end of string>

We need only

[ofer71]

Try to DISPLAY the variable's content, and take a look in HEX mode.

O.
________
VERMONT MEDICAL MARIJUANA DISPENSARY

[dbzTHEdinosauer]

as ofer71 implied, it seems as if you are not aware of the delimiter (what separates x and y).

keep in mind, you host-variable size is 253. After the select, DB2 has only supplied data for the the length (of that particular column; next row could have a smaller or larger varchar). what that means is if your host-variable is 253 and you only receive 200, byte 201 to 253 contains whatever was left from last load of the field.

1. you need to determine what delimits x and y.

2. you need to use the length returned by DB2 for the current returned varchar.

3. why are you reversing? don't you have to reverse it again for your output?

4. when you know the delimiter, use it in an unstring to separate the x from the y. you can always place your own delimiter after the y (reference modification (length of varchar returned by DB2:1). your unstring needs 3 fields. the x container, the y container, the rest. your delimiting phrase for y can be a double - space or your delimiter.
_________________
Dick Brenholtz
American living in Varel, Germany

[visa]

hi all

i got the desired output..
in the IF condition where i'm checking for SPACEs i also have to check for LOW-VALUES.

anyone who is doin gsuch kind of thing please make this sure..

Thanks
visa