HolderAndrew
Well Known Member
Hi List
I have an interesting problem i think, we are trying to understand when generating a table on the iseries from within OMW, how a column is created as "variable length" or not. We are on E1 9.1.5.5 but the same also occurs on earlier releases.
For example in table F03B920C the CRTC alias is defined as a string of length 300 in the DD (ie. it has a data class value of '2' for STRING and not VARLEN) but when the table is generated on the iseries the field is defined as below (ie variable length, with buffer length of 602)
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
ZDCRTC GRAPHIC 300 602 1 Both ZDCRTC
Variable length field -- Allocated length : None
Allows the null value
Coded Character Set Identifier . . . . . : 13488
UCS2 or Unicode conversion . . . . . . . : *CONVERT
How does the "engine" create this field as veriable length? How is this controlled?
Best regards,
Andrew
I have an interesting problem i think, we are trying to understand when generating a table on the iseries from within OMW, how a column is created as "variable length" or not. We are on E1 9.1.5.5 but the same also occurs on earlier releases.
For example in table F03B920C the CRTC alias is defined as a string of length 300 in the DD (ie. it has a data class value of '2' for STRING and not VARLEN) but when the table is generated on the iseries the field is defined as below (ie variable length, with buffer length of 602)
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
ZDCRTC GRAPHIC 300 602 1 Both ZDCRTC
Variable length field -- Allocated length : None
Allows the null value
Coded Character Set Identifier . . . . . : 13488
UCS2 or Unicode conversion . . . . . . . : *CONVERT
How does the "engine" create this field as veriable length? How is this controlled?
Best regards,
Andrew