Search Results

Gurus,

Thanks so much for your help, in advance.

I'm using ksh and outputting a literal string value to an output file, however, Unix isn't playing by SQL's rules. The ampersand character...

Yes, I remember the "exit" being an issue with this once before. I'll give it a try and let you know.

Gurus,

The issue I'm having is that my Shell won't accept SQL parameters properly......

Here's they way I'm running it....


applmgr@ga006hds [/home/users/applmgr/CW_Merge_Project]
=> ...

UNIX Gods,

I'll be running this script from CRON. I need to log the status of each of the six sqlplus calls into a file when this job is kicked off. Any suggestions?

Thanks in advance.

...

GETMMG,

Thanks for your help. I'll be adding this Perl into my shell script to get my local time when running my scripts (GMT-4).

Thanks again.

Scott

Getting warmer....but the following should echo "Tuesday" when I change to +11.


#!/bin/ksh
# input format YYYY-MM-DD prints day name
dow()
{
perl -e '
use POSIX qw(strftime);...

I just need the day of week based on GMT-4.

It told me today was "Wednesday". Copied the exact code you wrote.


For Jim's code, I think the signs are reversed... the ( - negative) provides the ( + positive) value and visa versa.

=>...

Yes, got the following error.
Day '' out of range 1..31 at -e line 5

Guys,

Something doesn't appear to be working... The following should echo "Tuesday" if I provide GMT+11.



#!/bin/ksh
dow()
{
export TZ=GMT+11
perl -e '
use POSIX qw(strftime);...

I pulled the following code from one of Jim's threads. Since my server time is GMT, I need to make sure the output is GMT-4. Does anyone know how to tweak Perl to reflect this?

Thanks
Scott

...

VGersh,

Thanks for replying. The whole story is that we'll be executing each of the four scripts at different points during the day. We'll include each quarterly script as an entry in the cron....

My OS is HP UX.

---------- Post updated at 11:21 AM ---------- Previous update was at 11:09 AM ----------

Gurus,

I sincerly apologize. I think I did not explain myself properly. Your...

Unix gurus,

I'm brand new here so go easy on me.

I'm trying to automate the following script to be added to crontab which will automate the deployment of five sql scripts based on day of...