07-18-2013
Every database engine has a command line tool, but if it is not free on the host you want to use it on, you can get free JDBC jars and use xigole jisql or the like to access the data, and then a shell can examine it. Of course, you need to know the host, port, id, pw, database name, etc. to log in on any tool, and have network access, and not violate corporate standards.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello
say i have written some perl scripts , now i like to call them in my unix shell
as unix command like "more" , "ls" , "grep" so that my say perl script called "foo.pl"
will be called from every where as "foo" or "foo arg1 arg2"?
Thanks (1 Reply)
Discussion started by: umen
1 Replies
2. Shell Programming and Scripting
Hi
I am not sure how to call a perl script from a tcsh shell. do i need to set any environment variables? your help is appreciated
Thanks (1 Reply)
Discussion started by: megastar
1 Replies
3. UNIX for Dummies Questions & Answers
hi,
i want to call unix script from transformations used in informatica mapping?
can we do it in any way? Please reply ASAP.
We cant use Storep procedure transformation
Thanks in Advance
nishith (0 Replies)
Discussion started by: Nishithinfy
0 Replies
4. Shell Programming and Scripting
hi,,
i have perl scipt with line :
system('./try.sh $t $d $m');
in shell scipt try.sh i have the line:
echo $1
its not printing value of $t that i hav passed..y is it so..i am running it from apache web server (2 Replies)
Discussion started by: raksha.s
2 Replies
5. Shell Programming and Scripting
I am working on this script, but hit a bump. Looking for a little help figuring out the last part:
open(MY_FILE, $ARGV) or die
$COUNTER = 1;
$LINE = <FILE>;
while ($LINE, <FILE>) {
# Adds leading zeros for numbers 1 digit long
if ($COUNTER<10){
print "000";
}
# Adds... (2 Replies)
Discussion started by: Breakology
2 Replies
6. Shell Programming and Scripting
Hi
I m new to perl. I m trying to write a perl script that calls a bash script; does anyone have a script already that they can provide or help me out? Thanks a lot. (2 Replies)
Discussion started by: adnan786
2 Replies
7. Shell Programming and Scripting
Hi Rockers,
I hope u r dng good one. I have a one question is in unix with informatica . I need a unix script to check whether particular file exists in the folder , If it means we have a informatica server , so we can start the informatica server by accessing that file. Every week we have... (0 Replies)
Discussion started by: gurukrishnan
0 Replies
8. Shell Programming and Scripting
Hello Gurus
Can anyone please let me know how to call .profle file in perl script
When I am calling the .profile file its giving error
Shall I create unix script which has .profile command and call perl script internally (2 Replies)
Discussion started by: Pratik4891
2 Replies
9. Shell Programming and Scripting
I'm attempting to write a bash script that will create a network between virtual machines. It accepts three arguments: an RSpec that describes the network topology, and two list of machines (servers and clients).
I have a (working) Perl script that I want to call. This Perl script takes an RSpec... (6 Replies)
Discussion started by: mecaka
6 Replies
10. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT CENTOS
file-pr
file-pr(8) GNATS Internal Utilities file-pr(8)
NAME
file-pr - files incoming problem reports in GNATS database
SYNOPSIS
file-pr [ -f file | --file=file ] [ -h | --help ]
[ -V | --version ] [ -H host | --host=host ]
[ -P port | --port=port ] [ -v user | --user=user ]
[ -w password | --passwd=password ]
[ -d databasename | --database=databasename ]
DESCRIPTION
file-pr files incoming Problem Reports in the GNATS database, sends acknowledgments to approriate parties and logs database activity.
file-pr assigns the Problem Report an identification number and then files it in the GNATS database either under the category specified in
the Category field of the PR, or under the default category if the Category field is nonexistent or contains an invalid category name.
For the default GNATS configuration, the person responsible for that category and the person responsible for the submitter site where the
PR originated receive a copy of the PR in its entirety. Optionally, the originator of the PR receives an acknowledgment that the PR ar-
rived and was filed
OPTIONS
-f file, --filename=file
Accept file as input; if this option is not present, standard input is used.
-h, --help
Display usage summary for file-pr.
-V, --version
Display version number for file-pr.
-d, --database
Specifies the database to which the PR is to be submitted. If no database is specified, the database named default is assumed.
This option overrides the database specified in the GNATSDB environment variable.
GNATS network options:
-H, --host
Hostname of the GNATS server.
-P, --port
The port that the GNATS server runs on.
-v, --username
Username used to log into the GNATS server.
-w, --passwd
Password used to log into the GNATS server.
ENVIRONMENT VARIABLES
The GNATSDB environment variable is used to determine which database to use. For a local database, it contains the name of the database to
access.
For network access via gnatsd, it contains a colon-separated list of strings that describe the remote database, in the form
server:port:databasename:username:password
Any of the fields may be omitted, but at least one colon must appear; otherwise, the value is assumed to be the name of a local database.
If GNATSDB is not set, it is assumed that the database is local and that its name is default.
SEE ALSO
Keeping Track: Managing Messages With GNATS (also installed as the GNU Info file gnats.info)
databases(5), dbconfig(5), delete-pr(8), edit-pr(1) file-pr(8), gen-index(8), gnats(7), gnatsd(8), mkcat(8), mkdb(8), pr-edit(8), query-
pr(1), queue-pr(8), send-pr(1).
COPYING
Copyright (c) 1993, 1999, 2003, Free Software Foundation, Inc.
Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are
preserved on all copies.
Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that the
entire resulting derived work is distributed under the terms of a permission notice identical to this one.
Permission is granted to copy and distribute translations of this manual into another language, under the above conditions for modified
versions, except that this permission notice may be included in translations approved by the Free Software Foundation instead of in the
original English.
GNATS August 2003 file-pr(8)