Skip to main content

EXTFH and With Rollback

  • January 21, 2014
  • 1 reply
  • 0 views
D

I want to convert my program that currently uses EXTFH to FHREDIR and make use of the Fileshare transactions.  The doc says that to start a transaction:

A transaction starts when your program performs the first update operation (WRITE, REWRITE or DELETE) on a file which has the WITH ROLLBACK clause defined in its SELECT statement after:

  • The file is opened
  • A COMMIT or ROLLBACK statement is executed

I am trying to figure out how to set the FCD to have the equivalent of that WITH ROLLBACK in a select.  I've looked through the various FCD settings and don't see it so far.  Please help if you can.


#NetExpress5.0
#fhredir

1 reply

Chris Glazier
Forum|alt.badge.img+3

I want to convert my program that currently uses EXTFH to FHREDIR and make use of the Fileshare transactions.  The doc says that to start a transaction:

A transaction starts when your program performs the first update operation (WRITE, REWRITE or DELETE) on a file which has the WITH ROLLBACK clause defined in its SELECT statement after:

  • The file is opened
  • A COMMIT or ROLLBACK statement is executed

I am trying to figure out how to set the FCD to have the equivalent of that WITH ROLLBACK in a select.  I've looked through the various FCD settings and don't see it so far.  Please help if you can.


#NetExpress5.0
#fhredir

In the FCD you should see the following section which contain the fileshare flags.

         40  FCD-FS-FLAGS          pic x comp-x.

             78 fcd--transaction-processing-bit  value h"80".

             78 fcd--recovery-run-b           value h"04".

             78 fcd--fs-server-bit            value h"02".

I believe that all you have to set is the fcd-transaction-processing-bit and this will be evivalent to setting the WITH ROLLBACK option in the SELECT.

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement