06-22-2015
- Show us the entire script, not just two lines from the SQL query, and show us the entire, exact diagnostic message (both in CODE tags) that you get when you run that script.
- What shell is being used to run your script?
- What operating system (including release number) are you using? If you don't know the release, show us the output from the command: uname -a (also in CODE tags).
- What operating system is running on the system where your database is running?
- What database software are you using?
Without the above basic information, we have a much very limited chance of offering any real help.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi - I am totally new to UNIX so please bear with me...
I run a java program on Win NT server to do file ftp to UNIX server.
I log in, cd, create ftp file on UNIX and quit from my java progam - all works well.
Now I want to execute a script on UNIX.
At the UNIX 'console'/'shell' (!?) you... (1 Reply)
Discussion started by: CJ Walt
1 Replies
2. Shell Programming and Scripting
I have created get_list.bat file containing following line:
dir /B /O-d >file_list.txt
I am executing ftp command from Unix box and transferring get_list.bat file to windows server.
In my next ftp command I am trying to execute this test.bat file by entering this line:
get_list
or by... (9 Replies)
Discussion started by: alx
9 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I need to execute the following unix command through my java code -
zip -e
When i execute this command from the command prompt, i am prompted for a password in the following manner -
Enter password:
Verify password:
Is it possible to provide the password inthe first command itself... (5 Replies)
Discussion started by: jacob23
5 Replies
4. Shell Programming and Scripting
Hi,
I am getting an error while executing the mail command....
It says saved letter in dead.letter even though the email id id correct .
Please do help..
Madhu (2 Replies)
Discussion started by: madhumathikv
2 Replies
5. Shell Programming and Scripting
Hi:
I have a touble with executing a variable that stores a unix command string.
The following would be excuted fine:
command='ls -l'
`echo $command`
However, the following gives me an error:
command='(uuencode file1 file1; uuencode file2 file2) | mailx email_id'
`echo... (1 Reply)
Discussion started by: sagewise
1 Replies
6. AIX
Hi Folks
I get the below error in my aix box. Im not sure if this is an AIX issue or a TWS issue. Please advice me
cbspsdb01:/opt/TWS/bin # ./conman status
exec(): 0509-036 Cannot load program ./conman because of the following errors:
0509-150 Dependent module... (6 Replies)
Discussion started by: newtoaixos
6 Replies
7. Red Hat
Hi,
I am using RHEL4 and Oracle11g , my application requires odbc connection
hence I modified ODBC.ini file and when I exceute isql commande I got the following error.
isql: error while loading shared libraries: /opt/nastel/apwmq/odbc/lib/libodbc.so.1: requires glibc 2.5 or later dynamic... (1 Reply)
Discussion started by: roopalidalvi231
1 Replies
8. Red Hat
Hi,
I am using RHEL4 and Oracle11g , my application requires odbc connection
hence I modified ODBC.ini file and when I exceute isql commande I got the following error.
isql: error while loading shared libraries: /opt/nastel/apwmq/odbc/lib/libodbc.so.1: requires glibc 2.5 or later dynamic... (4 Replies)
Discussion started by: roopalidalvi231
4 Replies
9. Shell Programming and Scripting
Hi,
I have 2 files temp1.sh and temp2.sh as follows:
===========
temp1.sh
===========
echo "session1"
sh temp2.sh
echo "exit session2 and enter session1"
=================================
=============
temp2.sh
=============
echo "session2"
sh
echo "exit session2"... (5 Replies)
Discussion started by: RP09
5 Replies
10. Solaris
Hello,
Our applications are deployed in SunOS 5.10 servers. All the team members use a same username/pwd to login to the box. Very often we face issue were we could see that weblogic server instance are KILLED and we are not able to trace who executed kill command. All team members use PUTTY to... (2 Replies)
Discussion started by: santtarius
2 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)