Search Results

Thanks for the quick response...basically what i am trying
to do is to create a new KSH script that will call a existing KSH script in a loop based on a
set of values from a SQL stmt...
..The...

I have a KSH script that I want to call in a loop for each row in the above table

---
new_script.ksh (psuedo code)

the contents on this new script would be something like below...

for t in...

I need to pipe the SQL Spool to another loading program....Thats why..

I want to spool files from unix using a sql script that would
take values from another sql query within the KSH script..

unix loop
select order_date from date_tbl

for each order_Date i need...

Thanks for the answers...I think i have to go with lsof...but when i run it in my production box i get the following error?> any idea?
lsof: can't open /dev/mem: Permission denied
lsof: can't open...

Gurus,
I am faced with a situation where a source system FTPs files to a directory in UNIX and we invoke SQLLDR process to process the files..The problem is we are continoulsy (3 minute)receiving...