Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://696690]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2022-08-08 11:23 GMT
Find Nodes?
    Voting Booth?

    No recent polls found