Home » Infrastructure » Other Operating Systems » Zoned data Type
Zoned data Type [message #26470] Mon, 07 July 2003 10:27
Keshav Tripathy
Messages: 30
Registered: November 2001
Member
Hi
I have a scenerio in which I am Loading the Mainframe Data (Text File) to Oracle Tables using ZONED Data Type in the SQL LOADER Control Files. I need to do the same Data Loading using UTL_FILE Package of PL/SQL. What I need to do to take care of Replacing ZONED Statement of SQLLOADER in my PL/SQL CODE.
Example: The Mainframe Text File Looks like this
02003042805120C

The Control File (SQLLOADER) Statement is as follows.

X Position(1:15) ZONED(15,0)

This is working perfectly allright and Data is Correctly Loaded to the Oracle Tables.

But I need to do the Data Load using UTL_FILE so how can I achieve the same.

Thanks to all of you.

Keshav
Previous Topic: JCL : User Completion Code 55
Next Topic: Equivalent of ZONED(SQLLOADER) in PL/SQL
Goto Forum:
  


Current Time: Fri Mar 29 09:21:43 CDT 2024