Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Load problem for data type decimal

Status
Not open for further replies.

hnkadmn

MIS
Sep 22, 2003
13
US
Hi

I have table with a_bc_de column decimal(15,2). The data has to be loaded using Load utility. The data is in text format for this decimal column say 12324343.23, but the load card for this column will be like
A_BC_DE POSITION( 37: 44 )
DECIMAL PACKED
So data is not loaded as LOAD utility expect in binary format. I am getting data in text format from SQL server.

any solution for this problem.
I have 6 colums like this. Please advise.

Thanks in advance.

Hari
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top