Write by Loader

Operation name

Write by Loader

Function Overview

Write file contents to a table using Loader.
The operation is performed at a high speed as SQL Loader of your database client is used.

Properties

For details on use of variables, refer to “Variables”.

Basic settings

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

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Destination	Required	Not available	Select a global resource. [Add]: Add a new global resource. [Edit list]: Global resource settings can be edited in “Edit resource list” screen.
Table name	Required	Available	Select or enter a table name to be written to.	Tables of the number specified in the global resource's list settings are displayed. When a schema or table name in the database includes “.”, you can handle the name properly by enclosing it with quotation marks. For example, when the quotation mark is ["] and the schema and table name are “A.B” and “C.D” respectively, the proper way to enclose is ["A.B"."C.D"].
Enclose table name with quotation marks	Optional	Not available	Select whether or not to enclose the specified table name with quotation marks. [Checked]: Table name displayed in [Table name] is enclosed with quotation marks. [Not checked]: (default) Table name displayed in [Table name] is not enclosed with quotation marks. If the table name includes characters like space, you need to enclose the table name with quotation marks. For details on characters that need to be enclosed with quotation marks, inquire the database vendor.	Quotation marks is [""] (double quotations). At the time of execution, the table name input in [Table name] is applied as is. If the table name entered in [Table name] is enclosed with quotation marks, save the loader configuration file with the table name enclosed with quotation marks at the time of execution. If the table name entered in [Table name] is not enclosed with quotation marks, this property will be checked at the time of execution, and if this property is enabled, a query will be issued with the table name enclosed with quotation marks. When environment variables are used in [Table name], the value is deployed when enabling/disabling this property.
Net service name	Required	Available	Enter the Oracle net service name.	The net service name should be registered beforehand.
Data file	Required	Available	Enter the data file path. You can click [Browse] button to launch file chooser and find the file.	Specify that as absolute path of the server OS local file system. Writing using a fixed length file is not supported.
Delimiter	Optional	Available	Enter or select a delimiter of the data file. [,] (comma): (default) Specify comma as delimiter. [ ] (space): Specify space as delimiter. [<TAB>] (tab): Specify tab as delimiter.
Support double quotation	Optional	Not available	Select when double quotations are used for quoting in the data file. [Checked]: Select when double quotations are used for quoting in the data file. Select when strings are enclosed with double quotations. [Not checked]: (default) Select when double quotation are not used for quoting in the data file.	Enabled when [Delimiter] is specified.
Schema definition	Required	-	The schema definition of the table specified in [Table name] is displayed.	Schema definition cannot be displayed in the following cases. When the user do not have read permission to the specified table When the specified table does not exist When a variable is specified in [Table name] When [Table name] is not entered When an error has occurred in [Table name]
Schema definition/Column name	Required	Not available	Column name in the table specified in [Table name] is displayed.
Schema definition/Type	Required	Not available	The type of [Column name] is displayed.	It is displayed in “<Native type> (<Internal data type>)” format. Native type: RDBMS specific data type. Internal data type: Data type used internally within DataSpider. Refer to “Internal Data Types” for more details.

Property actions

Item name	Description	Remarks
Launch table browser	Launch the table browser. For details on how to operate, refer to “Table Browser“.	Enabled when [Destination] is selected. The table specified in [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	The return value of the launched loader is stored.	Default value is null.
message_category	When an error occurs, the corresponding message code's category is stored.	Default value is null.
message_code	When an error occurs, the corresponding message code is stored.	Default value is null.
message_level	When an error occurs, the corresponding message code's severity is stored.	Default value is null.
error_type	When an error occurs, the error type is stored.	Default value is null. The error type will be in the following format. Example: “java.io.FileNotFoundException” The contents that will be stored may vary depending on DataSpider Servista versions.
error_message	When an error occurs, the error message is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions.
error_trace	When an error occurs, the error's trace information is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions and client applications.

Specification Limits

When the number of tables is not limited or a large number is specified In the global resource settings, depending on the number of tables in the database, it may take some time to open the properties window.

For more details on the specific limitations of each database adapter, refer to “Database Adapter Limitations”.

Major Exceptions

Exception name	Cause	Solution
ResourceNotFoundException Resource definition is not found. Name: []	[Destination] is not specified.	Specify [Destination].
ResourceNotFoundException Resource definition is not found. Name: [<global resource name>]	The resource definition selected in [Destination] is not found.	Check the global resource specified in [Destination].
InvalidPropertyConfigurationException Table name is not specified.	Table name is not specified.	Specify [Table name].
java.io.IOException	Failed to launch Loader command.	Check whether Loader is installed and is available in the paths or not.
java.sql.SQLException	A database access error or some other one has occurred.	Check the SQLException message. SQLException message is based on the specifications of the driver. The cause of the error might be output in SQLException message. For more details on messages, contact the database vendor.