Creating an index on a MS Access Table via SQL using the RPG2SQL Integrator

From Support

The CREATE INDEX SQL statement can be used to build an index on a MS Access Table or other SQL table via the RPG2SQL Integrator. Indexes speed up SQL data searches.

The sample listed below creates an index named: IdxFirstLast against the NameAddress table to speed up searches by first and last name.

-----------------------------------------------------------------------
** Run SQL create index query to build an index          
** by first and last name called: IdxFirstlast           
 -----------------------------------------------------------------------
               Eval      Rtn = SQL_RunSQLExec(SQL_Socket:               
                         'CREATE INDEX IdxFirstLast ON NameAddress ' +  
                         '(First,Last);')