Ask the Expert

Data driven occurs and the control file

We're using Oracle8.1.6 EE on NT4 with surprisingly good results. Since the performance is so good, we've decided to download Mframe EBCDIC data and SQLLOAD it into Oracle. Question: How can we handle data driven occurs? When we know how many occurs will happen, we can hardcode that into the Control file, but how do we handle dynamic-data driven occurs in the control file?

    Requires Free Membership to View

If I understand your question correctly, you are asking how to load a data file of variable-length and are trying to determine how to enter that in your control file. Well, the better choice would be to not include the actual data in the control file itself, but keep it separate in it's own data file. When listing the data to load in the control file, the INFILE parameter is set to * (e.g. INFILE *). Then you have a BEGINDATA parameter listed later to indicate the beginning of your data. If you are getting periodic data files created/downloaded from your mainframe, then just create your control file to read the data from the external file by having INFILE list the actual filename to load (e.g. INFILE 'dumpfile.txt'). The control file then would not have the actual data in it, only the parameters need to define the load.

If I've misinterpreted your question, please let me know and I?ll try again!

For More Information

This was first published in August 2001

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: