Creating an index on a Microsoft Access Table via SQL using RPG2SQL

You can use the CREATE INDEX SQL statement with RPG2SQL to build an index on a Microsoft Access Table or other SQL table. Indexes speed up SQL data searches.

 

The following example 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);')