Home » RDBMS Server » Server Utilities » export after export
export after export [message #68950] Tue, 02 October 2001 23:24 Go to next message
Marija
Messages: 5
Registered: October 2001
Junior Member
I have to make 2 exports one after another, but the second one shouldn't happend if the first is done with errors!
My boss wants me to automate this!
I know there is a SQLCODE, but I do not know how to use it in this situation.

Thanks!
Vesna

----------------------------------------------------------------------
Re: export after export [message #68958 is a reply to message #68950] Thu, 04 October 2001 07:19 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
you can achieve this using batch file (.bat or .sh)

logic is obv'sly very simple

a) call first export using appropriate command line arguments (output appropriately directed to a logfile)

b) if the export1 is success you could always get 'Export terminated successfully without warnings' in your logfile

c) before calling your export2, you can check the file content of the logfile(of export1).
(something similar to grep command)
if it contains the string 'Export terminated successfully without warnings' then you can go ahead with next step (d) else stop process

d) call export2 with appropriate parameters

Regards
Oraboy

b)

----------------------------------------------------------------------
Previous Topic: How can alter the table
Next Topic: import & Update
Goto Forum:
  


Current Time: Fri Mar 29 03:33:57 CDT 2024