-
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]
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|