This article explains how you can view or change the properties for a ClicknDECiDE Builder Database Output format.
What do you want to do?
View
Database Output Format Properties
Change Database Output Format Properties
Change
Database Output Format Properties on the Connection Tab
Change
Database Output Format Properties on the Options Tab
View Database Output Format Properties
To view Database Output Format Properties, perform the steps below:
Select the Database output format you want to modify.
Either double-click the Database output format or right-click the Database output format, and click Properties...
Change Database Output Format Properties
To change Database Output Format Properties, perform the steps below:
Select the Database output format you want to modify.
Either double-click the Database output format or right-click the Database output format, and click Properties...
Select
the tab as appropriate:
Connection tab
Options tab
Change Database Output Format Properties on the Connection Tab
The Connection tab displays the list of current data sources that have already been defined.
Select the data source you want to parameterize.
Click OK or click the Options tab.
Change Database Output Format Properties on the Options Tab
The Options tab is specific to the Database Output format and enables users to specify the following parameters when exporting data for the Database output format.
Convert field name to uppercase: transforms lowercase field names to uppercase characters. Select this option if the target database only accepts uppercase characters or if you only want to use uppercase characters.
Replace blank by '_': transforms blank characters into underscore '_' characters in field names. Select this option if the target database does not accept blank characters in field names.
Keep regular chars only [0..9],[A..Z]: limits the characters in field names to regular alphanumeric characters (such as numbers between 0 and 9 and letters between A and Z), and excludes non-alphanumeric (reserved) characters (&,?, /, §, !, %, etc.) or characters with an accent (ü,ä, ë, é à , è; ù etc.). Select this option if the target database only accepts regular alphanumeric characters in field names.
Maximum column name length (0=no limited): the maximum number of characters for a column name. By default, 0, meaning that there is no limit to the number of characters in a column name.
Rename duplicate heading with number: replaces duplicate headings with a number.
Use Bulk Copy: this option only appears for a Local SQL Server or SQL Server database as it is not supported by other databases. The Bulk Copy option enables users to send data rapidly to an SQL Server database or similar technology database.
Warning: the query must have no more than 90 selected columns if you want to use the Bulk Copy facility. The Local Database is an MSDE database (MicroSoft Data Engine).
|
See Also |
