Executing SQL Query in AX

UserConnection                  con;
    Statement                       stmt;
    ResultSet                       resultSet;
    SqlStatementExecutePermission   permission;
    str                             sql;
    ;
    sql = 'select * from HcmEmployment';
    permission = new SqlStatementExecutePermission(sql);
    permission.assert();

    con     = new userconnection();
    stmt    = con.createStatement();

    resultSet = stmt.executeQuery(sql);
    CodeAccessPermission::revertAssert();
    while (resultSet.next())
    {
     
           info(resultset.getString(1));

    }