Execute SQL command

static void Job3(Args _args)

{

LogInProperty Lp = new LogInProperty();

OdbcConnection myConnection;

Statement myStatement;

ResultSet myResult;

str sqlQuery;

;



sqlQuery = 'SELECT TOP 10 * FROM CustTable ORDER BY NewID()';



LP.setServer("Server");

LP.setDatabase("db");

Lp.setUsername("user");

Lp.setPassword("password");



try{

myConnection = new OdbcConnection(LP);

}

catch{

info("Check username/password.");

return;

}



myStatement = myConnection.createStatement();

myResult = myStatement.executeQuery(sqlQuery);



while (myResult.next())

{

box::info(myResult.getString(1));

}

}