Data Upload from Cobol Flat File To Oracle Table

[sureshgane]

How to load data from a cobol flat file to ORACLE table.How to handle files with the packed numeric data and unpack it for loading to Oracle.
Thanks

[jdorlon]

Look in your Oracle documentation for SQL*Loader. It is a utility designed to do just what you are looking for. It is very flexible.

[sureshgane]

Thanks.But how to load the packed decimal format data

[jdorlon]

what is 'packed numeric data'?

You can specify in SQL*Loader that something like this :

123456789
123456789
123456789
123456789

is really 3 sets of numbers (one for each column in you table), as in...

123 456 789
123 456 789
123 456 789
123 456 789

by telling it at what positions in the file that each column in the table begins at.

Is that what you meant?

[bkanti]

You need to specify packed decimal as ZONED in the SQL*Loader Control file
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The precision of a numeric field is the number of digits it contains. The length of a numeric field is the number of byte positions on the record. The byte length of a ZONED decimal field is the same as its precision. However, the byte length of a (packed) DECIMAL field is (p+1)/2, rounded up, where p is the number's precision, because packed numbers contain two digits (or digit and sign) per byte.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~