• DataSpider Servista Help
• DataSpider Servista Concept
  • DataSpider Servista
  • Composition of DataSpider Servista
  • DataSpider Filesystem directory structure
• Service Guide
  • The Basic Knowledge of Service
    • Basic elements of service
    • User Management
    • Tutorial
  • Service Development
    • Preparation
    • Team development
    • Mass Data Correspondence
    • Development support functions
    • Other auxiliary components
    • Utilizing Global Schema
    • Loop log setting
    • Access Log
    • Selecting Service Execution Tool
    • Generating a Specification
    • Detailed Topics
      • Keyboard Shortcuts
      • Script variables
      • Log Level
      • Exit status
      • Types
      • Parallel Stream Processing
      • Smart Compiler
      • Multi-thread Processing
      • Team Development
  • Service Operation
    • Before operating the services
    • Server migration
    • Monitoring
    • In the event of failure
    • Maintenance
    • Logging Guide
    • Detailed Topics
      • Property Reference
      • HTTPS setting
      • Import of certificate
      • Message Code
        • Message Code List
        • FILE
        • IO
        • NETWORK
        • DB
        • TRANSACTION
        • DATA
        • SECURITY
        • MEMORY
        • EXTERNAL
        • SCRIPT
        • PSP
        • MAPPER
        • MERGE
        • USER
        • OTHER
      • Others
  • Troubleshooting
• Operation Tools
  • Trigger
    • Trigger
    • Schedule trigger
    • HULFT Script trigger
  • ScriptRunner
  • ScriptRunnerProxy
  • CLI Console
  • WebConsole
• Development Tools
  • DataSpider Studio
  • New project/Open project
  • My Projects
  • My Triggers
  • My Logs
  • My Services
  • Designer
  • Explorer
  • Control Panel
    • DataSpider Log Settings
    • Application Log Output Settings
    • DataSpiderServer Settings
    • Task Manager
    • Mount Settings
    • Version Information
    • Environment Variables Management
    • User Accounts
    • Holiday Settings
    • Global Resource Settings
    • Global Schema Settings
    • Repository DB Management
• Architecture
  • DataSpiderServer Architecture
  • XML Framework
  • DataSpider filesystem
  • Data type
  • Transaction
  • Global Resources
  • Global Schema
