how to remove the end point in decimal column

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
yimwai
Participant
Posts: 46
Joined: Thu Jul 01, 2010 9:34 pm

how to remove the end point in decimal column

Post by yimwai »

I transcode a complex file to a sequential file without any change in column type.But I fail to load data from sequential file to SQL server by bcp
tool because there is a point "." at the end of decimal column(with decimalplace 0) such as decimal(8,0).
If I change the column type from decimal(8,0) to bigint, the problem dispears. But I have a lot of jobs and columns to edit.
I wonder if there is a better way?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is there some setting for bcp that allows it to recognize the "nnnnnnn." format for decimals with a scale of 0?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply