Search Results

One thing springs to mind. When you ran the SQL from within SQL*Plus (@RCV_SHIPMENT....), you wound up, at the end, with:


SQL>


(the SQL prompt, i.e. you're still inside SQL*Plus)
...

How about "spool" with "append" option in all these .sql files.

Something like :

runsql () {
sqlplus /nolog << EOF
conn user/pass@$ORACLE_SID
@$1
exit
EOF
}
for i in *.sql # (array, list, whatever)
do
runsql $i | grep ORA-
if [[ $? -gt 0 ]]; then...

#=> GMT+11 is the comment part. If you want to change the actual time zone change it like this


@time=gmtime(time +(11*3600)); #=> GMT +11


Also you dont the shell scripts.

Just run...

This should do it, replace the perl part in your code.


perl -e '
use POSIX qw(strftime);
use Time::Local;
@inp = split(/-/,$ARGV[0]);
$epochTime = timegm(0,0,0,$inp[2],$inp[1],$inp[0]);...

This is what the TZ variable does

#!/bin/ksh
# input format YYYY-MM-DD prints day name
dow() ...

Big operations especially transactions are a drag on any system. They lack locality of reference, run at disk speed not RAM and CACHE speeds. Do an hour, day, week at a time and wait between batches...

Why do you need 4 scripts? Create just one script and have it figure out what day of the it's running on and make determination based on that what year to run the 'conversion' for - should be pretty...

Sometimes, you can impose a different time zone on the session, else subtract 4 hours from time using oracle time arithmetic.

Quoted quotes seems overkill, but if it works, great! I prefer to...

Use TZ variable to set the time zone. You did not specify your OS, so a solaris example

TZ=US/Atlantic

Lose the perl, use

dow=`date +%A`

BE CAREFUL when you use relative paths (./) in...