Sorry for the confusion. Actually our file name will have datetime for e.g Trigger_09122014103030.done.
I am creating script which will wait until this file appears. Since this file is datetime appended, I can not give exact file in while loop(while running daily), that's reason the I am trying to check if the file name with Trigger*.done exists.
Command :-
When I add the 'Trigger_09122014103030.done' in the mentioned source location (when script is in while loop) it does not come out of the while loop
But when I add 'Trigger*.done' it comes out of the while loop. I think 'while' command searches for the exact file name
I'm trying to figure out how to build a small shell script that will find old .shtml files in every /tgp/ directory on the server and delete them if they are older than 10 days...
The structure of the paths are like this:
/home/domains/www.domain2.com/tgp/
/home/domains/www.domain3.com/tgp/... (1 Reply)
I'm trying to do a simple if statement that tests if a filename exists with a user specified string.
So say I have these files:
Assigned_1day_after_due_chuong
Assigned_1day_after_due_gallen
Assigned_1day_after_due_heidenre
and i'm running a script and want to know if a... (6 Replies)
i have a
filename_1=file1.dat
filename_2=file2.dat
i want to pass the filename in a loop
for((i=1;i<=2;i++)
do
awk{print $1} $filename_$i.dat
done
how should i pass the filename (2 Replies)
I'm sure this is by design, but using something like
for f in dir/*
do echo $f
done
produces unexpected (to me) results if run against an empty directory. I'd have expected it to not execute the loop, but it actually calls it with f set to 'dir/*'.
Now I know that I'm trying to protect... (2 Replies)
hi
here is my script
set -vx
b=`cat /info_d05/visage/SrcFiles/Customer_Master/Log_Files/last_date.txt`
for name in /info_d05/visage/SrcFiles/Customer_Master/Input_Files/*
do
fname=`basename $name`
p=`$fname|cut -d"_" -f6|sed 's/\(.*\)....../\1/'`
if
then
cp... (6 Replies)
Practice folder contains many files and im interested in extracting file which starts with abc* ghi* xyz* . I need to do variety of operations for different files. if file starts with xyz* then i need to move to some destination otherwise some other destination. I am not able to make wildcard... (15 Replies)
In several scripts that process files matched by name pattern I needed to add a check for file existence. Just to illustrate let's say I need to process all N??? files:
/tmp$ touch N100 N101
/tmp$ l ?10
-rw-rw-r-- 1 moss group 0 Apr 19 11:22 N100
-rw-rw-r-- 1 moss group ... (10 Replies)
Hi,
I have a variable returned from Oracle SQL Function which holds file names.
I would like to test if all the file names mentioned in the string exists in a directory. If all the files exists print "exists", even if one file does not exists print "Does not exists".
e.g.
... (3 Replies)
Hi,
This has been pestering me for quite a while, any help will be highly appreciated
The current directory has a file with below name
npidata_20050523-20171210.csv
The below wildcard matched the above file
ls -ltr npidata_????????-201712??.csv
But when the part '201712' is put... (6 Replies)
Discussion started by: zulfi123786
6 Replies
LEARN ABOUT REDHAT
drop_trigger
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)