This general macro detaches the TPF Application Requester (TPFAR) feature
Structured Query Language Transaction Profile (STP) and
associated blocks from an entry control block (ECB). The ECB must have
issued structured query language (SQL) requests. See DBSAC-Attach TPF Application Requester Database Support Structure for additional information.
Format
- label
- A symbolic name can be assigned to the macro statement.
- ID
- Specify one of the following:
- area
- The symbolic name of a fullword area containing the address of an 8-byte
contiguous area where the TPFAR database support structure identifier is
returned.
- reg
- A register, R0-R5, containing the address of a fullword area
containing the address of an 8-byte contiguous area where the TPFAR database
support structure identifier is returned.
- Note:
- The TPFAR database support structure identifier is needed to reattach the
TPFAR database support structure.
If the ID parameter is omitted or invalid, R1 is the default.
Entry Requirements
- R9 must contain the address of the ECB being processed.
- A TPFAR database support structure must be attached to the ECB.
- SQL requests must have been issued from the ECB.
Return Conditions
- Control is returned to the next sequential instruction.
- R6 contains these return conditions:
- 0 - DBSDC_SUCCESSFUL
- Completed successfully.
- 1 - DBSDC_NONE
- No TPFAR database support structure is attached to the ECB.
- The contents of R7, R14, and R15 are unknown. The contents of all
other registers are preserved across this macro call.
- The specified area contains the TPFAR database support structure
identifier needed to reattach the TPFAR database support structure
later.
Programming Considerations
- This macro can be executed on any I-stream.
- SQL requests must have been previously issued from the ECB.
- The TPFAR database support structure identifier returned is needed to
reattach the TPFAR database support structure later.
- If the TPFAR database support structures are not reattached using the
DBSAC macro, conversations with the remote database are lost until the next
IPL.
- The DBSDC macro uses short term pool files to save the database support
structure. The DBSAC macro must be issued before recycling the short
term pool directories.
- A system error with return results if no TPFAR database support structure
is associated with the current ECB.
Examples
None.