When working with data from systems external to ICA, there are cases where the data being served to ICA is provided in a comma separated list. ICA provides a function that can be leveraged to parse the data into prior to loading it into ICA. The target function that can be used is dbo.fnParseDelimitedList.
CAUTION: These commands assume a basic understanding of SQL. Any changes to the Database pose the potential to affect the operation of the product. ALWAYS ENSURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE MAKING CHANGES.
In order for Symantec to provide full support of the schema and the DB environment, you have to be running the DB in the version specific to the used version as outlined in the System Requirements Guide. Please see the limitations section at http://www.symantec.com/docs/TECH220433
Use the ICA function dbo.fnparseDelimitedList when bringing data into ICA. The fnParseDelimitedList will take a comma separated list in this case we are passing a string that contains the days of the week in a comma separated format. For format for the string is listed as fnParseDelimitedList(StringName,delimeter).
Subscribing will provide email updates when this Article is updated. Login is required.