TABLE IN FORMATION Option To preface our coverage of this option, note that READ and WRITE lock functions provide the following inputs: Variable Description SQLTBL Table number (from ^SQL(4) table). SQLROWID Table row primary key (delimited). Both the READ and WRITE locks use the variable SQLROWID to represent the composite of primary key columns. If the primary all key is composed of more than one column, you may need to enter a primary key delimiter value at the prompt in the Table Features window . This value should be an ASCII code representing a character that occur within any of the primary key component columns. does not The primary key delimiter separates the various primary key columns in the SQLROWID variable. If you do not enter a primary key delimiter, the tab character (ASCII code = 9) is used by default. The prompt determines Allow updates? if this table may be updated. If you enter NO, you are still allowed to enter READ lock logic. If you enter YES, you must enter WRITE lock/unlock and INSERT, UPDATE, and DELETE FILER logic in the sequential Update Table Logic window. The WRITE lock code sets an exclusive, persistent lock on the table SQLTBL and row SQLROWID. The WRITE unlock code clears a previously established WRITE lock. The use of the READ lock depends on the transaction’s isolation level and your current application’s code. If the transaction’s isolation level is READ UNCOMMITTED, the READ lock code is not executed. If the level is READ COMMITTED, the code should check to ensure
TABLE IN FORMATION Option To preface our coverage of this option, note that READ and WRITE lock functions provide the following inputs: Variable Description SQLTBL Table number (from ^SQL(4) table). SQLROWID Table row primary key (delimited). Both the READ and WRITE locks use the variable SQLROWID to represent the composite of all primary key columns. If the primary key is composed of more than one column, you may need to enter a primary key delimiter value at the prompt in the Table Features window . This value should be an ASCII code representing a character that does not occur within any of the primary key component columns. The primary key delimiter separates the various primary key columns in the SQLROWID variable. If you do not enter a primary key delimiter, the tab character (ASCII code = 9) is used by default. The Allow updates? prompt determines if this table may be updated. If you enter NO, you are still allowed to enter READ lock logic. If you enter YES, you must enter WRITE lock/unlock and INSERT, UPDATE, and DELETE FILER logic in the sequential Update Table Logic window. The WRITE lock code sets an exclusive, persistent lock on the table SQLTBL and row SQLROWID. The WRITE unlock code clears a previously established WRITE lock. The use of the READ lock depends on the transaction’s isolation level and your current application’s code. If the transaction’s isolation level is READ UNCOMMITTED, the READ lock code is not executed. If the level is READ COMMITTED, the code should check to ensure
_new_data_dictionary.docx