Locking Sequential Files in QTP
Terry Pickering
pickering@myself.com
Tue, 13 Jul 1999 14:37:51 -0700
I have a sample QTP run that demonstrates you can not access a SEQUENTIAL
file in more than one request within a QTP run.
In the example below, the file GLS-INTERFACE is a sequential file that has
just been built and is empty. The first request reads a file and outputs
records to the sequential file. The second request then reads the
sequential file and creates a subfile.
I've tried everything including alias names on the all of the files. Added
SET FILE and SET LOCK statements. Nothing prevents this from happening:
~~~~~~~~~~~~~~~~~~~~~~ P A S T E ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Q T P (7.10.F4)
Copyright 1996 COGNOS INC. (ALPHA)
> USE TP025
>
> ;*******************************************************************
> REQUEST CREATE-RECORDS
> ;*******************************************************************
> ACCESS WPS-ACCT-DISTRIB
> OUTPUT GLS-INTERFACE ADD
>
> ;*******************************************************************
> REQUEST CREATE-SUBFILE
> ;*******************************************************************
> ACCESS GLS-INTERFACE
>
> SUBFILE INTERFACE-OFFSET KEEP INCLUDE GLS-INTERFACE
> GO
----------------------------------------------------------------------------
---
Data access error. (GLS-INTERFACE)
File: GLS_DAT:GLS014
Action Taken: Run terminated.
----------------------------------------------------------------------------
---
%RMS-E-FLK, file currently locked by another user
File: GLS_DAT:GLS014
----------------------------------------------------------------------------
---
%SYSTEM-W-ACCONFLICT, file access conflict
File: GLS_DAT:GLS014
----------------------------------------------------------------------------
---
Changes made since the last commit have been rolled back to a stable state.
Therefore, statistics reported may be incorrect.
----------------------------------------------------------------------------
---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Terry Pickering Consultant Extraordinare
Monday and Friday Tuesday - Thursday
Portland Eugene
(503) 245-7178 (541) 687-3416
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.