Sponsored Content
Full Discussion: command to give me Database
Operating Systems AIX command to give me Database Post 302081954 by sprellari on Saturday 29th of July 2006 08:07:56 AM
Old 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

how to give a variable to a command in shell script...

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 this command what would be the value...

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

Can we give multiple patterns to a sed command???

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

connecting to a database through a script...if not give an error msg

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

Give the command names

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

how to give PASSPHRASE to gpg in command line?

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

ls command to give full path to files

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

What will echo $$ command give

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

[Solved] My sed command not give me a satisfy result

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

How do I give permission for the kill command?

<?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
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)
All times are GMT -4. The time now is 05:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy