ADO.NET   You can execute SQL statements using a variety of ADO.NET objects. The SACommand object is one example:

SACommand cmd = new SACommand( "DELETE FROM Employees WHERE EmployeeID = 105", conn ); cmd.ExecuteNonQuery();

See SQL Anywhere .NET Data Provider.

ODBC   If you are writing directly to the ODBC programming interface, your SQL statements appear in function calls. For example, the following C function call executes a DELETE statement:

SQLExecDirect( stmt, "DELETE FROM Employees WHERE EmployeeID = 105", SQL_NTS );

See SQL Anywhere ODBC API.

JDBC   If you are using the JDBC programming interface, you can execute SQL statements by invoking methods of the statement object. For example:

stmt.executeUpdate( "DELETE FROM Employees WHERE EmployeeID = 105" );

See SQL Anywhere JDBC driver.

Embedded SQL   If you are using embedded SQL, you prefix your C language SQL statements with the keyword EXEC SQL. The code is then run through a preprocessor before compiling. For example:

EXEC SQL EXECUTE IMMEDIATE 'DELETE FROM Employees WHERE EmployeeID = 105';

See SQL Anywhere embedded SQL.

Sybase Open Client   If you use the Sybase Open Client interface, your SQL statements appear in function calls. For example, the following pair of calls executes a DELETE statement:

ret = ct_command( cmd, CS_LANG_CMD, "DELETE FROM Employees WHERE EmployeeID=105" CS_NULLTERM, CS_UNUSED); ret = ct_send(cmd);

See Sybase Open Client API.

Application development tools   Application development tools such as the members of the Sybase Enterprise Application Studio family provide their own SQL objects, which use either ODBC (PowerBuilder) or JDBC (Power J) internally.