I would like to know if the dbisql command that I ran succeeded or not. When I try to check using %errorleve%, I don't see it change for success or failure. What is the preferred method to find that out. I am trying to kick off the backup using a script. But, I would like to know for any unpredictable error. Any help is greatly appreciated.
asked 25 May '12, 10:31
The documentation includes the following in the Remarks section:
This also might be applicable:
answered 25 May '12, 13:35
In addition to Graham's suggestions, you might also use the DBBACKUP utility directly if your script does not contain more than the BACKUP statement.
Like all other database utilities, DBBACKUP returns exit codes that you can check for:
answered 26 May '12, 10:05