Previous Topic: Restarting ProgramsNext Topic: FOR EACH/FIRST/ANY Statement (CA Datacom/DB Native Access)


Sequential Processing

CA Ideal can do multi‑block read‑aheads of a CA Datacom/DB non‑SQL table using the GETIT command if certain conditions are met. For more information, see the CA Datacom/DB Database and System Administrator Guide. In this case, exclusive control is acquired for an entire block of records as it is read, even though the program might not be updating all records. If you also use AUTODXC=NO, the exclusive control is maintained up to the next CHECKPOINT, if any.

There is no way to request a release of exclusive control for a record in that block, even if the application did not read it. So do not use sequential processing if your program needs to have a QUIT in any FOR construct because you cannot release exclusive control of records in the block that were not yet accessed by the FOR.

Even read‑only applications can acquire exclusive control for a block of records. This is because such applications need to run with UPDATE=YES so that Compound Boolean Selection access can update the database index for the table. Again, do not use sequential processing if your program needs to have a QUIT in any FOR construct.