Search Results

Hello arun888,

Considering that |1.77 into your first line of Input_file is a typo as I can't see that in your shown output. So following may help you in same.

awk -F"|"...

I don't understand what you want. Your script doesn't produce any output (other than the exit code).

Add echo or printf or some other statements producing the output you want to include in your...

You can't write to a log file after you exit.

Why do you care if the exit status is stored in a variable before you write it?

What is the name of the log file?

Do you want to append data to...

That's because of the single quotes, which prohibit shell's variable expansion. Use double quotes instead.

Try changing:
#!/usr/bin/ksh
#clientcheck.ksh zxx
#set -x
hn=`hostname`
if [[ $hn = "us" ]]
then
case $1 in
ban) client_home='/comps/banking'
;;
man) ...

Hello Arun,

Could you please change if [[ $hn = "us" ]] to if [[ "$hn" == "us" ]] and let me know if this helps.
EDIT: Thank you Don, I think Don has given perfect solution, please try that...

This isn't likely to help. (It will help if and only if hostname aborts or returns a host name containing whitespace characters.)

The problem shown in the trace is that the operand passed to the...

There are different line terminators in the unix and the windows world. To add the line endings windows editors understand there are 2 ways:
Create the text with the needed endings:
printf "First...

Assuming you still want to look for the file in a subdirectory of the directories you named for the ADUS files and the PROM files corresponding to the week number named in the file you're processing,...

Hi arun888
If you do not mind to learn some more
You do not need to use the command cat there; the command tail can do the same by itself
tail -4 input.txt

By the way, there should be only four...

Hello arun888,

You can use following.

cat Input_file | uuencode Input_file | mailx -s"test" ravinder.singh@chumma.com

Make sure you have uuencode command in your box.


...

Hi,

you feed notavail.txt to uuencode and then feed uuencodes output too mailx. You do not see any email body because only the encoded content of your textfile arrives at mailx. For a mail body...

Perhaps something like:
#!/bin/ksh
ADUSf=adus.txt
ADUSp=/retail/market/salil
NONEf=none.txt
PROMf=prom.txt
PROMp=/retail/market/loki
rm -f "$ADUSf" "$NONEf" "$PROMf"
while IFS=. read head...

Hello aurn,

Following may help you in same.

###One liner form:
while read line; do ZERO=0; ls -l $line > /dev/null 2>&1; if [[ $? -eq $ZERO ]]; then echo "File named $line found."; else echo...

Arun,

You've redirected STDIN twice, you'll need to remove < /dev/null from the command line.

- DL

If simply.txt is just ASCII text, try mailx -s "Alert Email for JOBS Failed for week $week" arunkumar@trival.com <simply.txt

Why not use sqlldr with input file ?

With it you have two possible paths.
Parsing input using complex control file or loading data into temporary table as is with simple control file, then do...

The string consisting of 45 spaces followed by a "1" is not the same as the string "1". To get what you seem to want you could use any of the following:

Change out=`cat bit.txt` to read out <...

In this case you do not need awk to extract the information.
i.e.
#!/bin/bash

while IFS='[, ]' read job location sales; do
echo $location
echo $sales
done < test.txt



...

unix_count is a variable local to the sqlplus script and can't be used outside. And, count will remain empty as the sql output is going into unix_count.
Remove the space in front of the EOF token.

Hello Arun,

Could you please try following and let me know if this helps. Off course I haven't tested it.

while IFS='[,]' read locationinp sales;
do
location_id=`echo $locationinp | cut -d'...

Perhaps you could write it more like something like this (untested) :

get_sales_info () {
loc_code=$1
sqlplus -S /NOLOG << EOF
CONNECT dbs/passwd@dbtod
SET head off
select...

LOCATION="$1" rather than LOCATION=&1, I believe.
LOCATION is taking its value form the commandline invocation of the shell script, it seems.

Hello Arun,

Following is an example for same, hope this may help you.
Input_file:

cat function_check
chennai
salem
banglore
trichy
tripur
Punjab
Code is as follows for an example.
...

you read a variable called location and then use tests on store. Is this the whole script?

You also use ` ... ` inside of $( ... ). Both are for command substitution. Neither are necessary because...