• Adapter
  • Basic
    • Processing
      • Variable Substitution
      • Launch External Application
      • Call Script
      • Wait
      • Garbage Collection
      • Exception Notice
      • Output Log
      • Validation(XML Schema)
      • Validation(DTD)
    • Flow
      • Loop
      • Conditional Loop
      • Loop by Number of Data
      • Conditional Branch
      • Monitor Exception
      • Start Thread
      • Transaction
      • end
      • break
      • continue
    • Assertion
      • Assert Null/Not Null
      • Assert (Compare file)
      • Assert (Compare data)
      • Assertion Exception
      • Message Code
    • Others
      • Group
      • Memo
  • Conversion
    • Basic
      • Mapping
      • Join
      • Aggregate
      • Sort
      • Merge
      • Message Code
    • Character
      • Convert CP932 to SJIS
      • Convert SJIS to CP932
      • Delete Invalid XML Characters
      • Message Code
    • Table
      • Switch Row/Column
      • Message Code
    • XSLT
      • Convert XSLT Structure
      • Message Code
  • Database
    • Access
      • Operation Environment
      • Environment Settings
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Access 2013 Adapter Limitations
        • Access 2010 Adapter Limitations
    • DB2
      • Operation Environment
      • Library Installation
      • Global Resource Properties (DB2)
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • DB2 V10.5 Adapter Limitations
        • DB2 V10.1 Adapter Limitations
        • DB2 V9.7 Adapter Limitations
        • DB2 V9.5 Adapter Limitations
        • DB2 V9.1 Adapter Limitations
    • MySQL
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • MySQL 5.6 Adapter Limitations
        • MySQL 5.5 Adapter Limitations
        • MySQL 5.1 Adapter Limitations
        • MySQL 5.0 Adapter Limitations
    • Oracle
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Global Resource Properties (OCI)
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Oracle 12c Adapter Limitations
        • Oracle 11gR2 Adapter Limitations
        • Oracle 11g Adapter Limitations
        • Oracle 10gR2 Adapter Limitations
        • Oracle 10g Adapter Limitations
        • Oracle 9.2.0 Adapter Limitations
        • Oracle 9.0.1 Adapter Limitations
        • Oracle OCI Adapter Limitations
    • PostgreSQL
      • Operation Environment
      • Environment Settings
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • PostgreSQL 9.4 Adapter Limitations
        • PostgreSQL 9.3 Adapter Limitations
        • PostgreSQL 9.2 Adapter Limitations
        • PostgreSQL 9.1 Adapter Limitations
        • PostgreSQL 9.0 Adapter Limitations
        • PostgreSQL 8.4 Adapter Limitations
        • PostgreSQL 8.3 Adapter Limitations
        • PostgreSQL 8.2 Adapter Limitations
    • SQL Server
      • Operation Environment
      • Environment Settings
      • Library Installation
      • Global Resource Properties (JDBC)
      • Global Resource Properties (ODBC)
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • SQL Server 2014 JDBC Adapter Limitations
        • SQL Server 2012 JDBC Adapter Limitations
        • SQL Server 2008 R2 JDBC Adapter Limitations
        • SQL Server 2008 JDBC Adapter Limitations
        • SQL Server 2008 ODBC Adapter Limitations
        • SQL Server 2005 JDBC Adapter Limitations
        • SQL Server 2005 ODBC Adapter Limitations
  • File
    • CSV
      • Read CSV File
      • Write CSV File
      • Message Code
    • Excel
      • Word definition
      • Operation Environment
      • Read from Sheet
      • Read from Named Range
      • Read Specified Cells
      • Get List of Sheet Names
      • Write
      • Write Specified Cell
      • Password Protect Workbooks or Sheets
      • Show/Hide Sheets/Rows/Columns
      • Excel Read Wizard
      • Excel Write Wizard
      • Excel Adapter Library
      • Message Code
    • File Operation
      • Create File
      • Create Directory
      • Copy
      • Delete File/Directory
      • Move
      • Get List of File Names
      • Check File/Directory Exists
      • Compress ZIP
      • Extract ZIP
      • Message Code
  • Application
    • DataSpider BPM
      • Operation Environment
      • Global Resource Properties
      • Start Process
      • Search Tasks
      • Reallocate Tasks
      • Find Users
      • Add/Update Users
      • Delete Users
      • Find Organizations
      • Add/Update Organizations
      • Delete Organizations
      • Add/Update/Delete Members
      • Leader/Member Setting
      • Message Code
    • Tableau
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Output TDE File
      • Publish Data Source
      • Set Data Source Permissions
      • Delete Data Source
      • Message Code
  • HULFT
    • Request Issuance
      • Operation Environment
      • Global Resource Properties
      • Send File
      • Send Request
      • Message Code
    • History
      • Supported Platform
      • Read History Information
      • Message Code
