Search Results

Can you please give some example. It is difficult to understand the problem you are facing from current explanation.

Thanks

Best approach is to create a C shell wrapper script.

Wrapper should
1. Source the environment file
2. Invoke the Korn shell script.

Hope this helps...

@Scrutinizer: Good compact code.

Please find two observations below.

Issue 1:
Let us say there are two directories in the destination with the below names.
TEST
RETEST

And two files in...

Please make sure to test this before using it in live environments.


#!/bin/ksh
SRCDIR=./src
DSTDIR=./dest
for matchstr in `ls -lrt ${DSTDIR} | grep ^d | awk '{ print length($9) "," $9; }' |...

Change
printf("%d, %d, %d, %d, %d, %d, %f\n", a, c, d, cnt, minh, maxh, avgh);
to
printf("%d, %d, %d, %d, %d, %d, %5.2f\n", a, c, d, cnt, minh, maxh, avgh);

Please test this before using in the real world.


#!/bin/ksh
DIR1=dir1
DIR2=dir2
MATCHSTR1=str1
MATCHSTR2=str2
#MATCHST1 and MATCHSTR2 should be exclusive of each other.
#meaning when...

Search man pages for sed.


newvar=`echo ${var} | sed 's/\_/\\n/g'`

I think find will automatically traverse through the sub-directories and gzip the files as necessary.

APPL=`grep "$Application" ldapapps |awk '{print $1}'`
echo $APPL

Is ldapapps a variable. If it is then it should be represented by ${ldapapps}.

Replace
print a "," c "," d "," cnt "," minh "," maxh "," avgh;
with
printf("%d, %d, %d, %d, %d, %d, %f\n", a, c, d, cnt, minh, maxh, avgh);

#!/bin/ksh
#cat inpfile | cut -d"," -f1,3,4 -s | uniq
INPFIL=./inpfile
print "A , C, D,Diff_count,min(H column),max(H column),AVG(H column)"
for ind in `cat ${INPFIL} | cut -d"," -f1,3,4 -s |...

Can you give the whole content of the UPDate.sql

Can you please execute the PL/SQL proc in some Oracle DEV Tool like Toad or SQL tools and check the output.

DECLARE
CNT NUMBER(5);
DROPCNT NUMBER(5);
ERRORCNT NUMBER(5);
BEGIN
SELECT...

There were a couple of syntax errors in the code I gave before. The below code has those misses marked in red.

Can you also check whether the file is created?


nawk '{{print $1,$2,$3}}' ...

nawk '{{print $1,$2,$3}}' ./$DirectoryName/AuditGroupTableTableData_$TimeStamp.txt | while read a b c
do
echo $a
echo $b
echo $c
ret=`sqlplus -s $db_user/$db_pwd@$db_sid $a $b $c <<EOF >...