Hello,
I am trying to automate loading into Oracle 8 on (Unix Solaris 2.8) from several batch jobs appended to each other in order to
run overnight or in succession.
I am fairly new to shell scripting and am not sure how to tackle this.
In the batch job outline, I have:
1. loader control file that is partly binary and also ascii format. (job.lcc)
2. This loader points to an ascii control file that has the specifics of the data that I'm loading. (job.ldctl)
3. The data file which is in ascii. (job.dat)
4. I also have an ascii journal file that reports the success of the data being loaded or not into Oracle. (job.ldjnl)
All of these files will be built and then appended together with other similar jobs and then submited as a cron or batch job.
Thanks for any ideas and suggestions.
I am trying to automate loading into Oracle 8 on (Unix Solaris 2.8) from several batch jobs appended to each other in order to
run overnight or in succession.
I am fairly new to shell scripting and am not sure how to tackle this.
In the batch job outline, I have:
1. loader control file that is partly binary and also ascii format. (job.lcc)
2. This loader points to an ascii control file that has the specifics of the data that I'm loading. (job.ldctl)
3. The data file which is in ascii. (job.dat)
4. I also have an ascii journal file that reports the success of the data being loaded or not into Oracle. (job.ldjnl)
All of these files will be built and then appended together with other similar jobs and then submited as a cron or batch job.
Thanks for any ideas and suggestions.