DataSet against Sequential file

videsh77 · Post by **videsh77** » Tue Mar 06, 2007 10:34 pm

Just a Qn when I checked DataSet as against Sequential File. I found file size in unix env for DataSet is greater than Sequential file. Is it normal to have DataSets remain bigger in size than Sequential file for the same Data contents?

kumar_s · Post by **kumar_s** » Tue Mar 06, 2007 10:43 pm

Yes, dataset has its own conversion algorithm.
And more over the fields like varchar are assigned the full length of its max value. In order to improve the access efficiency. Where as sequential files will have the whitspace truncated.

videsh77 · Post by **videsh77** » Tue Mar 06, 2007 10:47 pm

Thanks it helps.