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.