QTP question. (Syed Shahul Hameed Mustaffa)

[Deskin, Bob]

PowerHouse itself comes with all components (QUICK, QUIZ, QTP, PDL, etc.) however licensing is based on what flavours and data access options you purchase. Axiant is similar in that it comes with all the pieces but you license what you use. And if you're running Axiant as thin client, you need PowerHouse as well.

As an example, let's say you had 5 developers and 50 users. You're using C-ISAM and Oracle on a UNIX box. You want 10 of your users to have QUIZ report writing capability. You would get one package with the PowerHouse product and all data access middleware (for all of the data source we support). You would license, and get software enable keys, the following:

5 Development
40 Runtime (ability to execute compiled QUICK, QUIZ, QTP)
10 Runtime with Reporting (Runtime plus full QUIZ)
55 C-ISAM Data Access
55 Oracle Data Access

We license data sources that are not part of the operating system. So we do not require a key for MPE data sources such as KSAM and IMAGE that are part of MPE. But we do require a key for ALLBASE on MPE.

On OpenVMS, RMS (including RMS ISAM) comes with the OS, but RDB and Oracle do not, so they are licensed.

On UNIX and Windows, you don't get much, just sequential and direct files. SO indexed and relational are licensed separately.

The reason is that we incur development and support costs for the third party databases. In some cases, such as C-ISAM and D-ISAM, we pay royalties as well because we ship runtime libraries to allow you to use the product through PowerHouse.

As for indexed subfiles, they require an indexed file system. If the customer has not licensed one (on UNIX or Windows), then that feature will not work.

Bob

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com]On
Behalf Of fernando.olmos at hpa.com.au
Sent: August 25, 2005 7:12 PM
To: powerh-l at lists.sowder.com
Subject: RE: QTP question. (Syed Shahul Hameed Mustaffa)


Get a license!

Sorry, I could not resist.

I don't know this one. I am surprised. I thought COGNOS sold Powerhouse
with a single license agreement and it came with all the components
(QUIZ, QTP, QUICK, etc). How can you buy QUIZ without the ability of
doing indexed subfiles is beyond me. Maybe Bob can answer this better.

Cheers

------------


From: Syed Shahul Hameed Mustaffa <sshahulgm at gmail.com>
Subject: QTP question.

Dear Gurus,

Quick Intro: I'm migrating PH/MPEIX application to AXIANT-4GL/WINDOWS.

Please look at the following excerpt of code.
;-----------------------------------------------------------------------
----------------
request Extract-Rexam-Record

access REEXAM_D IN CWDB &
       link COMPUTER_NO to COMPUTER_NO of EVENT_D IN CWDB

choose EPISODE_TYPE "EXAM"

select if CW_DATE of REEXAM_D ge RX-DATE-FR and &
          CW_DATE of REEXAM_D le RX-DATE-TO and &
          EVENT_ACRONYM of REEXAM_D eq EVENT_ACRONYM of EVENT_D

subfile $UEV_SUBFILE_PATH\CW877SF1  KEEP include     &
        COMPUTER_NO of EVENT_D,           &
        EVENT_ACRONYM of EVENT_D,         &
        COMMENTS of EVENT_D,              &
        ED_DATE of EVENT_D,               &
        CW_DATE    &
       index COMPUTER_NO ;segment COMPUTER_NO  ;<---- THIS LINE

request Create-Final-Subfile

access   COW_LOC_D  IN CWDB                          &
   link UNIT_NO to UNIT_NO of UNIT_M  IN CWDB  &
   link CLD_COMPUTER_NO to CLD_COMPUTER_NO of COW_D IN CWDB &
  link CLD_COMPUTER_NO to COMPUTER_NO of *$UEV_SUBFILE_PATH\CW877SF1
;<---- THIS LINE
;-----------------------------------------------------------------------
--------------

The lines I have marked as THIS LINE cannot execute without a DISAM
license. How can I rewrite this code to execute without a DISAM license.

I'd appreciate every effort to help me out in this issue.

Best Regards,
SYED.
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended solely for the use of the individual or entity to whom they are addressed.  If you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au, then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the presence of computer viruses by MimeSweeper.  Before opening or using any attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more information about use, disclosure and access see our Privacy Policy at www.hpa.com.au
**********************************************************************

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.