Search Results

@Vidya

I did try sed but got error every time. Your solution might help...

Thanks...

All,

I am having a tough time with Linux and CSV file. My CSV file gets generated from Cognos on Linux machine that contains special characters. At first instance when I do vi <filename> to that...

#!/bin/bash

limite=3
a=0

while [ "$a" -le 3 ]; do

if [ "$a" -eq 1 ]; then
pru=/usr/bin/mei.txt
cat $pru | mail -s "IMEIS" mathias@wirtel.com.ar
fi

if [...

my mistake - '$a' shouldn't be in single quote. It will read it as one string. better use "$a".

Just check if you can initialize 'a' before while loop and instead of '$a=1' just use '$a'. Hope it solves your problem.

If i remember I faced it sometimes back. Not sure if it was exact same but related to it.

where you are initializing the variable 'a'? if it has no value assigned to it, how can you put expression over it?

there can be many scenarios where something is going wrong

export the DESTN_PATH variable. (it shouldn't contain / at last of the path, otherwise you will two // in your output expression)
...

I don't know if I am correct, try this -

a=$a+1

should be

a=`expr $a + 1`

How did you do that? can you paste that entire mailx command? -c option should work. May be its lacking the exact substitution.

If you want to kill the current script after 10 minutes just run another script in background with nohup. pass the parent process id(current script id) and in that script just wait for 10 mins

...

-f option is for checking file, whether its ordinary or not.
What exactly you want to check? only the existence, then try -r option, you can copy that.

echo "`date '+%Y%m%d_%H%M%S'` Getting...

FILE_NAME is the data file which will have records and will be loaded to database by using sql loader.

If you are not executing the config file then what is the use of config file? Before you...

./script.sh param1 param2 param3 .... paramN
in script.sh

parameters=$*

for param in $parameters
do
echo $param
done

if you put those details in environment variable then -


#count the total records from file includes header and footer also
TOTAL_COUNT=`wc -l $FILE_NAME`

#Now subtract the count of footer...

there are two ways to do it.

1. Pass the total no of loads while invoking SQL Loader. (Count the actual no of records from input file and pass it)

TOTAL_COUNT=`wc -l $FILE_NAME...

You have different set of similar rows. You want to put them all in separate-separate files based on time stamp or only the first set of rows in another file?

find /devctr/srcfiles/* -type f -mtime +1 2> error.log |xargs -I FLNAME echo FLNAME

use this

find <file_pattern> -type f -mtime +1 2> <error_log> |xargs -I FLNAME echo FLNAME

PASS=Figomom#0;export PASS is password that is getting used to connect to database. Once you set the password you need to export it as environment variable. So whenever you need you can use it.

if...

some time back i had the similar issue. my csv file was generated from cognos on unix box but it was having some special characters. I just did find and replace from ksh script before processing it.

try this one, hope it works for you


diff <dir1> <dir2>| xargs -I FNAME echo FNAME>> tmp_file

for filepath in `cat tmp_file`
do
dir_name=`echo $filepath|cut -d" " -f3|cut -d":" -f1`
...

I didn't understand fully your question but just try this, hope you want same.

TODAY=`date '+%d%m%Y'`
expdp system/test@Database dumpfile='expdp_database_'$TODAY'.dmp' directory=datapump_database...

you have put a question or assignment here?

for file searching older than 5 days
find dir_name/file_pattern -type f -mtime +5

use a temp file to list your desired files and use it where...

have you added the first line to tell which shell you are running? like
#!/bin/sh