07-29-2006
You could use the command getDatabaseInformatinAMagicalWay (pun intended). Different databases have very different commands and paths. They also have different definitions of concepts like "size".
You must have some idea regarding whether this is a DB2 system, an Oracle system, MySQL, Postgres and so on. If you do not, it will be difficult to help you.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi all...
I am executing a comman in a shell script but the command needs a user input of character 'y' as input so it stops in between...may i know is there is any way of giving that character as input in the shell script itself???...thanks in advance.... (6 Replies)
Discussion started by: santy
6 Replies
2. Shell Programming and Scripting
if i give dir=/tmp/${0##*/}
what would b the value stored in dir ..i'm more concerned about the 0##*/ part.. (1 Reply)
Discussion started by: suri
1 Replies
3. Shell Programming and Scripting
HI,
I want to know can multiple pattern be given inside a sed statement..
Input:
aa_bb_cc.Mar-22-2007
cc_dd_ee.Mar-21-2007
aa_1002985_952.xml
aa_bb_032207.txt
aa_bb_cc_10002878.dat
Output:
aa_bb_cc
cc_dd_ee
aa.xml
aa_bb.txt
aa_bb_cc.dat (6 Replies)
Discussion started by: kumarsaravana_s
6 Replies
4. UNIX for Dummies Questions & Answers
Hello ,
i have a problem in writing the shell script..
i have a script already written n just need to make a change in which when the script is not able to connect to the database ..it should print an error msg on the screen.
I have already seen previous posts on how to connect to the... (3 Replies)
Discussion started by: sommer_queen
3 Replies
5. UNIX for Dummies Questions & Answers
Hiii,
I have a requiremnt like this----
Please provide the current sever capacity and the % of utilization for each of the servers used by your respective applications.
Also please provide the list of applications running on each of the unix server
can you please help me out in this. (2 Replies)
Discussion started by: namishtiwari
2 Replies
6. UNIX for Dummies Questions & Answers
Hello sir,
I am using "gpg" command to encrypt a file.
We generally do it :-
then it asks us for :-
I want to know how to give this Passphrase in the command line itself !!!I did read the man page but couldnt make out what is the option for it.Can u please help me out !!! (2 Replies)
Discussion started by: nsharath
2 Replies
7. Red Hat
How can i perform a ls or other command to list the full paths of files from a ls?
Looked through the man page for ls, no luck
$ cd /tmp/
$ ls -l
total 6
drwx------ 2 root root 4096 Nov 7 2008 keyring-7b5rMv
drwx------ 2 bcr bcr 4096 Dec 7 2007 keyring-cGhir8
$
I'd be looking for... (1 Reply)
Discussion started by: brendan76
1 Replies
8. UNIX for Dummies Questions & Answers
Hi
I tried giving the following command
echo $$a
I got an output like 32178a
Can some one please explain why echo $$ is returning 32178
Thanks in advance (6 Replies)
Discussion started by: Sri3001
6 Replies
9. Shell Programming and Scripting
This is my command
echo "Test" | sed -f <(sed -e 's/.*/s,&,gI/' mydic)
In mydic file,containing 2 columns delimit by comma (,)
a,AlphabetA
.
.
.
e,AlphabetE
.
.
s,AlphabetS
.
t,AlphabetT
test,testedd
.
.
zebra,zebraaaa
The expect result is testedd (0 Replies)
Discussion started by: Runicer
0 Replies
10. UNIX for Beginners Questions & Answers
<?php
$comando = "kill -9 3104";
$output = shell_exec($comando);
?>
I am running this web page, but it does not execute the command, in the log file it looks like this:
sh: 1: kill: Operation not permitted
How do I give permission to execute the command? (1 Reply)
Discussion started by: Rodrigo_Bueno
1 Replies
LEARN ABOUT REDHAT
drop_database
DROP
DATABASE(7) SQL Commands DROP DATABASE(7)
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
INPUTS
name The name of an existing database to remove.
OUTPUTS
DROP DATABASE
This message is returned if the command is successful.
DROP DATABASE: cannot be executed on the currently open database
You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this
command again.
DROP DATABASE: may not be called in a transaction block
You must finish the transaction in progress before you can call this command.
DESCRIPTION
DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed
by the database owner (usually the user that created it).
DROP DATABASE cannot be undone. Use it with care!
NOTES
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
[dropdb(1)], which is a wrapper around this command, instead.
Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.
COMPATIBILITY
SQL92
DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.
SQL - Language Statements 2002-11-22 DROP DATABASE(7)