Write by Loader

Operation Name

Write by Loader

Function Overview

Write the content of the file to the table using loader.
High-speed processing is possible by using SQL loader of the database client.

Properties

For information about using variables, refer to "variables".

Basic settings

Item name	Required / Optional	Use of Variables	Description	Remarks
Name	Required	Not available	Enter the name on the script canvas.

Required settings

Item name	Required / Optional	Use of Variables	Description	Remarks
Destination	Required	Not available	Select Global Resources. [Add]: Adds new global resource. [Edit list]: Global resource settings can be edited by "Edit resource list".
Table name	Required	Available	Select or enter the name of the table to write.	The maximum number of tables listed is determined by Global Resource settings.
Enclose table name with quotation marks	Optional	Not available	Select whether enclosed the specified table name with quotation marks. [Checked]: Enclose table name displayed in [Table name] in quotation marks. [Not Checked]: (default) Do not enclose table name displayed in [Table name] in quotation marks. Or if the table name contains characters such as spaces, it must be enclosed in quotation marks.For characters that require quotes, please contact the database vendor.	Quotes is "[]<" (Square brackets). When executing, uses directly the table name as entered in [Table name]. When the table name entered in [Table name] is enclosed with quotation marks, the setting file of loader will also be saved with table name enclosed in quotation marks in execution. When not enclosing table name entered in [Table name] with quotation marks, the validity of this property will be check first during execution, when it is valid, the query will also be issued with quoted table name. Environment variables referenced in [Table name] are expanded when this property is enabled.
Data file	Required	Available	Enter the path of the data file.	Valid path from the server on which SQL Server is operating must be specified. In case of the remote file, UNC (Universal Naming Convention) is specified.
Format file	Optional	Available	Enter the full path of the format file.	Valid path from the server on which SQL Server is operating must be specified. In case of the remote file, UNC (Universal Naming Convention) is specified. Refer to "Notation of Format File" about the notation of format file.
Delimiter	Optional	Available	Enter or select data file delimiter. [,](single-byte comma):(default) Specify comma as a delimiter. [ ](single-byte space): Specify a space as a delimiter. [<TAB>](tab): Specify tab as a delimiter.	Disabled when [Format file] is specified.
Schema definition	Required	-	Shows the schema definition specified in [Table name].	Schema definition cannot be viewed in the following cases. If do not have read permissions to the specified table If the specified table does not exist If [Table name] is specified by variable If [Table name] is not entered If error occurs in [Table name]
Schema definition / Column name	Required	Not available	Shows the column name of the table specified in [Table name].
Schema definition / Type	Required	Not available	Select [Column name] type.	Displayed in the format of "Native type (Internal data type)" . Native type: The data type of each specific RDBMS. Internal data type Data type used internally in DataSpider. Refer to "internal data type" for details.

Property Action

Item name	Description	Remarks
Launch Table Browser	Launches the Table Browser. See Table Browser for the operating procedure	Enabled when [Destination] is selected. Table name specified in the [Table name] is displayed initially.

Comment

Item name	Required / Optional	Use of Variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

Schema

Input Schema

None.

Output Schema

None.

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component variables

Component variable name	Description	Remarks
return	Returns the return value of the started loader.	The value defaults to null.
message_category	Stroes the category to which corresponding message code belongs to, when an error occurs.	The value defaults to null.
message_code	Stores its corresponding message code of occured error.	The value defaults to null.
message_level	Stores the severity of the corresponding message code of the occured error.	The value defaults to null.
error_type	Stores the type of the occured error.	The value defaults to null. Error is represented in the format depicted below. Example:java.io.FileNotFoundException The message may vary depending on the DataSpider Servista version.
error_message	Stores the error message for the occured error.	The value defaults to null. The message may vary depending on the DataSpider Servista version.
error_trace	Stores stack trace of the occurred error.	The value defaults to null. The message may vary depending on the DataSpider Servista version or the client application used.

Specification Limits

Depending on the number of tables in the database, it may take some time to open the property settings dialog, if the upper limit for displaying tables is not properly configured.

See DB adapter Limitations for specification limitations specific to different database adapters.

Main exceptions

Exception name	Cause	Actions
ResourceNotFoundException Resource definition could not be found.Name: []	[Destination] is not specified.	Specify [Destination].
ResourceNotFoundException Resource definition could not be found.Name: [<Global resource name>]	Resource definition selected in [Destination] is not found.	Please check the global resource specified in [Destination]
InvalidPropertyConfigurationException <Property name> is not specified.	[<Property name>] is not specified.	Specify the [<Property name>].
java.io.IOException	Loader command failed to start.	Check that the loader is installed and whether the starting path is valid.
java.sql.SQLException	Database access error or other error occurred.	Check the message of SQLException.SQLException message is based on the specifications of each driver.SQLException messages may outputs cause of the error. For more information about the message, please contact each database vendor.