• Mapper
  • Document Mapper
    • Basic Functions
      • Creating a Mapper
      • Mapper Editor
      • Temporary Schema
      • Loop in Mapper
      • Usage of Variables
      • Edit Schema
      • Mapper Logic
    • Other Function
      • Null Option
      • Custom Logic
      • Layer Function
      • Real-time Preview Function
      • I/O Item Search
    • Mapper Logic Guide
      • Mapper Logic List
      • Loop
        • Iterate specified node
        • Sort by Key
        • Sort by Two Keys
        • Grouping
        • If Loop
      • Branch
        • If
        • Switch
      • Condition
        • And
        • Or
        • Not
        • Boolean Constant
        • To Boolean
        • Check Null
        • Equal
        • Not Equal
        • Less Than
        • Not More Than
        • More Than
        • Not Less Than
        • Identical
        • Different
        • Start with
        • End with
        • Contain
        • Match to Regular Expression
        • Equal Date/Time
        • Before
        • After
        • Date/Time Exists
      • Number
        • Numeric Constant
        • To Number
        • Input Node Number
        • Output Node Number
        • Add
        • Subtract
        • Multiply
        • Divide
        • Modulo
        • Ceiling
        • Floor
        • Rounding
        • Absolute Value
        • Square Root Value
        • The Larger
        • The Smaller
        • Sign
        • String Length
        • Number of Bytes
        • Sum
        • Average
        • Number of Node
        • Maximum Node
        • Minimum Node
        • Get Year
        • Get Month
        • Get Day
        • Get Hour
        • Get Minute
        • Get Second
        • Get Day of the Week
        • Get Number of Days
        • Calculate Period by Year
        • Calculate Period by Month
        • Calculate Period by Day
        • Calculate Period by Hour
        • Calculate Period by Minute
        • Calculate Period by Second
        • Replace Null/Empty String
        • Convert Chinese Numeral to Numeric
        • Calculate Age
      • String
        • Single-line String Constant
        • Multi-line String Constant
        • Unique string
        • Execution ID
        • Execution Environment ID
        • Execution User
        • Execution Project Name
        • Execution Script Name
        • Execution Type
        • Execution Trigger Name
        • Execution Trigger Type
        • System Property
        • Get Value by XPath
        • To String
        • Concatenate
        • Left String
        • Right String
        • Middle String
        • String After Specified Position
        • After Specified Character
        • Before Specified Character
        • Calculate Middle String
        • Left String (bytes)
        • Retrieve data by executing SQL
        • Replace Each String
        • Replace by CSV Table
        • Replace by DB Table
        • Replace by Regular Expression
        • Lowercase
        • Uppercase
        • Replace Each Character
        • Replace Null
        • Replace Null/Empty String
        • Convert Numeral System
        • Trim Both Sides
        • Trim Left
        • Trim Right
        • Format Number
        • Date/Time Formatting
        • Encrypt
        • Decrypt
        • Hiragana to Katakana
        • Katakana to Hiragana
        • Hiragana to Roman Alphabet
        • Em-size to Normal-width
        • Normal-width to Em-size
        • Convert to Chinese Numeral
        • Convert to Japanese Calendar
      • Date
        • Current Date/Time
        • Date/Time Constant
        • Parse Date/Time
        • Set Year
        • Set Month
        • Set Day
        • Set Hour
        • Set Minute
        • Set Second
        • Calculate Year
        • Calculate Month
        • Calculate Day
        • Calculate Hour
        • Calculate Minute
        • Calculate Second
        • Parse Japanese Calendar
      • Excel
        • Generate Excel format
      • Other
        • Null Value
        • Replace Empty String
        • Copy Input Element
  • Variable Mapper
    • Basic Functions
      • Creating a Mapper
      • Mapper Editor
      • Temporary Schema
      • Loop in Mapper
      • Usage of Variables
      • Edit Schema
      • Mapper Logic
    • Other Function
      • Null Option
      • Custom Logic
      • Layer Function
      • Real-time Preview Function
      • I/O Item Search
    • Mapper Logic Guide
      • Mapper Logic List
      • Branch
        • If
        • Switch
      • Condition
        • And
        • Or
        • Not
        • Boolean Constant
        • To Boolean
        • Check Null
        • Equal
        • Not Equal
        • Less Than
        • Not More Than
        • More Than
        • Not Less Than
        • Identical
        • Different
        • Start with
        • End with
        • Contain
        • Match to Regular Expression
        • Equal Date/Time
        • Before
        • After
        • Date/Time Exists
      • Number
        • Numeric Constant
        • To Number
        • Add
        • Subtract
        • Multiply
        • Divide
        • Modulo
        • Ceiling
        • Floor
        • Rounding
        • Absolute Value
        • Square Root Value
        • The Larger
        • The Smaller
        • Sign
        • String Length
        • Number of Bytes
        • Get Year
        • Get Month
        • Get Day
        • Get Hour
        • Get Minute
        • Get Second
        • Get Day of the Week
        • Get Number of Days
        • Calculate Period by Year
        • Calculate Period by Month
        • Calculate Period by Day
        • Calculate Period by Hour
        • Calculate Period by Minute
        • Calculate Period by Second
        • Replace Null/Empty String
        • Convert Chinese Numeral to Numeric
        • Calculate Age
      • String
        • Single-line String Constant
        • Multi-line String Constant
        • Unique string
        • Execution ID
        • Execution Environment ID
        • Execution User
        • Execution Project Name
        • Execution Script Name
        • Execution Type
        • Execution Trigger Name
        • Execution Trigger Type
        • System Property
        • Get Cell Value
        • Get Value by XPath
        • To String
        • Concatenate
        • Left String
        • Right String
        • Middle String
        • String After Specified Position
        • After Specified Character
        • Before Specified Character
        • Calculate Middle String
        • Left String (bytes)
        • Retrieve data by executing SQL
        • Replace Each String
        • Replace by CSV Table
        • Replace by DB Table
        • Replace by Regular Expression
        • Lowercase
        • Uppercase
        • Replace Each Character
        • Replace Null
        • Replace Null/Empty String
        • Convert Numeral System
        • Trim Both Sides
        • Trim Left
        • Trim Right
        • Format Number
        • Date/Time Formatting
        • Encrypt
        • Decrypt
        • Hiragana to Katakana
        • Katakana to Hiragana
        • Hiragana to Roman Alphabet
        • Em-size to Normal-width
        • Normal-width to Em-size
        • Convert to Chinese Numeral
        • Convert to Japanese Calendar
      • Date
        • Current Date/Time
        • Date/Time Constant
        • Parse Date/Time
        • Set Year
        • Set Month
        • Set Day
        • Set Hour
        • Set Minute
        • Set Second
        • Calculate Year
        • Calculate Month
        • Calculate Day
        • Calculate Hour
        • Calculate Minute
        • Calculate Second
        • Parse Japanese Calendar
      • Excel
        • Generate Excel format
      • Other
        • Null Value
        • Replace Empty String
  • Merge Mapper
    • Basic Functions
      • Creating a Mapper
      • Mapper Editor
      • Merge Settings
      • Temporary Schema
      • Edit Schema
      • Mapper Logic
    • Other Function
      • Null Option
      • Layer Function
      • Real-time Preview Function
      • I/O Item Search
    • Mapper Logic Guide
      • Mapper Logic List
      • Merge
        • Or-Append Merge
        • Or-Integrate Merge
        • And-Append Merge
        • And-Integrate Merge
        • Left-Right-Join Merge
      • Branch
        • If
        • Switch
      • Number
        • Numeric Constant
        • To Number
        • Add
        • Subtract
        • Multiply
        • Divide
        • Modulo
        • Ceiling
        • Floor
        • Rounding
        • Absolute Value
        • Square Root Value
        • The Larger
        • The Smaller
        • Sign
        • String Length
        • Number of Bytes
        • Get Year
        • Get Month
        • Get Day
        • Get Hour
        • Get Minute
        • Get Second
        • Get Day of the Week
        • Get Number of Days
        • Calculate Period by Year
        • Calculate Period by Month
        • Calculate Period by Day
        • Calculate Period by Hour
        • Calculate Period by Minute
        • Calculate Period by Second
        • Replace Null/Empty String
        • Convert Chinese Numeral to Numeric
        • Calculate Age
      • String
        • Single-line String Constant
        • Multi-line String Constant
        • Unique string
        • Execution ID
        • Execution Environment ID
        • Execution User
        • Execution Project Name
        • Execution Script Name
        • Execution Type
        • Execution Trigger Name
        • Execution Trigger Type
        • System Property
        • To String
        • Concatenate
        • Left String
        • Right String
        • Middle String
        • String After Specified Position
        • After Specified Character
        • Before Specified Character
        • Calculate Middle String
        • Left String (bytes)
        • Retrieve data by executing SQL
        • Replace Each String
        • Replace by CSV Table
        • Replace by DB Table
        • Replace by Regular Expression
        • Lowercase
        • Uppercase
        • Replace Each Character
        • Replace Null
        • Replace Null/Empty String
        • Convert Numeral System
        • Trim Both Sides
        • Trim Left
        • Trim Right
        • Format Number
        • Date/Time Formatting
        • Encrypt
        • Decrypt
        • Hiragana to Katakana
        • Katakana to Hiragana
        • Hiragana to Roman Alphabet
        • Em-size to Normal-width
        • Normal-width to Em-size
        • Convert to Chinese Numeral
        • Convert to Japanese Calendar
      • Date
        • Current Date/Time
        • Date/Time Constant
        • Parse Date/Time
        • Set Year
        • Set Month
        • Set Day
        • Set Hour
        • Set Minute
        • Set Second
        • Calculate Year
        • Calculate Month
        • Calculate Day
        • Calculate Hour
        • Calculate Minute
        • Calculate Second
        • Parse Japanese Calendar
      • Other
        • Replace Empty String
        • Output by XPath Expression