Search Results

Hi,
You have to check the filesystem hosted path and maximum used space in %
using the below command

df -k . | sort +4rn
The above command will listout the maximum used path and filesystem
...

Hi,
You have check the env file what is the type of local and server time they have set.

use the below command for check the data format in env file

env | grep -i date

Hi,
How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement?

Here i know how to connect the database using unix shell script and...

Hi all,

Vi editor is my favourite.......:) :b:

Hi all,

i am using vi editor.......!!! :b:

Mehta,

what is the error you are getting while bcp'ing the file?

Could you please post the error message then you may get the some posible solutions for this.

for delete the first row from...

prasad,

Try with .dat file with -C tag

bcp db..sample out act.dat -SSERVER -UUSER -PPWS -c -t~

it might wroks. Revert me if you have faced any issues on this.

Hi,

Yu can use the below query to connect the sybase database in unix

$SYBASE/bin/isql -S$SERVER -U$USERID -P$PSWD -w300 -o output.log <<EOF
select * from table_name
go
EOF

Hi all,

How to findout the file sytem type which is NFS and which is Local?

Suppose i have 5 different folders my in Root directory. dir 4 and 5 are mounted on different file system and dir 1,2...

Hi JIM,

if you put the command (ls -l -t | head -2) it will return the latest file in the partcular dir

if you want retreive the oldest file in the dir, you can use the below command
$ ls -gt...

We can use the below command also for find the latest file in particular directory

ls -gt | tail -1

Hi radoulov,

its giving some "Parse" error when i issue the code in command prompt as well as i tried with awk script lik this.


$ cat com.awk
{
NR == FNR {
_[$1] = $0
next
}
$2 in...

Hi All,

I have two txt files like this

File1:
no name
----------
12 aaaa
23 bbbb
55 cccc

File2
dname dno
------------
civil 33
mech 55
arch 66
...

Try with uniq command

cat temp temp1 | uniq

Hi Sekhar,

You can use foreach command

foreach i (`cat stringlist.txt`)
sed '/$i/d' fileList.txt >> temp_fileList.txt
end

mv temp_fileList.txt stringlist.txt

Thanks
MPS

Hi Friends,

is there any site for download the UNIX operating system with Oracle database.

if yes, Please send me the link for download the free Oracle software in UNIX environment.

Thanks...

Hi All,

I have the file like this (file name is : tem_text)

no Id name ccy
------- ---- ------------------- --------
7777 17 India Overseas Partners 500INR

I want...

Hi era,

Its not for school work, i am facing some problem while downloading the file from mail box.

i will give the full details on tomorrow.

Regards,
MPS

You can use like this

MAILADDRTO="first@someplace.com\,second@someplace.com\"

it could be works...


Regards,
MPS

Ho Experts,

I have a complicated question that is

i want to download the attachement file from mailbox which is having the subject as the "external data" and downloaded the file put it into my...

Hi,

If you want display the second column from the file, we can go for awk command

here is the correct command

ls- l | awk '{ print $2 }'

examaple:

ls -l

-rw-r--r-- 1 raroc ...

Hi,


i use KSH for everything...:b:

Regards,
MPS:b:

You should specify the directory path and folder name before issue the cd command (before change the current directory)

Regards
MPS:b:

Hi all,

i am working with CSH, i want to know that
how to send a mail in UNIX shell script (CSH) with attachment as well as message body.

i know that how to send a mail with attachment and...

Hi,

i have text file with ~ seperated columns. it is very huge size of file,
in the file sompulsary supposed to has 20 columns with ~ seperated.
so how can i find if the file has 20 column in...