TeleFlow Step 0815

TeleFlow Step 0815

From TeleFlow

Jump to: navigation, search

Image:Iv_815.gif DB Lock Step
Locks the most recently fetched record so that no other application is able to update it. An attempted update will result in a failure. The lock is released once a SQL End or a SQL End Transaction is encountered.

Note: Please refer to the SQL Users Guide for more information about SQL programming in TeleFlow.

Properties

SQL handle: Each subsequent SQL command to the SQL Statement must be assigned a matching number, or handle, in order relate commands together. This number must range from one to nine. e.g.: 1 or @HANDLE

Action Steps

Image:Iv_930.gif Failure

Related Steps

Image:Iv_800.gif DB Connect
Image:Iv_805.gif DB Disconnect
Image:Iv_820.gif SQL Begin Transaction
Image:Iv_825.gif SQL End Transaction
Image:Iv_830.gif SQL End
Image:Iv_835.gif SQL Fetch
Image:Iv_810.gif SQL Statement

Retrieved from "http://teleflow.org/wiki/index.php5?title=TeleFlow_Step_0815"