Page 1 of 1

Record Length of a sequential file

Posted: Fri Sep 21, 2012 2:20 pm
by olgc
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,

Posted: Fri Sep 21, 2012 3:19 pm
by ray.wurlod
Fixed is the only choice. You specify the actual length through choice of data type for each individual column.

Posted: Mon Sep 24, 2012 1:09 pm
by olgc
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,

Posted: Tue Sep 25, 2012 3:52 am
by ArndW
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.