Home » RDBMS Server » Server Administration » DATA MASK IN SQL LOADER
DATA MASK IN SQL LOADER [message #57433] Mon, 16 June 2003 02:52 Go to next message
A.Angelo
Messages: 1
Registered: June 2003
Junior Member
Hello!
I have to load numeric types into a table, from a flat file, record fixed length.
More specific, in the target I have the numeric type NUMBER(12.2), while the source corresponding field is 14 chars wide, WITHOUT ANY DECIMAL SEPARATOR.
How do I specifiy the correct format of the number to be loaded?
Thanks!

Report message to a moderator

Re: DATA MASK IN SQL LOADER [message #57465 is a reply to message #57433] Tue, 17 June 2003 11:35 Go to previous message
sidd
Messages: 130
Registered: May 2003
Senior Member
Here is how i did in my case, you have implied decimal here, so try this, it should work, let me know if not.

FieldName DECIMAL EXTERNAL(12) "DECODE(:FieldName,NULL,'',:FieldName/100)"

Report message to a moderator

Previous Topic: Using Oracle Gateway from Microsoft Transaction Server
Next Topic: omf feature doesn't function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:29:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.