Online and multitasking environment considerations

When accessing tables in an online transaction-oriented environment, or multitasking environment such as a DB2 stored procedure address space (SPAS), the commands ML and CS operate on a transaction basis. Each transaction is initialized with a default library search order (LIB-LIST), default status switches, and VTSNAME, but has the ability to set and modify these settings. Each transaction is considered as a distinct thread of execution; the settings used in one transaction are not retained for the next transaction.