SAP Sybase IQ provides a low-level interface to the SAP Sybase IQ C API. The API described in the following sections permits the rapid development of SQL applications. To demonstrate the power of Ruby application development, consider the following sample Ruby program. It loads the SAP Sybase IQ Ruby extension, connects to the sample database, lists column values from the Products table, disconnects, and terminates.
begin require 'rubygems' gem 'sqlanywhere' unless defined? SQLAnywhere require 'sqlanywhere' end end api = SQLAnywhere::SQLAnywhereInterface.new() SQLAnywhere::API.sqlany_initialize_interface( api ) api.sqlany_init() conn = api.sqlany_new_connection() api.sqlany_connect( conn, "DSN=Sybase IQ Demo" ) stmt = api.sqlany_execute_direct( conn, "SELECT * FROM Products" ) num_rows = api.sqlany_num_rows( stmt ) num_rows.times { api.sqlany_fetch_next( stmt ) num_cols = api.sqlany_num_cols( stmt ) for col in 1..num_cols do info = api.sqlany_get_column_info( stmt, col - 1 ) unless info[3]==1 # Don't do binary rc, value = api.sqlany_get_column( stmt, col - 1 ) print "#{info[2]}=#{value}\n" end end print "\n" } api.sqlany_free_stmt( stmt ) api.sqlany_disconnect(conn) api.sqlany_free_connection(conn) api.sqlany_fini() SQLAnywhere::API.sqlany_finalize_interface( api )
The first two rows of the result set output from this Ruby program are shown below:
ID=300 Name=Tee Shirt Description=Tank Top Size=Small Color=White Quantity=28 UnitPrice=9.00 ID=301 Name=Tee Shirt Description=V-neck Size=Medium Color=Orange Quantity=54 UnitPrice=14.00
The following sections describe each of the supported functions.