Automating A Perl Script over a database Post: 302350534

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Automating A Perl Script over a database Post 302350534 by fraizerangus on Friday 4th of September 2009 06:48:44 AM

Old

09-04-2009

Registered User

Automating A Perl Script over a database

Dear Scripting Gods

I've never done shell scripting before and have only recently got to grips with Perl, so apologies for my naivity. I've written a perl program which takes in two files as arguments (these are text documents which take in the information I need) The perl program spits out a number, I need to automate this process so it automatically selects the two files for the Perl program in a large database (which consists of these two sets of files), runs the Perl program and saves the result in an array of some sort?! any code, pointers or advice would be very much appreciated! many thanks in advance!

best wishes

Dan

fraizerangus

View Public Profile for fraizerangus

Find all posts by fraizerangus

10 More Discussions You Might Find Interesting

1. HP-UX

Automating Database scripts in UNIX

Hi everybody, can someone please suggest me how to implement the running of SQL table scripts(.sql) at a specific time automatically in UNIX ?Thanks

2. UNIX for Dummies Questions & Answers

Automating Database scripts in UNIX

Hi everybody, can someone please suggest me how to implement the running of SQL table scripts(.sql) at a specific time automatically in UNIX ?Thanks

3. Shell Programming and Scripting

Automating Database scripts in UNIX

Hi everybody, can someone please suggest me how to implement the running of SQL table scripts(.sql) at a specific time automatically in UNIX ?Thanks

4. Shell Programming and Scripting

Automating back up of database tables

Hi all, i would like to set a cronjob to back up my db tables. I have written the par file, i would like to know how can i execute a exp command in a shell script. my par file userid=admin/password file=backup.dmp log=backupLOG.log tables= (Tables 1, Tables 2)My cron job script will be...

5. Shell Programming and Scripting

[Perl] script -database

Welcome. I am writing a perl script. I have to design a database consisting of a single table (any subject) saved in a text file. (I make it vi command name and I am giving permission chmod u + x?) The table should contain at least four columns, including a column containing the ID (serial number )...

6. Shell Programming and Scripting

Perl script to connect to database using JDBC driver?

How to connect to SQL Server database from perl script using JDBC driver? ---------- Post updated at 05:33 PM ---------- Previous update was at 05:07 PM ---------- i have sqljdbc.jar file. by setting the class path how can i connect to the database using perl script?

7. Programming

Help with mySQL database by perl script

Hello; I was trying to set up a mysql database using following script, but never went through. The code seems fine without any syntax error as I tested it: perl -c Brapa0101-db.pl Brapa0101-db.pl syntax OKHowever, whenever I run it, an error message was tossed out: DBD::mysql::st execute...

8. UNIX and Linux Applications

SQL database call into Multidimensional Array using Perl Script

#!/usr/local/bin/perl use DBI; use File::Copy; use Time::Local; use Data::Dumper; -Comments Describing what I'm doing-------------- -I'm pulling information from a database that has an ID and Name. They are separated by a space and I'm trying to load them into a multidimensional array so as...

9. Shell Programming and Scripting

automating a perl script

Hi, I have a perl script that takes in 2 numerical values as ARGV. perl script.pl parameter1 num1 num2 in my case I have 1000's of num1 and num2. I can have them in separate files. Please let me know how to automate this run using shell scripting or using awk, so that I don't have to...

10. Shell Programming and Scripting

Perl script database date convertion

Need assistance Below script get the output correctly I want to convert the date format .Below is the output . Any idea ? #!/usr/bin/perl -w use DBI; # Get a database handle by connecting to the database my $db = DBI->connect(...

LEARN ABOUT DEBIAN

devel::loaded

Devel::Loaded(3pm)					User Contributed Perl Documentation					Devel::Loaded(3pm)

NAME

       Loaded - Post-execution dump of loaded modules

SYNOPSIS

	   perl -MDevel::Loaded -Sc programname 2>/dev/null

DESCRIPTION

       The Devel::Loaded module installs an at-exit handler to generate a dump of all the module files used by a Perl program.	If used in
       conjunction with a perl -c, you find those files loaded in at compile time with "use".  If you are willing to wait until after the program
       runs, you can get them all.

EXAMPLES

       This is compile-time only:

	   $ perl -MDevel::Loaded -S -c perldoc 2>/dev/null
	   /usr/local/devperl/lib/5.00554/Exporter.pm
	   /usr/local/devperl/lib/5.00554/strict.pm
	   /usr/local/devperl/lib/5.00554/vars.pm
	   /usr/local/devperl/lib/5.00554/i686-linux/Config.pm
	   /usr/local/devperl/lib/5.00554/Getopt/Std.pm

       This will also catch run-time loads:

	   #!/usr/bin/perl
	   use Devel::Loaded;
	   ...

SEE ALSO

       The plxload and the pmload programs, which use this technique.

AUTHORS and COPYRIGHTS
       Copyright (C) 1999 Tom Christiansen.

       Copyright (C) 2006-2008 Mark Leighton Fisher.

       This is free software; you can redistribute it and/or modify it under the terms of either: (a) the GNU General Public License as published
       by the Free Software Foundation; either version 1, or (at your option) any later version, or (b) the Perl "Artistic License".  (This is the
       Perl 5 licensing scheme.)

       Please note this is a change from the original pmtools-1.00 (still available on CPAN), as pmtools-1.00 were licensed only under the Perl
       "Artistic License".

perl v5.10.1							    2010-02-22							Devel::Loaded(3pm)