10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
I have a main_script.sh which runs every day and scheduled in crontab.
in the main script i read data from config file
test.config
apple
mango
orange
main_script.sh
for i in `cat test.config`
do
if
then
echo 'Apple' (3 Replies)
Discussion started by: Master_Mind
3 Replies
2. Shell Programming and Scripting
mainpid=$$
(trap "echo timeout" SIGTERM SIGKILL SIGINT; sleep 5; kill $mainpid) &
watchdogpid=$!
sleep 10 #do something
kill $watchdogpid
I design a timeout function script
I don't see the echo "timeout" is on the screen (1 Reply)
Discussion started by: yanglei_fage
1 Replies
3. Programming
Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works:
UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` );
So now I want this... (5 Replies)
Discussion started by: barrydocks
5 Replies
4. OS X (Apple)
Hi all...
Has _below_ ever been done in UNIX shell scripting before?
(I have done this easily in Python but this is using purely the shell.)
The DEMO version IS built and has been tested.
Pre-amble...
I now need at least one control pulse for the AudioScope.sh when in PURELY audio I/O mode,... (2 Replies)
Discussion started by: wisecracker
2 Replies
5. Programming
So I have a php web application that allows updating of records. I would like to track the changes of only the fields that have changed. There are plenty of how to's that involve recreating the original row in a separate table with an additional time/date stamp column but I think this is a big... (1 Reply)
Discussion started by: barrydocks
1 Replies
6. Shell Programming and Scripting
Hi,
I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening.,
Below is... (2 Replies)
Discussion started by: cratercrabs
2 Replies
7. Shell Programming and Scripting
Hello,
from log error file of process that i's updating in append mode, i need to capture the new entries for every day.
How i can know and save only the new errors?
This it's a sample of error log file (oas report server engine)
thanks and regards
Fran (2 Replies)
Discussion started by: fran61
2 Replies
8. HP-UX
Hi, I'm totally new in Control-M and I really need some help. Here's my problem.
I need to make job X from a server trigger job Y from a different server where job X must receive a confirmation first before execution. :confused:
I really have no idea on how to do that so can you please give... (1 Reply)
Discussion started by: criphaze22
1 Replies
9. Shell Programming and Scripting
If test.ksh is successful then I have a sequence of script which needs to execute automatically. Is it possible to capture the return code to execute the next script automatically? what is better way of doing this. (4 Replies)
Discussion started by: zooby
4 Replies
10. Shell Programming and Scripting
Hello,
I need to trigger every time enter has been clicked while some one on terminal
i tried to googleit but with out result any idea ??
thanks in advance (3 Replies)
Discussion started by: AYAK
3 Replies
DROP
TRIGGER(7) SQL Commands DROP TRIGGER(7)
NAME
DROP TRIGGER - remove a trigger
SYNOPSIS
DROP TRIGGER name ON table [ CASCADE | RESTRICT ]
INPUTS
name The name of an existing trigger.
table The name (optionally schema-qualified) of a table.
CASCADE
Automatically drop objects that depend on the trigger.
RESTRICT
Refuse to drop the trigger if there are any dependent objects. This is the default.
OUTPUTS
DROP TRIGGER
The message returned if the trigger is successfully dropped.
ERROR: DropTrigger: there is no trigger name on relation "table"
This message occurs if the trigger specified does not exist.
DESCRIPTION
DROP TRIGGER will remove an existing trigger definition. To execute this command the current user must be the owner of the table for which
the trigger is defined.
EXAMPLES
Destroy the if_dist_exists trigger on table films:
DROP TRIGGER if_dist_exists ON films;
COMPATIBILITY
SQL92 There is no DROP TRIGGER statement in SQL92.
SQL99 The DROP TRIGGER statement in PostgreSQL is incompatible with SQL99. In SQL99, trigger names are not local to tables, so the command
is simply DROP TRIGGER name.
SEE ALSO
CREATE TRIGGER [create_trigger(7)]
SQL - Language Statements 2002-11-22 DROP TRIGGER(7)