IBM Mainframe Forum

Hy,

i need to insert a field in a DB2 VARCHAR field, but is necessary know the size of field before insert the data.

My input file has the following data:
[img][/img]


I need count the number of caracters of the string that begins in position 41 without the spaces, in this case the answer will be 18.

thank for the help

Hello and welcome to the forum,

Please do NOT post images - they are more difficult to work with and waste considerable forum space. To get the desired result, use copy/paste and the Code tag.

How did you arrive at 18? Did you mean 31 rather than 41? What is the max length?

Actually, I make it 8 - 'anderson'

Fixed-length or variable-length records? The techniques are different, so need to know.

Sorry for post images, it's my first time here...
In really the character begin in position 31 and not in the 41. The Max Length is 300
Billy Boo it's fixed-length.

Thank for all

Have a look at this one, it should have enough in it: dfsort-icetool-icegener/topic8981.html#p43880

BillyBoyo wrote:Have a look at this one, it should have enough in it: dfsort-icetool-icegener/topic8981.html#p43880

thanks for the example, I've done here and it worked correctly

Good work. Thanks for letting us know. Can you post the code you used, as it may help others in the future.