Running Operating System Command from a Stored Procedure

Database

Running Operating System Command from a Stored Procedure

Hi there!

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.

Tags (1)
2 REPLIES
Enthusiast

Re: Running Operating System Command from a Stored Procedure

My suggestion:

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 .

Re: Running Operating System Command from a Stored Procedure

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.