Creating and accessing tables
The following examples illustrate how to create a table named PEOPLE, which store the name, address, and phone number of a customer. This example contains three blocks of code:
•The first snippet creates a CLI connection to a local DB2 database. Modify the code for other databases in the following manner:
a. Oracle
1. Change #AbtIbmCliDatabaseManager to #AbtOracle10DatabaseManager
2. Change ‘SAMPLE’ to ‘’
b. ODBC
1. Change #AbtIbmCliDatabaseManager to #AbtOdbcDatabaseManager
2. Change ‘SAMPLE’ to the name of your ODBC connection to the SAMPLE database
c. SQlite
1. Change #AbtIbmCliDatabaseManager to #AbtSQLiteDatabaseManager
•The second snippet shows how to create the PEOPLE table for all supported databases.
•The third snippet shows how to return the names of all columns in the PEOPLE table for all supported databases.
"Snippet #1: Execute the code to Establish a connection to the database"
(AbtDatabaseConnectionSpec forDbmClass: AbtIbmCliDatabaseManager
databaseName: 'SAMPLE') connectUsingAlias: 'SampleConSpec'
logonSpec: (AbtDatabaseLogonSpec new
id: 'userid';
password: 'password';
server: '').
"Snippet #2: Execute the code to Create a table in the current database"
| sqlDef table connection |
sqlDef := '(NAME varchar(30) NOT NULL,',
' STREET varchar(20),',
' CITY varchar(20),',
' STATE varchar(2),',
' ZIPCODE int,',
' PHONE varchar(13))'.
connection := AbtDbmSystem activeDatabaseConnectionWithAlias: 'SampleConSpec'.
table := connection createTableNamed: 'PEOPLE' definition: sqlDef.
"Snippet #3: Display the code to view column names"
| connection |
connection := AbtDbmSystem activeDatabaseConnectionWithAlias: 'SampleConSpec'.
(connection openTableNamed: 'PEOPLE')
columnNames.
Last modified date: 01/29/2015