Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: create a shell script that calls another script and and an awk script
Top Forums Shell Programming and Scripting create a shell script that calls another script and and an awk script Post 302209129 by magikminox on Thursday 26th of June 2008 02:50:12 AM
Old 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

Query Oracle tables and return values to shell script that calls the query

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

To Create shell script files from a shell script

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

want to pass parameters to awk script from shell script

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

Call shell script function from awk script

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

Calling shell script within awk script throws error

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

Unable to pass shell script parameter value to awk command in side the same script

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

Unable to pass shell script variable to awk command in same shell script

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

Passing shell script parameter value to awk command in side the script

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

Shell script to create runtime variables based on the number of parameters passed in the script

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

Shell script to call and sort awk script and output

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 CENTOS

isql

isql(1) 						       UnixODBC manual pages							   isql(1)

NAME

       isql, iusql - unixODBC command-line interactive SQL tool

SYNOPSIS

       isql DSN [USER [PASSWORD]] [options]

DESCRIPTION

       isql  is  a  command  line  tool which allows the user to execute SQL in batch or interactively. It has some interesting options such as an
       option to generate output wrapped in an HTML table.

       iusql is the same tool with built-in Unicode support.

ARGUMENTS

       DSN    The Data Source Name, which should be used to make connection to the database.  The data source is looked for in	the  /etc/odbc.ini
	      and $HOME/.odbc.ini files in that order, with the latter overwriting the former.

       USER   Specifies the database user/role under which the connection should be made.

       PASSWORD
	      Password for the specified USER.

OPTIONS

       -b     Run isql in non-interactive batch mode. In this mode, the isql processes its standard input, expecting one SQL command per line.

       -dDELIMITER
	      Delimits columns with delimiter.

       -xHEX  Delimits	columns with HEX, which is a hexadecimal code of the delimiting character in the format 0xNN - i.e. 0x09 for the TAB char-
	      acter.

       -w     Format the result as HTML table.

       -c     Output the names of the columns on the first row. Has any effect only with the -d or -x options.

       -mNUM  Limit the column display width to NUM characters.

       -lLOCALE
	      Sets locale to LOCALE.

       -q     Wrap the character fields in double quotes.

       -3     Use the ODBC 3 calls.

       -n     Use the newline processing.

       -e     Use the SQLExecDirect instead of Prepare.

       -k     Use SQLDriverConnect.

       -v     Turn on the verbose mode, where the errors are fully described. Useful for debugging.

       --version
	      Prints the program version and exits.

COMMANDS

       This section briefly describes some isql runtime commands.

       help
	      List all tables in the database.

       help table
	      List all columns in the table.

       help help
	      List all help options.

EXAMPLES

       $ isql WebDB MyID MyPWD -w -b < My.sql

       Connects to the WebDB as user MyID with password MyPWD, then execute the commands in the My.sql file and returns  the  results  wrapped	in
       HTML table.  Each line in My.sql must contain exactly 1 SQL command, except for the last line, which must be blank (unless the -n option is
       specified).

FILES

       /etc/odbc.ini
	      System-wide DSN definitions. See odbc.ini(5) for details.

       $HOME/.odbc.ini
	      User-specific DSN definitions. See odbc.ini(5) for details.

SEE ALSO

       odbcinst(1), odbc.ini(5)

AUTHORS

       The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of  contributors
       see the AUTHORS file.

COPYRIGHT

       unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file.

version 2.3.1							  Tue 25 Jun 2013							   isql(1)
All times are GMT -4. The time now is 07:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy