Re: Getting data to a file, and divide by zero

Thanks for your answers. UNLOAD works dandy-fine, and I haven't tried the union for the divide by sero. And now, if I may, a follow-up question: How do I run this SQL script from the command line? I want this unload to run every morning. Obviously, I'm not going to come in at 3 in the morning and run isql, I want to have a cron job do this for me. Thanks again! Niel -- |-------------------------------------------------------------------| | Niel M. Bornstein nbornstein@plr.com | | nbornstein@prubank.com | --------------------------------------------------------------------- | Visit me at http://www.ticllc.net/home/niel/publicHome.html | --------------------------------------------------------------------- | "Not all dinosaurs roll over and die. Some of 'em can run real | | fast and bite the hell out of you." -- Anonymous, Wired | |-------------------------------------------------------------------|