Record too big to fit in a block

Sharique · Post by **Sharique** » Sat Jun 10, 2006 5:30 am

I am trying to write into a dataset, but one of the fields which is of format LongVarChar is causing the job to abort with following error message:
"Record too big to fit in a block: Length Requested: 143016".

Is there any limitation to the length of the data that can be written to any field in a dataset?
Is there any way to increase any such limitations?

Thanks,
Sharique

sanjay · Post by **sanjay** » Sat Jun 10, 2006 7:11 am

HI
why LongVarChar is required ?? i mean can't u use varchar.

Thanks
Sanjay

Sharique wrote:I am trying to write into a dataset, but one of the fields which is of format LongVarChar is causing the job to abort with following error message:
"Record too big to fit in a block: Length Requested: 143016".

Is there any limitation to the length of the data that can be written to any field in a dataset?
Is there any way to increase any such limitations?

Thanks,
Sharique

ray.wurlod · Post by **ray.wurlod** » Sat Jun 10, 2006 4:03 pm

As far as I am aware the maximum length of a Long VarChar in a Data Set is 128KB (the maximum length of a VarChar is 4KB, which answers Sanjay's question).

DSXchange

Record too big to fit in a block

Record too big to fit in a block

Re: Record too big to fit in a block