Custom connection properties used by 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.

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.

For a list of all the standard connection properties that are available to the Triple-S DSC, see Connection properties.

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.

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.

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.