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);')
Last Modified On:
No, open a new Support Case