IBM last week announced two additions to DB2 Web Query, the graphical business intelligence tool for generating and viewing reports and queries on the i operating system (formerly i5/OS). In September, IBM will deliver a new tool called Report Broker, which automatically distributes reports, and a new software development kit (SDK), which will enable customers and ISVs to integrate DB2 Web Query with existing applications.
DB2 Web Query is a special version of Information Builder’s WebFOCUS software that IBM announced in March 2007 and delivered that September. The software, which enables users to write queries for the DB2 for i (DB2/400) database and view the results in a Web environment through the included Report Assistant, Graph Assistant, and Power Painter components, is intended to replace the green screen Query for iSeries (Query/400) product while providing an on-ramp to more sophisticated business intelligence projects such as online analytical processing (OLAP), data warehousing, and data mining.
Read the rest of this entry »
LOCATION: US-PA-Philadelphia
COMPANY: ConsultUSA
INTERNAL JOB #: 11528201
POSTED: 7/15/2008
JOB SKILLS: COBOL, DB2, Mainframe
JOB TYPE: 1099
Job Term: Full Time
PAY RATE: Depends on Experience
Will Accept Contractors
JOB DESCRIPTION:
Join Now! Get free BA, PM or Technical Certifications, Unlimited Bench-Time, Full Time Status, 75% Paid Healthcare, PTO, Team Outings, Entrepreneurial Opportunities, Life Insurance, Paid Holidays, 401k plan with employer matching, Short and Long-Term Disability and a Generous Profit Sharing Plan.Join our innovative team for the following position:Our client located in the Eastwick, PA area has an immediate need for a Mainframe Programmer. The successful candidate must have a Bachelor’s degree in Computer Science or related field, with 8-10+ years of related application development experience. This position will be responsible for doing technical analysis and design, coding, testing, and implementing the required software changes. The consultant will also be responsible for documentation of the tasks. Required: . COBOL Enterprise. CICS. JCL. VSAM. Ability to work independently with minimal supervision as part of a project team. Self-reliant, self-starting and willingness to involve corporate staff when needed. Meticulous about coding. Excellent written and oral communication skills. Strong analytical, organizational and practical problem-solving and decision-making skills Desired:. Easytreive skills. NDM skills. Prior experience with Endevor a plus . Knowledge of banking or fund accounting systems and DB2 is desirableWhen Hired:. ConsultUSA will invest in you by providing training to enable you to grow and diversify your skill set to keep abreast of the latest technologies.. ConsultUSA will work closely with you to develop an exciting career path of your choosing, focusing on your key strengths.. You will work within a dynamic team environment gaining invaluable experience.. You will be a part of a growing organization focused on success and empowerment How to Apply:. For a complete listing of all our opportunities, please visit: http://www.consultusa.com. Managers are short listing qualified candidates. For consideration, email MS Word resumes to Amanda@consultusa.com. Please include position number 4408 subject line when applying
REQUIRED SKILLS:
Read the rest of this entry »
Hi community,
the log files in SQLOGDIR have -rw—— as permissions. How can I
change the permissions to -rw-r—-, also for newly created logfiles?
Thanks in advance,
Axel.
Source:SQLOGDIR permissions in AIX
In DB2 for LUW not directly. To do things like condition handling inside
of a trigger push the logic into a stored procedure and CALL that.
The SQL Procedure has the full power of SQL PL at its disposal.
Cheers
Serge
Source:Re: How to check SQLCODE in trigger
I have a query in Oracle like this:
Select 1 from dual
where
(1,1) IN ( (1,1), (2,1) )
and want to convert it to DB2.
I tried this query:
Select 1 from sysibm.sysdummy1
where
(1,1) IN ( (1,1), (2,1) )
I replaced "," with SPACE and ";" but got error.
It will be appreciated to help me to solve this problem.
Source:Problem with IN predicate
Nyt on maamme tiedotusmonopoleissa tullut tavaksi vedättää esiin sellaisia
tietoja, että riisin- ja viljanhinnan nousu johtuisi siitä, että niitä
käytetään eläinrehuina lihantuotantoon.. .Haloo kuka on nähnyt "riisirehua"?
Veikkaan että kyseessä on maailman harvinaisin sbesiaalirehupussukka, jota
Source:Re: ADVICE NEEDED: Removing Inner Tie Rod Ends - TWO QUESTIONS
Hi!
Yes, I tried that and the script complained that there is no
SYSPROC.EXPLAIN_GET_MSG2 function, which led me to conclusion that
Databse Instance was not migrated, but running db2imirgr sayed that it
cannot migrate the instance since it already is migrated. Go figure.
Now I’m wandering in the dark.
Source:Re: db2exfmt and missing function EXPLAIN_FORMAT_STATS
Hi All,
We are testing one of our component with JDBC + DB2 using db2jcc
driver. We afced a strange issue.
Scenario is like this.
1. We insert 1 record to a table having IDENTITY column as the primary
key and retrieve the newly inserted identity value using
getGeneratedKeys() API of JDBC 3.0. It works fine
Source:DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generated field
Helpful folks,
We recently upgraded DB2 V7 to V8 on Windows 2003 Enterprise Edition.
The plan is to migrate to V9 as soon as possible. In anticipation of
that migration, IT management has decided that all our user desktop
workstations (a few hundred) should be upgraded to the V9 runtime
client before we migrate the server to V9. This upgrade process will
Source:V9 runtime client setup problems
This has become a performance tuning thread, but I’d use a cursor load
instead, great speed, no space usage..
Source:Re: Any suggestion on how to speed up large batch inserts?