Attributes
- url
- Required string. The database URL for the database server to which the SQL statement is sent, such as jdbc:as400://myHost.
- driver
- Required string. The fully qualified package name of the driver used to connect with the database server, such as COM.ibm.db2.jdbc.app.DB2DRIVER. This package must be present on the client workstation.
- userid
- Optional string. The user ID required to access the database, if one is required.
- password
- Optional string. The password required to access the database, if one is required.
- statement
- Required string. The SQL statement.
- outputtype
- Required integer. The destination where the data resulting from the SQL statement is to be directed. The valid value is: 0 - The data is stored in the macro variable $HMLSQLUtil$. You can retrieve the data by calling methods on the variable.