Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Execute command with loop
Top Forums Shell Programming and Scripting Execute command with loop Post 302829951 by kaushik02018 on Sunday 7th of July 2013 11:43:38 AM
Old 07-07-2013
Quote:
Originally Posted by Scrutinizer
What have you tried and where are you stucK?
Please find the code I have wrote but Problem is unable to rotate c variable second thing If i want to use 1000 value for a That means I have write 1000 numbers in for loop
as Now Used just 10 in for loop want to change about 1000

Code:
#!/bin/sh
#
#Script to test for loop
#
#
if [ $# -eq 0 ]
then
echo "Error - Number missing form command line argument"
echo "Syntax : $0 number"
echo " Use to print multiplication table for given number"
exit 1
fi
a=$1
c=20130613
for i in 1 2 3 4 5 6 7 8 9 10

do
echo "ALTER TABLE seats  ADD PARTITION ( PARTITION $c VALUES less than (DAY( `expr $a \+ $i`)));"
c = expr $c + 1;
done

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute commands parallel in a for loop ?

Hi, please can someone point me in the right direction with a shell scripting problem. I want to execute a command in a for loop and the command should be started not one-by-one meaning the for loop is waiting for the exit code , it should be started in parallel. I have a plain text file... (3 Replies)
Discussion started by: networkfre@k
3 Replies

2. Shell Programming and Scripting

loop does not execute in bash script?

I have a very basic bash shell script, which has many "while... done; for .... done" loop clauses, like the following ~~ #!/bin/bash while blablalba; do .... done < /tmp/file for line in `cat blablabla`; do grep $line /tmp/raw ; done > /tmp/1; while blablalba2; do .... done <... (2 Replies)
Discussion started by: fedora
2 Replies

3. UNIX for Dummies Questions & Answers

how to execute a while loop for 20 minutes?

I want to execute a while loop (or any other loop) for 20 minutes. I have extracted the minutes and seconds from the current system date by using the command y = `date +%M%S` How to proceed ?? (6 Replies)
Discussion started by: subhotech
6 Replies

4. Shell Programming and Scripting

Execute Loop in Telnet

hi Everyone , have a nice day #!/bin/sh ( sleep 1 echo "LOGIN:username:password;" sleep 1 while IFS= read -r line do #echo $line GET:VOUCHERDETAIL:VoucherSerialNumber,$line; >> /home/status_log done < /home/status.txt sleep 1 echo "LOGOUT;") | telnet 127.0.0.1 7021 , it... (2 Replies)
Discussion started by: Dastard
2 Replies

5. UNIX for Advanced & Expert Users

Execute while loop

Hi, I have a background process running for which I want to know the status continuously. I want to execute a WHILE loop in the command prompt so that it keeps on displaying in the screen.But, I am getting the following errors :- hyper20:~ 3> while while? while? hyper20:~ 4> while {1}... (7 Replies)
Discussion started by: shubhranshu
7 Replies

6. UNIX for Dummies Questions & Answers

For Loop to execute a command on a series of files

Hello, I have a set of input data that I split into batches using the following command: split -l 4000000 MyInput.in Split_a Once I get the split files, I run a certain command on the split files that spews an output. So far I have been doing it without a for loop. How can I translate the... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

7. UNIX for Dummies Questions & Answers

unable to execute while loop

Hi everyone. I wanted to print numbers from 1 to 5 in reverse order. For this I used the following code: #!/bin/bash x=5 while do echo $x x=`expr $x - 1` echo "" done echo "" Well but on compiling the above code, it gives the following error. ... (3 Replies)
Discussion started by: grc
3 Replies

8. Shell Programming and Scripting

How to execute a no of SELECT COUNT(*) statements using a loop

HI Unix Gurus, I have a number of SELECT count(*) statements in an input file and I want to execute it using a shell script but one by one using loop in script.... How can I do this..... (7 Replies)
Discussion started by: ustechie
7 Replies

9. Shell Programming and Scripting

How to execute a command inside a while loop?

How do we execute a command inside a while loop? (7 Replies)
Discussion started by: Little
7 Replies

10. Shell Programming and Scripting

Exit while loop on execute script

Hi, I have first script which on IR remote command event execute the second script. If the second script is executed, it display echo "timeout expired" after 10s. This works as expected. But I also want to reset timer (increase time) in case if the second script is executed again within 10s. ... (8 Replies)
Discussion started by: armatron
8 Replies

LEARN ABOUT DEBIAN

alter_trigger

ALTER 
TRIGGER(7)						   SQL Commands 						  ALTER TRIGGER(7)

NAME

       ALTER TRIGGER - change the definition of a trigger

SYNOPSIS

       ALTER TRIGGER name ON table RENAME TO newname

DESCRIPTION

       ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
       the trigger definition.

       You must own the table on which the trigger acts to be allowed to change its properties.

PARAMETERS

       name   The name of an existing trigger to alter.

       table  The name of the table on which this trigger acts.

       newname
	      The new name for the trigger.

NOTES

       The ability to temporarily enable or disable a trigger is provided by ALTER TABLE [alter_table(7)], not by  ALTER  TRIGGER,  because  ALTER
       TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.

EXAMPLES

       To rename an existing trigger:

       ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;

COMPATIBILITY

       ALTER TRIGGER is a PostgreSQL extension of the SQL standard.

SEE ALSO

       ALTER TABLE [alter_table(7)]

SQL - Language Statements					    2010-05-14							  ALTER TRIGGER(7)
All times are GMT -4. The time now is 09:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy