Insert a value from position 5 to 15 of this VARCHAR

vimalprabhakaran · New User Joined: 13 Feb 2006 Posts: 13

I am facing problem with a VARCHAR variable.

I have a VARCHAR variable as below

5 INV_DE_VALUE (25) CHAR(254) VAR,

I need to insert a value from position 5 to 15 of this VARCHAR.

So, i used it as
SUBSTR(INV_DE_VALUE(INDEX),5,10) = DCLDUNS.NBR

But when i try to display the value of INV_DE_VALUE(INDEX) it is shown as spaces.

Can any one help me to solve this issue.
what i need is, i have to insert a value to the 5th position of a VARCHAR variable.

Gnanas N · Posted: Wed May 21, 2008 5:39 pm

Are you talking about VARYING attribute of a variable?

Phrzby Phil · Posted: Wed May 21, 2008 5:58 pm

First, SUBSTR(var,5,10) accesses positions 5-14, but you said you want 5-15.

Second, what value/length was there before your SUBSTR assignment? Please display it.

Third, please show the value of DCLDUNS.NBR.

vimalprabhakaran · New User Joined: 13 Feb 2006 Posts: 13

vimalprabhakaran · New User Joined: 13 Feb 2006 Posts: 13

Phrzby Phil · Posted: Wed May 21, 2008 8:10 pm

So I think length is still zero.

Did you display blanks or nothing? To answer, display '*' || var || '*'.

vimalprabhakaran · New User Joined: 13 Feb 2006 Posts: 13

Phrzby Phil · Posted: Thu May 22, 2008 6:13 pm

How many? Please display as "code" your output. The more info you can give in any one post, the better.

How about also setting a var to the length of your string and showing that as well?