Search Results

Hello mora,

Kindly use as follows in if.


if [[ `ls -l /tmp/file.txt | awk '{print $1}'` -eq 0 ]]


EDIT: Also to check file size zero you can do as following.


if [[ -s...

Try alternatively:awk '1
NR==3 {print "DIR=/usr/CDR"}
NR==7 {print "Source=/usr/src"}
NR==28{print "Target=/usr/tgt"}
' file

The script should work fine the way mora posted it. The at sign (@) is short for the start command and the exit command is not needed if sqlplus gets fed by a here document (or a pipe).
I suspect...

I see no exit for sqlplus... and I also am no more much in oracle but at the time I used start commmand, so if I adapt your code to the way I would have done, it would give:
In /tmp/query.sql:
...

SQL*Plus accepts here documents, no need for expect.
What is the exact error message you see?
Remove the redirection to /dev/null and put set -x before your call to sqlplus to see what is happening.

Hi,

I am not an SQL person, however I would think that you'll have to use something like expect to manage that as the shell will not understand your SQL commands.

Regards

Dave

As DonCragun rightfully stated this was a typo on my part, sorry for that.



I have to admit i do not know Teradata RDBMS at all, i am just a system administrator with a (at best rudimentary)...

It looks like one character was dropped. Try:
typeset iNumFields=$(( ${#chBuffer}+1 ))

You could have that all in one if you could provide some details. The maximum number of delimiters (in your example "|") would be:

sed 's/[^|]//g' /path/to/input.file | sort | tail -n 1

This...

Maybe a simpler solution will be enough?
sed 's/CASH_//g; s/LOAN_//g' INPUT.FILE > OUTPUT.FILE

sed '/^#Generate_file/ s/\(\.txt\)/.1cdb\1/' infile

awk 'BEGIN{FS=OFS="\."}NF==2&&/^#Generate_file/{$NF="1cdb."$NF}1'

sed 's/\.txt/\.1cdb\.txt/' infile > outfile


or if you prefer to remove the need for a temp file (outfile):


sed -i 's/\.txt/\.1cdb\.txt/' infile


You can even do a pretest and print to...

To get all the non duplicate records from .txt files


find /root/neb/src/ -name '*.txt' | while read FILENAME
do
awk 'x[$0]++{next} {print $0}' < "$FILENAME" > "${FILENAME}.out"
done

...