There's some way to run SO commands from a Stored Procedure? Something like SO clause of BTEQ.
I wanna run ARCMAIN from within a Stored Procedure which controls the backup process.
I think it is better to keep it clean. Run and compile the logic in bteq and bteq in Linux/unix script. In this way, the design is clear, easy to maintain and logical.
In Linux/unix, we can do all sorts of branching/looping.modularizing... and we can stuff our utilities programs inside. Most orgs have standards to be followed though that have certain restrictions .We have to toe the line :).
I think you mean to say .os command .
Tks... I also think it's better. This was my first guess. But I have no access to the operating system (for contractual issues that ar under review).
While this problem is not solved, and it may take some time, I need to seek alternatives solutions.