Search Results

That worked like a charm. Can you just explain why please?

none of that

This didn't work. It's copying gspp* into $FILES and attempting to execute the rest of the commands.

for FILES in gspp*
do
echo "Loading $FILES" >> ../logs/myloglog
mv $FILES temp.tmp
...

The sqlldr command is fine. Yes, I am moving it prior to calling sqlldr. I am renaming it from a filename that varies day-to-day to a static temporary one. Then my control file references that...

I have a directory that I would like to check for files of a certain pattern, that pattern being "gspp*". There may be several files or there may be no files that fit the given pattern at the time...

No. It greps all of the files in the directory using that pattern. This works fine if there are files that match in the directory. If there aren't is wherein the problem lies. It does not go into...

for FILES in grep gspp*
do
if [ ${FILES} = grep ]
then
break
else
echo "Loading $FILES" >> ../path/mylog.log
mv $FILES temp.tmp
sqlldr user/pass@DB control=/path/control.ctl
...

I wanna do something like


for FILES in gspp*
if test $FILES = grep
break
mv $FILES ../archive/$FILES
...
done

But I get errors if it breaks the loop and then hits the "done". ...

It kinda worked, but if there are no files, it returns "grep" in $FILES, which is not what I want.

Sorry, overlooked that, will try it.

Still need help on this.

I probably should've included it, but I'm doing additional things that require the use of the filename. I'm doing some moving and loading each into a DB as well.

This isn't working for multiple files. It works for one file though.

exists1=$(ls | grep gspp*)
for FILES in $exists1
do
echo "Loading $exists1"
...

Worked, thanks.

My default shell is ksh. I'm making a simple comparison in a script.

...
if [${exists1} -eq 1] then
...

i keep getting the error " [1: not found". I've tried this comparison a number of...

I see what the code does, but how can I get similar output using FTP instead?

I can only use FTP on the remote machine. I have full privileges on the local machine.

I am wondering however, how to verify that the file completed downloading properly because I will need to delete the file on the server when I'm done. So I need to a simple way to verify the...

I got it to work, thanks.

OK got it, thanks. Clearly I'm new to scripting.

To start, this thread, I have read the FTP FAQ and done a search and I can't figure this out. This is really simple, but the first command won't execute. I've removed my server name, user and pass....