SQL_DISCONNECT
This activity closes an SQL database connection previously established using the SQL_CONNECT activity.
Once the database connection has been closed, the connection handle value is no longer valid and cannot be used again in further SQL database activities.
If you do not execute the SQL_DISCONNECT activity for an open SQL database connection before the end of your processing sequence, LANSA Composer will automatically disconnect it. However, it is recommended that you explicitly disconnect using this activity as soon as the SQL database connection is no longer required. For more information on this, refer to:
Eligibility for Processing Sequence Restart
For more information about the SQL database activities, refer to the description of the SQL_CONNECT activity. For a list of supplied working (*) examples using the SQL database activities, refer to:
Example Processing Sequences using the SQL database activities
INPUT Parameters:
SQLHANDLE : Required
This parameter must specify the connection handle value that identifies the SQL connection upon which this activity should operate. The connection handle value is returned by the SQL_CONNECT activity.
OUTPUT Parameters:
There are no output parameters.