06-19-2017
Did you compare the working directory when "executing alone" to when "calling from script"? And the PATH variable? You might want to use absolute paths.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
in a xen environment , i see a lot op dropped packets via netstat -i
Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this?
I guess i have a xen issue of some sort,... (1 Reply)
Discussion started by: progressdll
1 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
3. Shell Programming and Scripting
All, I need to write an unix shell script which inserts some records into a file located in remote servers.
* Get the input from the user and insert according the first row. It should be in ascending order.
123451,XA,ABA
123452,XB,ABB
123453,XC,ABC
123455,XE,ABE
123456,XF,ABF
123458,XG,ABG... (2 Replies)
Discussion started by: techychap
2 Replies
4. SuSE
I have deleted a database. I restored it again with a backup.
Now we lost some data of two days.
Is it possible to restore this lost data? (5 Replies)
Discussion started by: Eastme
5 Replies
5. Ubuntu
This is the mistake that i've done :
First of all go to /etc/apt/sources.list folder from terminal or using file manager ...
than copy the content of sources.list in to your adequate source.list.
Create a file named sources.list.bt and paste the same content
In the end open the... (0 Replies)
Discussion started by: dud3
0 Replies
6. News, Links, Events and Announcements
Fedora and openSUSE will replace MySQL with MariaDB:
Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet
The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Discussion started by: figaro
7 Replies
7. Shell Programming and Scripting
Hi Friends,
I looking for the script for the count of the records in table.
and then it's containg the zero records then should get abort.
and should notify us through mail.
Can you please help me out in this area i am lacking. (5 Replies)
Discussion started by: victory
5 Replies
8. UNIX for Advanced & Expert Users
HI Team
Is there a way to track which user dropped the table in Teradata ?
Please share the query or approach .
Thanks (0 Replies)
Discussion started by: Perlbaby
0 Replies
9. Shell Programming and Scripting
Hi,
I want to read multiple records from oracle database table and then based on each record I need to do some file modifications in UNIX.
I'm not sure how do I process each record from DB in UNIX.Below is the code snippet.
sqlplus user/pwd@DEV
for i IN (select * from table)
loop
-- for... (2 Replies)
Discussion started by: prats_7678
2 Replies
LEARN ABOUT CENTOS
drop_foreign_table
DROP FOREIGN
TABLE(7) PostgreSQL 9.2.7 Documentation DROP FOREIGN TABLE(7)
NAME
DROP_FOREIGN_TABLE - remove a foreign table
SYNOPSIS
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it.
PARAMETERS
IF EXISTS
Do not throw an error if the foreign table does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of the foreign table to drop.
CASCADE
Automatically drop objects that depend on the foreign table (such as views).
RESTRICT
Refuse to drop the foreign table if any objects depend on it. This is the default.
EXAMPLES
To destroy two foreign tables, films and distributors:
DROP FOREIGN TABLE films, distributors;
COMPATIBILITY
This command conforms to the ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command,
and apart from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER FOREIGN TABLE (ALTER_FOREIGN_TABLE(7)), CREATE FOREIGN TABLE (CREATE_FOREIGN_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP FOREIGN TABLE(7)