Record Length of a sequential file

olgc · Post by **olgc** » Fri Sep 21, 2012 2:20 pm

Hi there,

In the record length field of a sequential file stage, only one choice: fixed. How can variable be chosed? When the empty is chosen, it's changed back to fixed. Except fixed, what can be chosen?

Thanks,

ray.wurlod · Post by **ray.wurlod** » Fri Sep 21, 2012 3:19 pm

Fixed is the only choice. You specify the actual length through choice of data type for each individual column.

olgc · Post by **olgc** » Mon Sep 24, 2012 1:09 pm

Thanks ray.wurlod, 8.7 does not support variable length of records. Only fixed length of record. Then the length of a record is fixed. You don't have choice. The length of the record is calculated from its columns. Why is there for you to type in the length? That's a drawback of 7.5. What's the reason?

Thanks,

ArndW · Post by **ArndW** » Tue Sep 25, 2012 3:52 am

olgc wrote:...8.7 does not support variable length of records. Only fixed length of record...

No, that is incorrect. If you do not specify a length then the record is deemed to be of variable length. If your column specifications include variable length fields (i.e. VarChar() ), then the file is deemed to be of variable length.