06-10-2011
Quote:
Originally Posted by
WhoDatWhoDer
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 recommendations are top notch.
I will be creating four of these scripts: dates for Q1, Q2, Q3, and Q4. Each script will be called once per day to convert data for the specified year based on which day of week it is. Monday we'll be converting for year 2005, Tuesday for 2006, etc. The year will not be passed in from cron. Actually no parameters will be passed from cron.
You have answered most of my question based on your responses anyway. I'm still a little confused as to how to code DOW to consider EDT offset.
Jim said to lose the Perl, ok. Then how does that get applied with the offset.
Thanks in advance for your help.
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 easy/basic to implement.
This User Gave Thanks to vgersh99 For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
3. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
4. Shell Programming and Scripting
does somebody know GMT mapping? please reply (2 Replies)
Discussion started by: SANGUINE
2 Replies
5. AIX
Hello,
On Aix 5.2, we changed the parameters tcp_keepinit, tcp_keepintvl and tcp_keepidle with the no command.
tunrestore -R is present in inittab
in the directory /etc/tunables we can clearly see the inclusion of parameters during reboot, including the file lastboot.log
... (0 Replies)
Discussion started by: dantares
0 Replies
6. Shell Programming and Scripting
I have a file which is tab delimited, it contains the GMT date.
Please tell me how to convert from GMT to PST time and if the date and time is of 2 days ago from the current date store the lines in a file or else remove the line.
10.1.10.178 - - -
10.1.10.178 - - ... (2 Replies)
Discussion started by: sandy1028
2 Replies
7. Shell Programming and Scripting
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
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
8. Shell Programming and Scripting
Hi All,
I am trying to dowmload the zip file "zkManageCustomers.zip " but i dont have access. Can anyone help me to download this file
See the below link-
http://www.ibm.com/developerworks/opensource/library/wa-aj-open/index.html?ca=drs-
Please help me as early as... (1 Reply)
Discussion started by: aish11
1 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
LEARN ABOUT DEBIAN
hdate_struct
hdate_struct(3) libhdate C language hdate_struct(3)
NAME
hdate_struct -
libhdate Hebrew date struct
SYNOPSIS
#include <hdate.h>
Data Fields
int hd_day
int hd_mon
int hd_year
int gd_day
int gd_mon
int gd_year
int hd_dw
int hd_size_of_year
int hd_new_year_dw
int hd_year_type
int hd_jd
int hd_days
int hd_weeks
Detailed Description
libhdate Hebrew date struct
Field Documentation
int hdate_struct::hd_day The number of day in the hebrew month (1..31).
int hdate_struct::hd_mon The number of the hebrew month 1..14 (1 - tishre, 13 - adar 1, 14 - adar 2).
int hdate_struct::hd_year The number of the hebrew year.
int hdate_struct::gd_day The number of the day in the month. (1..31)
int hdate_struct::gd_mon The number of the month 1..12 (1 - jan).
int hdate_struct::gd_year The number of the year.
int hdate_struct::hd_dw The day of the week 1..7 (1 - sunday).
int hdate_struct::hd_size_of_year The length of the year in days.
int hdate_struct::hd_new_year_dw The week day of Hebrew new year.
int hdate_struct::hd_year_type The number type of year.
int hdate_struct::hd_jd The Julian day number
int hdate_struct::hd_days The number of days passed since 1 tishrey
int hdate_struct::hd_weeks The number of weeks passed since 1 tishrey
Author
Generated automatically by Doxygen for libhdate C language from the source code.
Version 1.4 Sun Jan 8 2012 hdate_struct(3)