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.