Data Upload from Cobol Flat File To Oracle Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Data Upload from Cobol Flat File To Oracle Table

  1. #1
    Join Date
    Sep 2000
    Posts
    56
    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

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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.


  3. #3
    Join Date
    Sep 2000
    Posts
    56
    Thanks.But how to load the packed decimal format data

  4. #4
    Join Date
    Nov 2000
    Posts
    344
    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?

  5. #5
    Join Date
    Jun 2000
    Location
    Conway,AR,USA
    Posts
    29
    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.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Soumya
    still learning

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width