What's new and changed in SDL Contenta S1000D 5.7.1
This section describes new features, feature enhancements and other changes in the 5.7.1 release of SDL Contenta S1000D.
Adding linkends table indexes on an Oracle database
Perform the following steps to confirm that the required linkends table indexes linkends_4 and linkends_5 are missing and, if necessary, add them for an Oracle database.
- In Windows, open a command prompt.
- Open a SQL*Plus prompt by entering the following at the command prompt.
sqlplus database/password@SID
where database is the name of the database, password is the password to access it, and SID is its Oracle SID.
- At the SQL*Plus prompt, enter the following.
select index_name from user_indexes where table_name='LINKENDS';
- Press Enter. SQL*Plus searches for indexes whose names contain the string
LINKENDS. - If the SQL*Plus output does not contain the string
linkends_4, at the SQL*Plus prompt, enter create index linkends_4 on linkends(linkendstitle); and press Enter to add the index. - If the SQL*Plus output does not contain the string
linkends_5, at the SQL*Plus prompt, enter create index linkends_5 on linkends(linkendstitle); to add the indeex and press Enter to add the index. - To close the SQL*Plus window, enter EXIT and press Enter.
- Close the Windows command prompt.
Adding linkends table indexes on a SQL Server database
Perform the following steps to confirm that the required linkends table indexes linkends_4 and linkends_5 are missing and, if necessary, add them for a SQL Server database.
- In Windows, open a command prompt.
- Execute the following at the command prompt.
sqlcmd -S SQL Server Name -U database -P password -Q "select name from sysindexes where name like %linkends%;" and press Enter to execute the command.
where SQL Server Name is the name of the SQL server, database is the name of the database, and password is the password to access the database.
- If the sqlcmd output does not contain the string
linkends_4, at the command prompt, enter sqlcmd -S SQL Server Name -U database -P password -Q "CREATE INDEX [LINKENDS_4] ON [dbo].[linkends]([LINKENDTITLE]);" and press Enter to add the index. - If the sqlcmd output does not contain the string
linkends_5, at the command prompt, enter sqlcmd -S SQL Server Name -U database -P password -Q "CREATE INDEX [LINKENDS_5] ON [dbo].[linkends]([LINKENDTITLE]);" and press Enter to add the index. - Close the Windows command prompt.