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
Mapping decimal fields
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 16
- Joined: Wed Nov 26, 2003 5:42 am
-
- Participant
- Posts: 16
- Joined: Wed Nov 26, 2003 5:42 am
Re: Mapping decimal fields
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.powerinmind2 wrote: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}"
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).