set file command

[Joe Boyle]

I think cognos dropped the ability to read tables in read only mode, and I
think BobD said they were looking at an enhancement to bring this back in a
later PH8 version.

Probable best option is 'commit at update', which only locks a row at the
actual moment it will be updated; the trade off is run-time, so possibly
'commit at 100' to reduce the lock time or even 'commit at sort-item' where
the concurrency TX means tables arn't locked for the duration of the qtp.

Regards, Joe. 
________________________________________
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
Johnson, Harold A EDUC:EX
Sent: 09 December 2005 17:32
To: powerh-l at lists.sowder.com
Subject: set file command

A question regarding the "set file" command in QTP.  Recently, we were
running a new process in QTP which had a large number of links, but each
file was mentioned in a "set file xxx open read" statement.  However, during
the run, this process caused a lock on a table!   Is this syntax not
applicable anymore?    If so, what syntax should we be using?  ie: "set file
xxx open 1" ??
 
thnx
 
 
OpenVMS v7.3-2      RDB v7.1-241      PH  v7.10.G1