The User-Close in a CALL DML application closes all the requesting user’s logical files. After the successful execution of User-Close, all resources of the logical files of this user are released.
Within an SQL application it is not possible to terminate an SQL conversation explicitly. The resources of an SQL conversation are not released until the associated TIAM application has terminated. Under openUTM, the resources of an SQL conversation are released when the associated UTM conversation terminates.
There is no statement in SQL which is equivalent to a User-Close in a CALL DML application. If a CALL DML statement contains multiple User-Close statements you should therefore increase the DBH option USERS before you switch to the SQL interface. In this way, you can avoid resource bottlenecks.