Mapping decimal fields

[powerinmind2]

Hi,
i have a problem. i have a seq file with a decimal field.

Ex. 1234567.1234

I want read this field. I have set Lenght to 7 and Scale to 4 but i cannot read this field!! I read this error: "Field "COL2" has import error and no default value; data: {1 2 3 4 5 6 7 . 1 2 3 4}"

Help me!

Massimiliano

[1stpoint]

Try changing it to Varchar(50).

[kcbland]

I'm curious, you show a job type of parallel but a platform of Windows? Your error looks like a PX error, but you can't run PX on Windows.

[powerinmind2]

Try changing it to Varchar(50).

I cannot because i verify the field. If data into field are different type, i reject the record!

[powerinmind2]

I'm curious, you show a job type of parallel but a platform of Windows? Your error looks like a PX error, but you can't run PX on Windows.

Sorry Ken!! The platform is UNIX!!! Have u an idea for my problem? I have set the options of the field but i have problem too!!

[Teej]

Hi,
i have a problem. i have a seq file with a decimal field.

Ex. 1234567.1234

I want read this field. I have set Lenght to 7 and Scale to 4 but i cannot read this field!! I read this error: "Field "COL2" has import error and no default value; data: {1 2 3 4 5 6 7 . 1 2 3 4}"

That's because it's a length of 12, not 7. Really 11, but 12 due to the fact that you're reading it from a flat file so must count the period.

-T.J.