One of our programmers needs help coding SQL SELECTs involving date
arithmetic.
The first SELECT runs the first week of the month and must return data
for the fifteenth through the last day of the prior month.
The second SELECT runs the third week of the month and must return data
for the first through the fourteenth day of the current month.
The pertinent part of the WHERE clause currently has hardcoded dates
which are modified before each execution -
WHERE BILLDATE_ENT_DATE BETWEEN 20071201 AND 20071214
Any suggestions on how to code the WHERE clauses for the first and
second SELECTs so as to avoid hardcoded dates would be greatly
appreciated.
________________________________________________________________________
More new features than ever. Check out the new AOL Mail ! -
http://webmail.aol.com
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
IDMS/Oracle Position opening at UNC Chapel Hill
"Hi,
We have an opening for an IDMS/Oracle DBA. The actual hiring range is
$80k-$85k. The full description is below. The position will support
both IDMS and Oracle databases, and is primarily system DBA type work.
The position closes on 1/21, so if you are interested please either
contact me (with questions), or go to the following URL and drill down
to the position, and then follow the ""Apply for This Job"" link.
https://s4.its.unc.edu/RAMS4/
Job Search Criteria
Job Category: Technical, Para-professional
Go
Position 4934
Position Information...
Job Title: Systems Specialist
Working Title: DBA
Job Category: Technical, Para-professional
Position Number: 0004934
Salary Grade/Range: BAND III / $50,000 - $109,200
FT/PT: Full Time
Hours Per Week: 40
Permanent/Time Limited: Permanent
Department Name: Information Technology Svcs.
Department Number: 3103
Date First Posted: 12/21/2007
Closing Date: 01/21/2008
Location: UNC-Chapel Hill
Minimum Education and Experience:
The specialist band requires a foundation of knowledge and skills in
area of specialization generally obtained from graduating from a
four-year college or university with a major in information technology,
computer science, or a closely related field and three years of
experience in operations analysis and design, systems programming, or a
closely related field. Experience in the field of work related to the
position's role may be substituted on a year-for-year basis. Special
note: This position may exclusively require a bachelor's degree in a
discipline related to the specific functions of the job. Please refer to
the ""Essential Skills, Knowledge and Abilities"" section of this posting
for more detailed information.
Essential Skills, Knowledge and Abilities:
PLEASE NOTE: All IT positions have moved to a new Career Banding
compensation program. For additional information, please refer to our
website at
http://hr.unc.edu/Data/SPA/paysystems/careerbanding/.
Specific competencies are required for the different banded levels and
roles. This position is being recruited for at the Advanced Competency
Level under this Career Banding program. The hiring range for this level
is $80,200-$85,000.
Preferred Qualifications:
Applicant should have advanced system DBA experience with Oracle 9i or
10g databases; Oracle DBA certification in 9i or 10g is a strong plus.
Ideal candidate will have advanced experience in all phases of Oracle
Database Administration including installing, upgrading, and patching
Oracle, RMAN backup and recovery, OEM Grid Control configuration and
mangement, Oracle database performance analysis, and tuning SQL queries.
Experience with Oracle RAC, Streams, and Dataguard are also desirable.
Operating systems experience should include significant DBA level
experience with Unix on AIX, or Solaris, or Linux. Experience with one
or more of the following: Oracle PL/SQL, Perl, Unix shell scripting. A
strong plus would be experience as an IDMS DBA with release 15 or 16,
including CV configuration, monitoring, problem resolution, backup and
recovery, and security; this includes a working knowledge of all IDMS
functions and utilities. Knowledge of ITIL/ITSM standards and their
adoption for DBA level work is also desirable.
Special Physical/Mental Requirements:
None Listed.
Position/Work Schedule Requirements: M-F 800 - 500
On-call occasionally (approximately once every 4 to 7 weeks)
--
Bye,
Chris Kaman
Database Administrator
Enterprise Applications
Information Technology Services
University of North Carolina at Chapel Hill
919.445-9370 (voice)
919.445-9487 (fax)
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: Enterprise COBOL FOR z/OS 4.1
"Hi Chris,
I'm running 16.0 SP4 on 20 some regions on 3 lpars with z/OS 1.8 no
problems with DC-Cobol, or IDMS COBOL. The compiler is PP 5655-G53 IBM
Enterprise COBOL for z/OS 3.4.1. I did't have to do anything for z/OS
1.4, 1.6 either. There is a z/OS system parm you have to know about, see
QI82743 for 1.8 and above.
Steve Harmeson