Recent content by nithin97

THanks lmorgansky.. i'll try ur concept and let u know.. thanks for the help...

Hi, i'm using SQL*Loader to load oracle tables.. can i please know whether I can use shell scripting inside a .ctl file 'coz the infile name will be always changing every 15 minutes. So i need to dynamically create the infile name which I can do it in shell scripting. Given below is what i'm...

hi,, what i'm trying to do is if the number is less than 10 , I want to add a zero before it.. like, if it is 9 output should be 09.. and i'm using c-shell.. can you pls help me out ?

hi jamisar.. i forgot to mention.. i need to code only in c-shell... can you pls let me know in c-shell.. thanks for your help..

Am trying from y'day.. but this following switch case is not at all working.. problem is if i give this multiple choice for "case" its not working.. it just works when i give just one value for "case"... your help appreciated... Switch Case problem.... switch ($month)...

thanks morgan and curva, i'll try that and let yu know... but now i'm not able to run sql*loader from my unix command prompt.. what would be the problem ? should i set the path ?

hi lmorgansky, thanks for your suggestion.. can i pls know how to invoke SQLLoader from a shell script, coz i'm new to both SQLLoader and Unix Shell scripting...thanks...

hi, i need to load a table using sqlloader every 15 minutes.. and the thing is the infile's name will be changing every 15 minutes but with a definite format like xyz_20020709_1015.txt,xyz_20020709_1030.txt etc.. can you suggest me a way for loading the table ? is it possible to invoke sqlloader...

hi ecasadella, below is the script which i'm trying to do.. this script runs every 15 minutes and ftp's to a site to get files... sometimes the ftp session hangs up.. so before invoking this script next time i've to chek whether the previous ftp is still running or not.. if running i've to kill...

hi ecasadella, thankx for your suggestion but here they prefer only c-shell.. so somehow i need to do that in c-shell... i'll try again...

hi ecasdella, ur example script works fine when run.. but it is a K-Shell.. i've to use C-Shell.. i think thats why that '!ps' is not working in c-shell... is it the reason..can u pls help me get out of this problem...

here it is.. but i think something is wrong.. can u pls let me know.. echo ftp -inv \<\< ! > ./tmp5 echo open www.xyz.com >> ./tmp5 echo user uname pwd >> ./tmp5 echo !ps | grep ftp | awk '{print $1}' >! ./myftppid echo cd /tmp/tmp1 >> ./tmp5 echo get file1 >> ./tmp5 echo quit >> ./tmp5...

hi, I tried what you told but still same error. and my OS is SunOS 5.8 When I tried the same line given below in the command prompt it worked fine... !ps | grep ftp >! myftppid

still no joy ecasadella... its not working. its giving error. ps: Event not found I added this line after I open the ftp process, !ps | grep ftp | awk '{print $1}' > myftppid Am new to shell scripting. Can yu pls help me out in this.

hi ecasadella, thanks for ur reply... but i still couldnt get the pid of ftp process alone... heres the ftp process which comes inside my script. echo ftp -inv \<\< ! > ./tmp5 echo open www.xyz.com >> ./tmp5 echo user uname pwd >> ./tmp5 echo cd /tmp/tmp1...