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

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.