Search Results

Try
ps -s 1147

If it returns the details of the Sql script that is long running in your server, then you can be safely have your admin take appropriate action on it.

Thanks Summer cherry! You got my question and nawk does the work, but can't we get this done by writing a simple regular expression?

Thanks again!

What do you think is the difference between Current date & Today's date?
And what are you trying to do with your input file?

Can you pls explain your problem clearly? Try and paste a bit code...

In which context are you referring to an SID?

In unix context, sometimes a process is killed with the process session ID SID. For ex, with "pkill" command you could kill the processes with the...

Couldn't find much help on the kind of question I've here:
There is this text file with text as:

Line one has a bingo
Line two does not have a bingo but it has a tango
Bingo is on line three...

How to check if su is enabled for a user or not? Is there a command or a way to do that? Thanks very much!

You seem to be talking of two executable scripts. How are these two related? From what you describe, the two ksh scripts should run independently - one based on its pre-condition of a table load and...

Function that expects arguments need to have them , isn't it?

Try calling your function by passing the relevant parameters. Say, if you're passing the filename alone, then u may do:

func1...

Let us see what you've tried!

shsandeep,

Just substitute the " "(white space with commas) as below:

echo $str | sed 's/ /,/g'

Hereon, it'd be good if u can post ur work before asking for ready help!
Goodluck!

OOF.. All questions patiently answered!

Thank you very much... grial, thestevew and vino!

that much for ps -e | grep script2..

what is grep -v grep in the expression for?

TY!

Thanks a zilliion grial!

All your suggestions really worked but the last one...

when i try to execute script1.ksh > script1.log 2 >&1
i see all the log again on the terminal rather than in...

Thank you so much thestevew and grial.. for your inputs!

here's my code:


script1:
#! /bin/ksh

BBLOG="$HOME/bb_quickview/Log"
datestamp=`TZ=EDT+24 date +%m%d%y`
retcode=$?

if [ `ps...

FYI,
I even tried executing script2 from script1 as

. script2.ksh >> tmplog 2 >&1

and now I get syntax error: '(' unexpected

any clues of what the mistake is??

Thanks again!

Thanks thestevew,

I didn't know this one.. but this works only when i do:

ksh -x script2.ksh >>tmplog 2>&1 at the prompt

the same doesn't work for me from the script1..
This is how my...

I want to catch the execution information of a script by calling it from another script....

script_main:

#! /bin/ksh


ksh -x script2.ksh >> tmplog

....

but this doesn't give me...

That's pretty clear now! Thank you so much :)

To consider the sequence of sql statements as single block of execution.. anything wrong with them.

pls post what u have tried to do for this!

From man ls,

.. ls -l option gives a long listing of files along with mode, ACL indication, number of links, owner, group etc.. The date/time you see there is the time of last modification of the...

Oops.. sorry for that mistake. That's a typo here.. and what i did was what you suggested.. thanx for the correction!

Rather i even tried
`sqlplus -s "user/pwd@service_name" <<EOF1
@xyz.sql...

I've a script that fetches various values from the database as below:


#! /bin/ksh


$conn="user/pwd@service_name"
`sqlplus -s << $conn EOF1
@xyz.sql
@pqr.sql
@abc.sql
EOF1`

The output...

Okay, can you pls show us what you've worked on so far?

amodha,
I'm not sure if anyone on this forum will give you a tailor-made script for your problem. Try to post whatever your solution is and you'll definitely get a lot of help getting it to work.
...