Using a CALL statement to obtain map metadata
The IBM Data Virtualization Manager for z/OS Interface for ACI allows users to view metadata information for CMI and SMO maps on the client with a simple CALL statement. This allows a user to pass all the input parameters with the correct data types as required by the CMI or SMO without having to go into the server ISPF panels to locate this information.
The format of the CALL statement is:
CALL DVS_MAP('DESCRIBE','mapname')
where mapname is the name of the map.
The CALL statement returns a result set with a single column named FORMAT. This column contains details on the fields of the map. The following table describes the FORMAT column types and their SQL equivalents.
| FORMAT types | SQL types |
|---|---|
| CHARACTER | SQL_CHARACTER |
| NUMERIC | SQL_NUMERIC |
| DECIMAL | SQL_DECIMAL |
| INTEGER | SQL_INTEGER |
| SMALLINT | SQL_SMALLINT |
| FLOAT | SQL_FLOAT |
| DOUBLE | SQL_DOUBLE |
| DATE | SQL_DATE |
| TIME | SQL_TIME |
| TIMESTAMP | SQL_TIMESTAMP |
| VARCHAR | SQL_VARCHAR |
| LONGVARCHAR | SQL_LONGVARCHAR |
| BINARY | SQL_BINARY |
| VARBINARY | SQL_VARBINARY |
| LONGVARBINARY | SQL_LONGVARBINARY |
| UNICODE | SQL_UNICODE |
| UNICODE_VARCHAR | SQL_UNICODE_VARCHAR |
| UNICODE_LONGVARCHAR | SQL_UNICODE_LONGVARCHAR |