QTP question.
Deskin, Bob
Bob.Deskin at Cognos.COM
Sun Aug 28 06:22:40 CDT 2005
Two corrections:
First, PowerHouse still recognizes XBASE, however it does not use it for indexed subfiles.
Second, XBASE is not native to Windows, however it is free to use (as far as I know) and is somewhat limited compared to other indexed file systems.
It is this last point that prompted us to provide support for a more complete indexed file system. Axiant has always had problems with indexed files and indexed subfiles because of the limitations of XBASE compared with KSAM and C-ISAM. We knew this would be a problem for people migrating. Obviously we expect many of our customers to migrate to Windows from MPE but we also have a number of people migrating from OpenVMS as well as looking at Windows as an option to UNIX (for smaller systems). For all of these reasons we decided to provide a more complete indexed file system and DISAM was the one selected at the time (probably about 3-4 years back considering development time, beta testing, etc, etc).
Bob
-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: August 28, 2005 5:58 AM
To: Deskin, Bob; 'Syed Shahul Hameed Mustaffa'
Cc: powerh-l at lists.sowder.com
Subject: RE: QTP question.
Typically developers have indexed file access so they don't need to use
direct access.
As cognos no longer recognize the windows XBASE format ( why is that ? ),
which is presumably that OS's native indexed file system, so using direct
access to subfiles will be used more often - probably.
Regards, Joe.
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Deskin, Bob
Sent: 28 August 2005 02:47
To: Syed Shahul Hameed Mustaffa; atla38 at dsl.pipex.com
Cc: powerh-l at lists.sowder.com
Subject: RE: QTP question.
A non-indexed subfile can be linked using the record number. However, in
practise this is typically used only for a single record file. An
alternative is to put enough data in the subfile so that it can be used as
the driver for the linkage, i.e. the primary file in the ACCESS.
Bob
-----Original Message-----
From: Syed Shahul Hameed Mustaffa [mailto:sshahulgm at gmail.com]
Sent: August 27, 2005 12:08 PM
To: atla38 at dsl.pipex.com; Deskin, Bob
Cc: powerh-l at lists.sowder.com
Subject: Re: QTP question.
Dear Joe, Bob,
If I remove the index keyword, then, I could not use the subfile in
the subsequent requests to link with other tables. Am I correct?
Regards,
SYED
On 8/26/05, Joe Boyle <atla38 at dsl.pipex.com> wrote:
> I can see that Bob's option is the easiest to implement, but you could
> always implement the direct access method to subfiles; the disadvantage is
> that this will only work for single segment numeric indexes.
>
> The access syntax for this approach would be as follows,
>
> 'link to record COMPUTER_NO of *$UEV_SUBFILE_PATH\CW877SF1'
>
> but there would be no pre-sorting capabilities as is the case when
accessing
> subfiles via indexes.
>
> To use the option above you would have to create a subfile with at least
as
> many records as you have COMPUTER_NO's, and instead of writing the subfile
> from qtp, you would process a 'output update' run against the subfile
etc...
>
> Regards, Joe.
>
>
>
> -----Original Message-----
> From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
> [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf
Of
> Syed Shahul Hameed Mustaffa
> Sent: 25 August 2005 17:33
> To: powerh-l at lists.sowder.com
> Cc: Joe Boyle
> 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.
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" 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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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.
More information about the powerh-l
mailing list