10-02-2009
What you are trying to achieve is indeed not new. The implementation is dependent on the database you will be using. Your question is however very general and google would be good starting point.
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 OPENDARWIN
locate
LOCATE(1) BSD General Commands Manual LOCATE(1)
NAME
locate -- find files
SYNOPSIS
locate [-d dbpath] pattern
DESCRIPTION
locate searches a database for all pathnames which match the specified pattern. The database is recomputed periodically, and contains the
pathnames of all files which are publicly accessible.
Shell globbing and quoting characters (``*'', ``?'', ``'', ``['' and ``]'') may be used in pattern, although they will have to be escaped
from the shell. Preceding any character with a backslash (``'') eliminates any special meaning which it may have. The matching differs in
that no characters must be matched explicitly, including slashes (``/'').
As a special case, a pattern containing no globbing characters (``foo'') is matched as though it were ``*foo*''.
Options:
-d dbpath
Sets the list of databases to search to dbpath which can name one or more database files separated by ``:'', an empty component in the
list represents the default database. The environment variable LOCATE_PATH has the same effect.
EXIT STATUS
locate exits with a 0 if a match is found, and >0 if no match is found or if another problem (such as a missing or corrupted database file)
is encountered.
FILES
/var/db/locate.database Default database
/usr/libexec/locate.updatedb Script to update database.
SEE ALSO
find(1), fnmatch(3), weekly.conf(5)
Woods, James A., "Finding Files Fast", ;login, 8:1, pp. 8-10, 1983.
HISTORY
The locate command appeared in 4.4BSD.
BSD
April 5, 2003 BSD