SQL*Loader and DCL

From: peter de roo <p.deroo_at_telecom.ptt.nl>
Date: 1996/11/01
Message-ID: <55cvm7$m35_at_hdxf02.telecom.ptt.nl>#1/1


Hello,

Our application runs under VAX-VMS on an ALPHA and works with a database of 260 Gb
For our application we need to load large truncs of binary data into the database. Using C programs this takes a while, so we are considering the usage of SQLLoad with the direct path option. To use this full automatic we have the following questions :
- How can i detect in DCL whether an SQLLoad job is terminated
  successfull or with errors
- What actions do i have to take to restore the table and it's indexes
  in an operational state and that in an automatic way. Preferably   without dropping and recreating the indexes.
- Does anybody have example-DCL for this usage.

Kindly regards
Jan Odijk Received on Fri Nov 01 1996 - 00:00:00 CET

Original text of this message