User`s guide

7 Functions — Alphabetical List
7-118
Commit the data.
sqlquery = 'commit';
exec(conn,sqlquery);
After finishing with the cursor object, close it.
curs = ans;
close(curs)
Change the Database Connection Catalog
Change the catalog for the database connection conn to intlprice.
sqlquery = 'Use intlprice';
curs = exec(conn,sqlquery);
After finishing with the cursor object, close it.
close(curs)
Create a Table and Add a New Column
Use the SQL CREATE command to create the table.
sqlquery = ['CREATE TABLE Person(LastName varchar, '...
'FirstName varchar,Address varchar,Age int)'];
Create the table for the database connection object conn.
exec(conn,sqlquery);
Use the SQL ALTER command to add a new column, City, to the table.
sqlquery = 'ALTER TABLE Person ADD City varchar(30)';
curs = exec(conn,sqlquery);
After finishing with the cursor object, close it.
close(curs)
Call a Stored Procedure Without Input and Output Arguments
Using a Microsoft SQL Server database, run a stored procedure using the native ODBC
database connection conn.