Re: INTEGER & VARCHAR() on I-specs

On 1/14/2016 3:21 PM, Justin Taylor wrote:

I have a DDL-described PF with these columns:
ID integer
TEXT varchar(40)
...

I'm trying to do I-specs for these but I'm having trouble. DSPFFD shows:
ID buffer length 4 buffer position 1
TEXT buffer length 42 buffer position 5

So I did these I-specs:
I I 1 4 0ID
I A 5 46 TEXT

ID seems fine, but TEXT is acting weird. In debug, TEXT shows a blank space before the value which doesn't go away if I trim the field. That makes me think there's some non-displayable character there. I've never defined an INTEGER or a VARCHAR on an I-spec, so I assume I messed something up.

I-specs don't have a separate data type for VARCHAR, so you are going to
have to manage this yourself. I might suggest a data structure with the
first 2 bytes as an integer for the length and the last 40 bytes as the
actual text.You'd need to substring out only 'length' bytes because
anything after that would not necessarily be initialised.