UNIX for Dummies Questions & Answers

Hi,

I am trying to run some SQL scripts under the UNIX server using BTEQ. When I try to create a log file, the file gets populated only to the point where I log into BTEQ.

The log file for the running of the actual script does not seem to be stored.

Would any one know ehy this could be happening?

The command I am using is: nohup <file_name> > log_file.log &

Thanks!

Yeah, the script is waiting for input from either standard input or directly from the terminal. Either way, it expects you to login first before doing anything.

Create a database user with limited access to the database, prohibit network logins to that user, and allow the user to login with no password. Change the script to use that user. Try again.

Otheus,

Thanks so much for getting back to me on this. I have the login information set up for the script to run, and the scripts actually do run and I do end up getting results.

But the log file never gets populated with the rest of the information.

I have fairly little knowledge of UNIX, so I might have missed out on what you actually meant to say. So if your answer already covers what I said above, can you please explain your answer with a little more detail?

Thanks again,
ZZ

You might want to post the script. Remove any passwords it may contain. Add it as an attachment. I might be able to figure out what's going on.