WebFocus Custom Query Example

May 16th, 2008

-* File db2stest.fex
ENGINE DB2 SET DEFAULT_CONNECTION DB2
SQL DB2 PREPARE SQLOUT FOR
select * FROM DB2SCHEMA.MYTABLE
;
END

TABLE FILE SQLOUT
PRINT
*
END

Web focus No Data HTML Output Redirect

May 16th, 2008

With web focus when you have no data returned from your query and want a simple way of redirecting the page. Use the following code example.

SET EMPTYREPORT=ON
TABLE FILE CAR
PRINT *
ON TABLE HOLD AS MYTAB FORMAT HTMTABLE
END
-RUN
-SET &HOWMANY = &LINES ;
-HTMLFORM BEGIN


-IF &HOWMANY GT 0 GOTO no.redirect ;
CONTENT="5 ;
URL=http://the page you want to redirect to">

-no.redirect
!IBI.FIL.MYTAB;
-HTMLFORM END

Developing a Preliminary Project Scope Statement

May 11th, 2008

Input

  1. Project Charter
  2. Statement of Work
  3. Enterprise Environment Factors
  4. Organizational Process Assets

Tools

  1. Project Management Methodology
  2. Project Management Information System
  3. Expert Judgment

Output

  1. Project and Product Objectives
  2. Product or Service Requirements and Characteristics
  3. Project Boundaries
  4. Project Reject Requirements and Deliverables
  5. Product Acceptance Criteria
  6. Project constraints
  7. Initial Project Organization
  8. Initial Define Risks
  9. Schedule Milestones
  10. Initial Work Breakdown
  11. Order of Magnitude Cost Estimates
  12. Project Configuration Management Requirement
  13. Approval Requirement

Developing a Project Charter

May 11th, 2008

A project charter is important starting point to project because is helps define the following:

  1. Gives the PM confidence to start work on the project
  2. Gives Team assurance
  3. Assurance the project is link to the goals of the organization

The following is inputs, tools and techniques, and out put the development of a project charter

INPUT

  1. Contract
  2. Statement of work
  3. Enterprise Environment
  4. Organization Process

TOOLS and TECHNIQUES

  1. Project Selection Methods
  2. Project Manage Methodology
  3. Project Management Information System
  4. Expert Judgment

OUTPUT

  1. Project overview
  2. Preliminary Roles and Responsibility
  3. Identification of the project manager
  4. Description of project management authority
  5. Sign-off