09-04-2009
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
10 More Discussions You Might Find Interesting
1. HP-UX
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 (0 Replies)
Discussion started by: konquistador
0 Replies
2. UNIX for Dummies Questions & Answers
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 (0 Replies)
Discussion started by: konquistador
0 Replies
3. Shell Programming and Scripting
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 Replies)
Discussion started by: konquistador
2 Replies
4. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: new2ss
1 Replies
5. Shell Programming and Scripting
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 )... (4 Replies)
Discussion started by: qwerty007
4 Replies
6. Shell Programming and Scripting
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? (2 Replies)
Discussion started by: laknar
2 Replies
7. Programming
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... (7 Replies)
Discussion started by: yifangt
7 Replies
8. UNIX and Linux Applications
#!/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... (3 Replies)
Discussion started by: eazyeddie22
3 Replies
9. Shell Programming and Scripting
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... (4 Replies)
Discussion started by: Lucky Ali
4 Replies
10. Shell Programming and Scripting
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(... (3 Replies)
Discussion started by: ajayram_arya
3 Replies
LEARN ABOUT PLAN9
dh_perl
DH_PERL(1) Debhelper DH_PERL(1)
NAME
dh_perl - calculates Perl dependencies and cleans up after MakeMaker
SYNOPSIS
dh_perl [debhelperoptions] [-d] [librarydirs...]
DESCRIPTION
dh_perl is a debhelper program that is responsible for generating the ${perl:Depends} substitutions and adding them to substvars files.
The program will look at Perl scripts and modules in your package, and will use this information to generate a dependency on perl or
perlapi. The dependency will be substituted into your package's control file wherever you place the token ${perl:Depends}.
dh_perl also cleans up empty directories that MakeMaker can generate when installing Perl modules.
OPTIONS
-d In some specific cases you may want to depend on perl-base rather than the full perl package. If so, you can pass the -d option to make
dh_perl generate a dependency on the correct base package. This is only necessary for some packages that are included in the base
system.
Note that this flag may cause no dependency on perl-base to be generated at all. perl-base is Essential, so its dependency can be left
out, unless a versioned dependency is needed.
-V By default, scripts and architecture independent modules don't depend on any specific version of perl. The -V option causes the current
version of the perl (or perl-base with -d) package to be specified.
library dirs
If your package installs Perl modules in non-standard directories, you can make dh_perl check those directories by passing their names
on the command line. It will only check the vendorlib and vendorarch directories by default.
CONFORMS TO
Debian policy, version 3.8.3
Perl policy, version 1.20
SEE ALSO
debhelper(7)
This program is a part of debhelper.
AUTHOR
Brendan O'Dea <bod@debian.org>
11.1.6ubuntu2 2018-05-10 DH_PERL(1)