DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: mainframe datatypes

  1. #1
    Join Date
    Jan 2000
    Location
    Manama, Bahrain
    Posts
    50
    I have data in flat files which have been extracted from the mainframe and have to be loaded into an oracle8i db.

    However the mainframe datatypes are slightly different from oracle & i'm wondering how this will affect the actual data.

    These are the datatypes as defined on the mainframe:-
    Field Type - Internal Numeric Type
    1) Unsigned - Zoned
    2) Date - Zoned
    3) Numeric - Packed

    What will be the oracle equivalents for these datatypes?

    [Edited by lynn814 on 08-11-2002 at 05:11 AM]

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    If you have data in flat files then you already have a character representations of all those types.
    Now you should simply create table with number, date, number fields and SQL Load this data in.

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