Custom connection properties used by the Triple-S DSC
This topic describes the custom connection properties that are unique to the Triple-S DSC.
You can specify custom connection properties by adding the MR Init Custom or MR Custom connection property to the connection string.
Format
MR [Init] Custom = "<property name> = <value> (; <property name> = <value>)*"
Example
MR Init Custom = "SssFormat = csv; DefTextVarSize = 30"
Use the MR Init Custom property when you connect using the OLE DB Provider, for example, in DM Query or in a data management (.dms) script. If you are passing connection properties to a Triple-S DSC object that you have created programmatically, use the MR Custom property.
Connection properties
For a list of all the standard connection properties that are available to the Triple-S DSC, see
Connection properties.
DefTextVarSize
When writing to Triple-S files, a Long value that defines the default size for Triple-S character variables. If this connection property is not set, the Triple-S DSC sets the size of the character variable to the value of the corresponding MDM variable's
EffectiveMaxValue property. For more information, see
Variable definitions when writing to Triple-S files.
RewriteColumnInfo
When writing to Triple-S files, a long value that specifies whether the Triple-S DSC uses the Metadata Model to Quantum component to clear any existing card and column custom properties before allocating new ones. A value of 1 specifies that Metadata Model to Quantum will delete any existing card and column properties before creating new ones. A value of 0 specifies that Metadata Model to Quantum will attempt to create card and column properties without deleting any existing ones. The default value is 0.
When the value of RewriteColumnInfo is 0, the Triple-S DSC will issue an error message if the existing card and column property values are not suitable for creating Triple-S files.
SssFormat
When writing to Triple-S files, a string value that defines the format of the case data. If the value is "fixed" (or any value except "csv"), the case data will consist of fixed-format fields. If the value is "csv", the case data will consist of comma-separated values. For more information, see
Specifying the format of the Triple-S file.
UseCodeForCategoryNames
True generates category names that are based on codes instead of on labels, for example, _1, _1, _3.
If the code is a negative number, the absolute value is used and the name is prefixed by two underscore characters; for example, -99 becomes __99.
If categories have long labels, this option generates smaller metadata files, and might be faster.
See also