Re: Help Please

From: Gary Waldrom <garyw_at_amonra-insight.com>
Date: Sat, 18 Dec 1999 15:38:53 -0000
Message-ID: <E47927FC0A9CD3119D090000216DAFF501D56A@THOTH>

C hange the variable name to be postional variable &1 and &2 and then issue the script as sqlplus user/passwd_at_db @script month spoolfile

the month and spoolfile parameters are substituted for &1 and &2 respectively

Gary Waldrom
Amonra Insight Ltd.
Authors of Q-file IT Quick Reference Guides http://www.q-file.com

-----Original Message-----
From: GreyWolf_69 [mailto:GreyWolf_69_at_alloymail.com] Posted At: Friday, December 17, 1999 5:16 PM Posted To: server
Conversation: Help Please
Subject: Help Please

I have a sqlplus script that prompts for 2 variables. I want to run this script from cron on a Solaris 2.6 system. One variable is the name of the month, the other is a file name to spool to.

I know that if I date +%b command I get only the month in return. But what I want is the previous month. How do I get that, then once I have it, how do I pass it to the sqlplus script?

How would I pass that same month parameter to the file name for spooling?

Any help would be very welcomed.

Thanks a bunch,

And Happy Holidays.

Wolf Received on Sat Dec 18 1999 - 09:38:53 CST