04-14-2009
thanks a lot...it is working now...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am new to unix as well as shell programming.
Any body can provide me a simple shell script which should copy/transfer/fetch a file(using FTP)from remote server to local system.and it should log the details when it was fetched.If there is any error,the error msg should log in log... (1 Reply)
Discussion started by: Mar1006
1 Replies
2. Shell Programming and Scripting
I M TRYING TO DO SUM THING I M A NEW LEARNER TO SHELL SCRIPT PLZZZ HELP ME FRIENDS
I M TRY TO DO SUM THING C IT AND HELP ME
First open a .ctl file
Copy the file into temp file
Add A EXTRA FIELD “ext_date” with keeping value “##**&&”
EG- EXT_DATE CONSTANT"******"
Each time... (2 Replies)
Discussion started by: kulbir
2 Replies
3. Shell Programming and Scripting
Hi,
I am new to unix and using linux 7.2. I would like to create a script that would make it easyer for me to run my java programms. At the moment I have to type java myJavaprogram
I am trying to write a script that will allow me to type something like this "myscript myJavaprogram" or maybe... (4 Replies)
Discussion started by: cmitulescu
4 Replies
4. Shell Programming and Scripting
This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord
but only one record is getting wrote in DB.... Please advise ASAP...:confused:
function InsertFtg
{
FTGSTR=""
echo "Saurabh is GREAT $#"
let... (2 Replies)
Discussion started by: omkar.sonawane
2 Replies
5. Shell Programming and Scripting
Hello Friends,
I am writing a shell script which will grab a file if it exists and copies it to another folder and will append with current date. I have written but gives me error, plz help:
--------------------------------------------
#!/usr/bin/sh
source=/home/dev4rice/naveen/test1... (4 Replies)
Discussion started by: ganesh123
4 Replies
6. Shell Programming and Scripting
Hello forum members,
I have to redirect a output of command into a text file inside a script file but iam getting an errors.so please see below script and suggest me for corrections.
#!/bin/ksh
read IP_ADD
echo nslookup $IP_ADD 2>&1| tee log1.txt
cat /amex/gcst/siva/Testr/log1.txt... (6 Replies)
Discussion started by: rajkumar_g
6 Replies
7. Shell Programming and Scripting
Hi ,
I am in need of simple shell script that has one input file containing some words
Input file 1 :
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****... (6 Replies)
Discussion started by: kmanjuna
6 Replies
8. Shell Programming and Scripting
Hello,
I am running openmediavault on my Raspberry and I would like to use it as a backup FTP server of snapshots taken from my IP cams.
So I get the network recorder to upload every 3 seconds a snapshot to the Raspberry. Everything works perfectly.
I would need now a simple script that... (5 Replies)
Discussion started by: dcaccount
5 Replies
9. Shell Programming and Scripting
Hello,
I need to create one very simple shell script that checks if the first character of the file ./pump.txt is 0 and in that case gives a message.
If the first character is instead 1, it does give a different message.
I have written:
irr= head -c 1 ./pump.txt
if ]; then
echo... (4 Replies)
Discussion started by: dcaccount
4 Replies
10. UNIX for Beginners Questions & Answers
Hello, Trying to look
vgcheck() {
lsvg -o|
while read vg; do
lsvg -p $vg|grep Missing
if ;then
echo "OK:PASSED"
else
echo "FAIL"
... (3 Replies)
Discussion started by: kvosu
3 Replies
LEARN ABOUT REDHAT
delete
DELETE(7) SQL Commands DELETE(7)
NAME
DELETE - delete rows of a table
SYNOPSIS
DELETE FROM [ ONLY ] table [ WHERE condition ]
INPUTS
table The name (optionally schema-qualified) of an existing table.
condition
This is an SQL selection query which returns the rows which are to be deleted.
Refer to the SELECT statement for further description of the WHERE clause.
OUTPUTS
DELETE count
Message returned if items are successfully deleted. The count is the number of rows deleted.
If count is 0, no rows were deleted.
DESCRIPTION
DELETE removes rows which satisfy the WHERE clause from the specified table.
If the condition (WHERE clause) is absent, the effect is to delete all rows in the table. The result is a valid, but empty table.
Tip: TRUNCATE [truncate(7)] is a PostgreSQL extension which provides a faster mechanism to remove all rows from a table.
By default DELETE will delete tuples in the table specified and all its sub-tables. If you wish to only update the specific table men-
tioned, you should use the ONLY clause.
You must have write access to the table in order to modify it, as well as read access to any table whose values are read in the condition.
USAGE
Remove all films but musicals:
DELETE FROM films WHERE kind <> 'Musical';
SELECT * FROM films;
code | title | did | date_prod | kind | len
-------+---------------------------+-----+------------+---------+-------
UA501 | West Side Story | 105 | 1961-01-03 | Musical | 02:32
TC901 | The King and I | 109 | 1956-08-11 | Musical | 02:13
WD101 | Bed Knobs and Broomsticks | 111 | | Musical | 01:57
(3 rows)
Clear the table films:
DELETE FROM films;
SELECT * FROM films;
code | title | did | date_prod | kind | len
------+-------+-----+-----------+------+-----
(0 rows)
COMPATIBILITY
SQL92
SQL92 allows a positioned DELETE statement:
DELETE FROM table WHERE
CURRENT OF cursor
where cursor identifies an open cursor. Interactive cursors in PostgreSQL are read-only.
SQL - Language Statements 2002-11-22 DELETE(7)