06-16-2008
one more problem in the same code
I have further a problem with my code.
. perf.env
cd $QRY_DIR
for SHELL_FILE in sql1 sql2
do
export SNAME=$SHELL_FILE
${SCRIPT_DIR}/perf_qry.sh ${SPOOL_DIR} ${DB_ENVNAME} ${NAME}
RC=$(expr ${RC:-0} + $? )
if [ $RC == 0 ]
then
sel1='/selected/{p;q;}'
sel2='/Elapsed/{p;q;}'
for i in *.txt
do
TZ=`date +%Z` ; a=`date +%d-%b-%y`
echo $a >$i_1
echo 1 >>$i_1
sed -n $sel1 $i >>$i_1
sed -n $sel2 $i >>$i_1
awk '/rows selected/ { $0=$1 } /Elapsed/ { split($2, t, ":");$0=3600*t[1]+60*t[2]+t[3] }{ out=out sprintf("%s%s",NR==1?"":",","\047"$0"\047") }END{ print(""out"") }' $i_1>$i_1_r
done
fi
done
exit $RC
I am getting error
unknown echo command....
and also while printing the out I do not want single quotes but need the fields seperated by commas only.
And also I want to sqlldr user/pwd control=f1.ctl data=$i_1_r (i.e I want the $i_1_r files to be loaded to database)
Please help me ..
Last edited by ran16; 06-16-2008 at 01:09 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want group to run one of my unix script as me . I when the script is run it should have my permission's not the group .
I tried this :
1.Have a file called y.ksh
cat y.ksh
echo $LOGNAME >ak_test
2.Output file has this permission
-rwx------ ak_test
3.Then I chnaged... (7 Replies)
Discussion started by: akrathi
7 Replies
2. UNIX for Dummies Questions & Answers
I have a directory. To this directory, for Group bits combination, it is showing as 's'. Which I found out, it means "Set User ID on execution mode". Within this directory I am not able to create subfolder.
Does it mean, only the Owner of this directory will be able to create subdirectories &... (5 Replies)
Discussion started by: videsh77
5 Replies
3. Shell Programming and Scripting
Suppose that you want to mostly not echo commands inside your script during execution (e.g. to not bog the user down with details that they do not care about) but that there is the occaisional script line that you would like to echo before you execute it.
Is there an elegant way to achieve this?... (3 Replies)
Discussion started by: fabulous2
3 Replies
4. Shell Programming and Scripting
Hi,
I have a shell script with code
. perf.env
cd $QRY_DIR
for SHELL_FILE in sql1
do
export SNAME=$SHELL_FILE
${SCRIPT_DIR}/perf_qry.sh ${SPOOL_DIR} ${DB_ENVNAME} ${NAME} &
RC=$(expr ${RC:-0} + $? )
sleep 60
if
then
echo sysdate>test1
echo query1.txt>>test1
grep -i... (0 Replies)
Discussion started by: ran16
0 Replies
5. UNIX for Advanced & Expert Users
Hi i have 3 sql scripts that need to be executed simultaneously, and independent of one another, how do i do that in Unix AIX 5.3 (1 Reply)
Discussion started by: yschd
1 Replies
6. Shell Programming and Scripting
I got a program named as "fastq_to_fasta".
I got a long list of file all named as AB1 and AB2.
My input file is :
071022_L1_AB1.fq
012121_L1_AB1.fq
021213_L1_AB1.fq
012153_L1_AB1.fq
071022_L1_AB2.fq
012121_L1_AB2.fq
021213_L1_AB2.fq
012153_L1_AB2.fq
.
.
.
.
.
.
My desired... (10 Replies)
Discussion started by: patrick87
10 Replies
7. Shell Programming and Scripting
I am trying to run SSH , mkdir and other unix commands using Perl CGI. But i am not able to Execute these commands.
Please help me out !!!!
SSH and mkdir is necessity for me.
I will be thankful to you...!!!!!
I am trying like:
In perl CGI file i am writing like: @list = `ssh... (28 Replies)
Discussion started by: Navrattan Bansa
28 Replies
8. Shell Programming and Scripting
I need to run few commands in a ksh script sequentially.
Some of the commands are jobs submitted to the server and the consecutive commands are dependent on the completion of the jobs submitted to the server.
It works if i separate the commands into different files like this
#!/bin/ksh... (1 Reply)
Discussion started by: prashob123
1 Replies
9. Shell Programming and Scripting
I have a question:
Where would I put the Command line (of any command) so that it executes every time I log on? Where would I put it if I want it to execute every time I start a new shell? (5 Replies)
Discussion started by: Nabeel Nazir
5 Replies
10. Shell Programming and Scripting
I don't know to debug the program todaylive.pl program.
plz someone let me know what are the commands I need to know to debug the perl programs to find out the error on it. (3 Replies)
Discussion started by: ramkumar15
3 Replies
LEARN ABOUT LINUX
shtool-echo
SHTOOL-ECHO.TMP(1) GNU Portable Shell Tool SHTOOL-ECHO.TMP(1)
NAME
shtool-echo - GNU shtool echo(1) extensional command
SYNOPSIS
shtool echo [-n|--newline] [-e|--expand] string
DESCRIPTION
shtool echo is an echo(1) style command which prints string to stdout and optionally provides special expansion constructs (terminal bold
mode, environment details, date, etc) and newline control. The trick of this command is that it provides a portable -n option and hides the
gory details needed to find out the environment details under option -e.
OPTIONS
The following command line options are available.
-n, --newline
By default, output is written to stdout followed by a "newline" (ASCII character 0x0a). If option -n is used, this newline character is
omitted.
-e, --expand
If option -e is used, string can contain special "%x" constructs which are expanded before the output is written. Currently the
following constructs are recognized:
%B switch terminal mode to bold display mode.
%b switch terminal mode back to normal display mode.
%u the current user name.
%U the current user id (numerical).
%g the current group name.
%G the current group id (numerical).
%h the current hostname (without any domain extension).
%d the current domain name.
%D the current day of the month.
%M the current month (numerical).
%m the current month name.
%Y the current year.
EXAMPLE
# shell script
shtool echo -n -e "Enter your name [%B%u%b]: "; read name
shtool echo -e "Your Email address might be %u@%h%d"
shtool echo -e "The current date is %D-%m-%Y"
HISTORY
The GNU shtool echo command was originally written by Ralf S. Engelschall <rse@engelschall.com> in 1998 for Website META Language (WML)
under the name buildinfo. It was later taken over into GNU shtool.
SEE ALSO
shtool(1), echo(1).
18-Jul-2008 shtool 2.0.8 SHTOOL-ECHO.TMP(1)