Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: Automating SPROC execution

by amarquis (Curate)
on Jul 10, 2008 at 13:18 UTC ( #696690=note: print w/replies, xml ) Need Help??

in reply to Automating SPROC execution

In general, searching for a script that completes the whole task you want done isn't going return results. Instead, I'd plan it out and focus on particular parts of the problem, and search on those. In your case you want to:

  • Connect to your database
  • Find files in several directories
  • Open those files once found
  • Perform a substitution
  • And finally, execute the SQL statements found

My suggestion would be to start trying to build these pieces (maybe after searching on them as prepwork), and ask here about your specific roadblock if you encounter one. Provide code! Or, if you don't know where to start on a particular piece, say so here and I'm sure somebody will give you a jumping off point.

Replies are listed 'Best First'.
Re^2: Automating SPROC execution
by Anonymous Monk on Jul 10, 2008 at 13:33 UTC
    start to build the pieces? He already has been given the pieces, see he past posts on stored pro cedures/sprocs

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://696690]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2017-10-18 09:52 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (243 votes). Check out past polls.