10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi,
we are running solaris 5.10 and looking for solutions to automate password resets? Plz assist.
Thanks,
Sridhar (6 Replies)
Discussion started by: chvgms
6 Replies
2. Web Development
Hello everyone...I am very new to UNIX hence needs your help in below.
i have written a script to change some configuration in property files and its working fine.but to reflect that change at the application i want to recycle WAS and ihs.i.e. run below start and stop commands at /usr/local/bin ... (2 Replies)
Discussion started by: Sanaa
2 Replies
3. Shell Programming and Scripting
i want to access database (sql script) within a unix script.
help me (2 Replies)
Discussion started by: chamaraa
2 Replies
4. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: fraizerangus
1 Replies
5. Shell Programming and Scripting
Dear Team,
I am very new to shell scripting & and presently monitoring unix boxes
I am looking for a shell script which will give me the below output
script should contain -
hostname,OS Version,CPU details, Physical Memory, Partitions Details, Network Details and Software Installed,... (5 Replies)
Discussion started by: whizkidash
5 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I'm quite limited in UNIX unfortunately for me, and need to find a solution to something thats giving me headaches every morning. We need to make daily backups of a server we have in the office every morning, as well as then FTPing the created backup files over to a specific FTP address... (3 Replies)
Discussion started by: de049
3 Replies
7. 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
8. 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
9. 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
10. Shell Programming and Scripting
Hi all,
I am trying to write a program that will automate interactive scripts that use 'pkgadd'. Easily enough I can use 'pkgask' and a response file for most of what I want to do, but unfortunately there are parts of some pkg installations that are configured to only take input from /dev/tty!!... (2 Replies)
Discussion started by: bookoo
2 Replies
SQL::Translator::Filter::Globals(3pm) User Contributed Perl Documentation SQL::Translator::Filter::Globals(3pm)
NAME
SQL::Translator::Filter::Globals - Add global fields and indices to all tables.
SYNOPSIS
# e.g. Add timestamp field to all tables.
use SQL::Translator;
my $sqlt = SQL::Translator->new(
from => 'MySQL',
to => 'MySQL',
filters => [
Globals => {
fields => [
{
name => 'modified'
data_type => 'TIMESTAMP'
}
],
indices => [
{
fields => 'modifed',
},
]
constraints => [
{
}
]
},
],
) || die "SQLFairy error : ".SQL::Translator->error;
my $sql = $sqlt->translate || die "SQLFairy error : ".$sqlt->error;
DESCRIPTION
Adds global fields, indices and constraints to all tables in the schema. The globals to add can either be defined in the filter args or
using a _GLOBAL_ table (see below).
If a table already contains a field with the same name as a global then it is skipped for that table.
The _GLOBAL_ Table
An alternative to using the args is to add a table called "_GLOBAL_" to the schema and then just use the filter. Any fields and indices
defined on this table will be added to all the tables in the schema and the _GLOBAL_ table removed.
The name of the global can be changed using a "global_table" arg to the filter.
SEE ALSO
perl(1), SQL::Translator
BUGS
Will generate duplicate indices if an index already exists on a table the same as one added globally.
Will generate duplicate constraints if a constraint already exists on a table the same as one added globally.
TODO
Some extra data values that can be used to control the global addition. e.g. 'skip_global'.
AUTHOR
Mark Addison <grommit@users.sourceforge.net>
perl v5.14.2 2012-01-18 SQL::Translator::Filter::Globals(3pm)