Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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 musing on the Monastery: (8)
As of 2014-07-24 06:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (158 votes), past polls