Search Results

Thanks Methyl....!!!

People like you is making my unix script learning very interesting and boosting my confidence that a novimce like me can also do it.....!!!!

Thanks a lot and will keep...

Thanks alll........!!!!

my script is now running on server...... :)

I didnt understand this.......!!!



Also in crontab how to get data in log file, i mean this one

/a/b/file.ksh >...

Hi all,

sory i was unable to look into solutions....!
Will work on that...
just for info a mail got generated in which said

/home/fid/AT.ksh[18] /bin/sqlplus: not found

will get back...

I wud be posting all details, just let me know how to check who owns crontab?

---------- Post updated at 08:41 PM ---------- Previous update was at 07:41 PM ----------



1) Sun Solaris
2)...

I only placed file on server and also did entry in crontab..!

The script is running fine if i manually run at that location but everything remaining same when it runs from crontab entry the...

I am using complete path.....the script is even executing but only the spool part is not happening......!

---------- Post updated at 11:46 AM ---------- Previous update was at 11:44 AM ----------...

Hi,

I have one script which takes data from table and spools it into a file.
When i am running manually all is fine but while trying same script thru crontab the spooled file is not getting...

hey it meant that i cant add job to crontab as it is dependent on a window job......!
so cal has to be from windows....!

but i don have any ssh installed.....!

cant do that as job run time depends on completion of a job which runs on windows.....

so i was trying to add a cal to batch file which needs to be run in windows manually.........!

this...

Thanks Duke.

I am trying that out...
if any prob will revert back to bug again......!:)

will reply back whether success or failure.....:p

---------- Post updated at 03:10 PM ----------...

Hi All,

I need to call a unix script from windows bat file, please help if that can be done.
I cant install cygwin or putty or any other ssh on server.....!
do we have anything else?

0)9i & sun solaris 5.9
1)Oracle session is started through scripts in unix.
2)Yes both resides on the same box.

I want my script to be triggered on a particular table being updated.

Hi,

I need some help regarding oracle with unix script

Actually i have a shell script and i want that it gets triggered through a oracle Db.I dont have any idea how is it done, even whether...

hmmm....!!!

Thanks :)

i jus give ksh to change my shell.....anyways now its working fine...may be that escape thing was the problem.


NB: Please if can any one let me know how to close...

Thanks all.....!!!:)

My login shell is ksh.....!!!
scrutinizer's "\" is working fine for me......but why is it required in scripting but not in normal input???

Danke!!!
C u all...!
tc.

Thanks a lot........now its working for me...!!

i used file in "file1" 'file2".......!


NB:Please let me know how can i close threads if my issue gets resolved.

Hi,

Below is the code for my script


#!/bin/ksh

for file in "file1.txt" "file2.txt" "file3.txt" "file4.txt"
do
L="$(tail -1 $file)"
NUM=${L%%|*}
DAT=${L##*|}
echo $NUM
echo...

Hi All,

I have some files in my directory, and i want to pull all data using for loop....I am using following code but getting error..!


for file in {file1, file2, file3, ..... filen}
do
...

Hi All,

I have some files in my directory, and i want to pull all data using for loop....I am using following code but getting error..!


for file in {file1, file2, file3, ..... filen}
do
...

Thanks a lot Frans....!!!
Its working fine now......would be incorporating it into my script and hope all goes fine.... :)

Thanks to others too...all of you made my work easy.....!!!


Will...

Thanks Frans.....!!!

Superb.......jus one more help...... i jus want them to be formatted so it looks neat......as table name and numbers are of different length so all is getting jumbled...!
...

Hi Frans,

The Logic you used was very good but problem is with my data file.
Please if you can help me out with the requirement.....!

Thanks Sudhakaran and Franklin52

But still i am not able to use this code properly....!!! :confused:

Name of files are
1) Table_Name.txt
2) Table_data.txt

how to use them.I am really...

file doesnt have any special structure....it is just like some nos in each line as shown.....
no of rows is 29 for numbers and 10 for table names....
need to arrange them like 10 rows, each table...