sp_mda is a stored procedure that retrieves metadata from the server. To support partial updates, your Open Server application must define an sp_mda stored procedure and specify the updatetext syntax that an Open Client application must use.
An Open Client application must invoke sp_mda using these parameters and values:
Parameter |
Value |
Description |
---|---|---|
clienttype |
5 |
5 indicates that the client is Client-Library. |
mdaversion |
1 |
|
clientversion |
0 |
clientversion is an optional parameter that indicates the client version. The default is 0. |
If the server supports partial updates, sp_mda returns:
Parameter |
Value |
---|---|
mdinfo |
“UPDATETEXT” |
querytype |
2 |
query |
updatetext_syntax Example: updatetext ? ? ? {NULL | ?} {NULL | ?} where “?” indicates the updatetext parameters. |
See the Mainframe Connect DB2 UDB Options for IBM CICS and IMS Installation and Administration Guide. For a sample implementation of sp_mda, see $SYBASE/$SYBASE_OCS/sample/srvlibrary/updtext.c.