Error in creating fixed length sequential file

dsguy · Post by **dsguy** » Wed Dec 06, 2006 5:01 am

Hi All

I am getting following error while inserting in to a fixed length sequential file.
Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "C_UNITS".

the datatype is smallint.

Can we use smalint and decimal for fixed length sequential file?

Thanks for your help in advance.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 06, 2006 5:27 am

Edit the extended properties (Edit Row...) and provide Field Width property values.

Nageshsunkoji · Post by **Nageshsunkoji** » Wed Dec 06, 2006 6:09 am

dsguy wrote:Hi Ajith
Thanks for your inputs.
Actually my source is
Sybase and the datatype for teh columns are smallint and decimal can you helo me what is the length i need to spacify in the metadata information.

Thanks,
girish

Hi Girish,

How he can help about your source fileds length of small int and decimal ?

You have to decide what is your source and target filed lengths and then Edit the extended properties (Edit Row...) and provide Field Width property values.

ajith · Post by **ajith** » Wed Dec 06, 2006 6:25 am

dsguy wrote:Hi Ajith
Thanks for your inputs.
Actually my source is
Sybase and the datatype for teh columns are smallint and decimal can you helo me what is the length i need to spacify in the metadata information.

Thanks,
girish

Smallint is 16 bit int so the maximum value is +32 767 if it is signed ..
So u can keep the length as 5

Regarding the decimal you have to get it because there is no limit to the data there.. Try to get the maximum value the field is going to hold and give that length ...

dsguy · Post by **dsguy** » Wed Dec 06, 2006 7:16 am

Hi Ajith

Actually i am using length 5 for small int but still it is throwing the above given error.

The value in the colum is 2 for all teh records but still it throws an error i am not sure why?

Thanks,
girish

dsguy · Post by **dsguy** » Wed Dec 06, 2006 7:27 am

Hi

I edit the lenght made it as 5 for small it in Datastge seq file.The actual value present is 2 for all the records.Still it throws this error

Sequential_File_55: Error when checking operator: Unable to initialize the exporter.

Sequential_File_55: Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "C_UNITS".

Thanks,
girish