Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

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.


Comment on Re: Automating SPROC execution
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://696690]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2014-12-25 21:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (163 votes), past polls