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);')

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016