06-26-2008
create a shell script that calls another script and and an awk script
Hi guys
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
#!/bin/sh
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
use $4
go
print"**Changes to the table ************"
select *
from cashflow
where label = 'DEALS'
go
xxx
i also have an AWK script that takes the output produced by the script above and generates a csv file from it and sends the output to another file as CSV.
BEGIN {
count=0;
}
/^[^(]/ {
count+=1
if ( count >1 ){
for (i=1; i <= NF; i = i + 1)
printf("%s,",$i);
printf("\n");
}
}
My problem is.
1.how do i call the first script from another shell script passing in the required parameters.
2.how ho i call the AWK script after the output from above to process the file and produce a csv file.this has to be in the same script as the above.
3.my main problem is how to do the above from ONE shell script.
4.some of date being prcessed by the AWK script is in datetime format.the AWK script is seperating the day,month and year with comma.How do i make it treat 23-06-2008 as single field and not as seperate fields.
Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
2. Shell Programming and Scripting
Dear Unix and Linux users,
Good evening to all.
I'm new to this community and thank you for having an wonderful forum.
Dear members i had to create almost some 300 shell script files for a particular task.
I tried something like this....
#!usr/bin/sh
fname=epdb_jobs
for x in `cat $fname`... (3 Replies)
Discussion started by: NehaB
3 Replies
3. Shell Programming and Scripting
Hello,
I have this awk script that I want to execute by passing parameters through a shell script.
I'm a little confused. This awk script removes duplicates from an input file.
Ok, so I have a .sh file called rem_dups.sh
#!/usr/bin/sh... (4 Replies)
Discussion started by: script_op2a
4 Replies
4. Shell Programming and Scripting
hi everyone
i am trying to do this
bash> cat abc.sh
deepak()
{
echo Deepak
}
deepak
bash>./abc.sh
Deepak
so it is giving me write simply i created a func and it worked
now i modified it like this way
bash> cat abc.sh (2 Replies)
Discussion started by: aishsimplesweet
2 Replies
5. Shell Programming and Scripting
I am getting the following error while passing parameter to a shell script called within awk script. Any idea what's causing this issue and how to ix it ? Thanks
sh: -c: line 0: syntax error near unexpected token `newline'
sh: -c: line 0: `./billdatecalc.sh ... (10 Replies)
Discussion started by: Sudhakar333
10 Replies
6. Post Here to Contact Site Administrators and Moderators
Variable I have in my shell script
diff=$1$2.diff
id=$2
new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new
I could see value of $id is not passing to the awk... (0 Replies)
Discussion started by: Ashunayak
0 Replies
7. Shell Programming and Scripting
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies
8. UNIX for Dummies Questions & Answers
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff |... (1 Reply)
Discussion started by: Sarita Behera
1 Replies
9. Shell Programming and Scripting
Hi All,
I have a script which intends to create as many variables at runtime, as the number of parameters passed to it. The script needs to save these parameter values in the variables created and print them
abc.sh
----------
export Numbr_Parms=$#
export a=1
while
do
export... (3 Replies)
Discussion started by: dev.devil.1983
3 Replies
10. UNIX for Beginners Questions & Answers
I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 Replies
LEARN ABOUT DEBIAN
rt-shredder-4
rt-shredder(8) Request Tracker Reference rt-shredder(8)
NAME
rt-shredder - Script which wipes out tickets from RT DB
SYNOPSIS
rt-shredder --plugin list
rt-shredder --plugin help-Tickets
rt-shredder --plugin 'Tickets=query,Queue="general" and Status="deleted"'
rt-shredder --sqldump unshred.sql --plugin ...
rt-shredder --force --plugin ...
DESCRIPTION
rt-shredder - is script that allow you to wipe out objects from RT DB. This script uses API that RT::Shredder module adds to RT. Script
can be used as example of usage of the shredder API.
USAGE
You can use several options to control which objects script should wipeout.
OPTIONS
--sqldump <filename>
Outputs INSERT queries into file. This dump can be used to restore data after wiping out.
By default creates files <RT_home>/var/data/RT-Shredder/<ISO_date>-XXXX.sql
--object (DEPRECATED)
Option has been deprecated, use plugin "Objects" instead.
--plugin '<plugin name>[=<arg>,<val>[;<arg>,<val>]...]'
You can use plugins to select RT objects with various conditions. See also --plugin list and --plugin help options.
--plugin list
Output list of the available plugins.
--plugin help-<plugin name>
Outputs help for specified plugin.
--force
Script doesn't ask any questions.
SEE ALSO
RT::Shredder
perl v5.14.2 2013-05-22 rt-shredder(8)