Please be much more explicit about what you are trying to do. The awk toupper() function converts lowercase letters in the string it is given as an argument to uppercase letters. It does not change characters found inside a file whose name is specified by its operand. And, as stated before, toupper() is an awk function, not a shell utility.

If you want to convert the contents of a file to change lowercase letters within a file to uppercase letters while preserving the original ownership, access modes, and links you can use either of the following:

Code:

TmpFile=${0##*/}.$$
awk '{print toupper($0)}' "$SQLOutFile" > "$TmpFile" &&
    cp "$TmpFile" "$SQLOutFile" &&
    rm "$TmpFile"

If you're trying this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
or:

Code:

TmpFile=${0##*/}.$$
tr '[:lower:]' '[:upper:]' < "$SQLOutFile" > "$TmpFile" &&
    cp "$TmpFile" "$SQLOutFile" &&
    rm "$TmpFile"

If what you want is to perform a case insensitive match when looking for the string START TIME, but you want the output produced by your awk script to match the case sensitive input found in the file, change:

Code:

          starttime=`awk   '/START TIME/ {x=NR+5;next}(NR==x){print}'  toupper($SQLOutFile) `

to:

Code:

          starttime=$(awk   'toupper($0) ~ /START TIME/ {x=NR+5;next}(NR==x)'  "$SQLOutFile")

or to:

Code:

          starttime=$(awk   '/[Ss][Tt][Aa][Rr][Tt] [Tt][Ii][Mm][Ee]/ {x=NR+5;next}(NR==x)'  "$SQLOutFile")