Use Case Reference Guide

What is the Use Case Reference Guide?

A Use Case Reference guide is used as a reference for the functions in HULFT Integrate from the viewpoint of the processing to be achieved when developing a service.
Sample project files that contain the project files and input data for various scenarios are provided, so that you can upload and use the project files. You can also refer to a guide for creating scripts in order to create the same script.
Use the Use Case Reference guide to review the overview and flow of processing, and check the details of the help topic for each function.
For more information about how to use the guide, refer to "How to Search for a Scenario" and "How to Read a Scenario".

How to Use the Use Case Reference Guide

How to Search for a Scenario

The Use Case Reference guide contains more than 100 scenarios.
There are two methods for finding a scenario that includes the processing to be achieved.Both of these methods are described below.

Search all the scenario titles in the list of scenarios

Select "Scenario List" in the tree in the left pane. A list of scenarios is displayed in the right pane.
Read the "Scenario Name" column in the list to find the processing to be achieved.
When you select a scenario name, the page for that scenario is displayed.

Use the full-text search function

Use the full-text search function in the online help to search for keywords that are related to the processing to be achieved.
Enter the character string to be searched for in the search field and click the [Search] button. Page titles are displayed in the search results field in the order of pages with the highest hit rate.
The page that includes "[Use Case Reference Guide]" at the beginning of the page title is the scenario page. Search for the page that is nearest to the processing to be achieved.
When searching for multiple character strings, delimit the character strings with a normal-width space or comma.

How to Read a Scenario

In the Use Case Reference guide, there are two methods for reading a scenario.
After opening the scenario page, first read "Overview" at the top of the page.
To continue after reading the overview, choose from the following two paths.Both of these paths are described below.

Use the sample project

  1. Read "Description of Sample Project" for an overview of the processing details.
  2. Read "How to Use the Sample Project", and then upload and use the sample project.
You can use either of the following methods to obtain sample project files from the Use Case Reference guide.

Follow the procedure to create a script

  1. Follow the procedure described in "Procedure for Creating a Script" to create a script.

Scenario List

The scenarios that are provided with the Use Case Reference guide are shown below.

Scenario Name Sample Project File Name
Terminate the Extraction Process When the Record Has a Null Valuerl_reference_001.zip
Separate the Directories to Save Files Attached to Email According to File Extensionrl_reference_002.zip
Send an Email Using Script Variables for Items Such as the Address, Subject, and Bodyrl_reference_003.zip
Output a File with a Dynamically Switched File Namerl_reference_004.zip
Specify a JOIN Statement Using SQLrl_reference_005.zip
Switch Rows and Columns of Datarl_reference_006.zip
Launch an External Application from a Scriptrl_reference_007.zip
Control Execution of Scripts Simultaneously Executedrl_reference_008-010.zip
Create a Lock Filerl_reference_008-010.zip
Delete a Lock Filerl_reference_008-010.zip
Output Fixed-Length Data Such as Zengin Formatrl_reference_011.zip
Read Fixed-Length Data Consisting of One Type of Record Formatrl_reference_012.zip
Read Fixed-Length Data Consisting of Two Types of Record Formatsrl_reference_013.zip
Read Fixed-Length Data Consisting of Three Types of Record Formatsrl_reference_014.zip
Read Fixed-Length Data Consisting of Three Types of Record Formats in Hierarchical Structurerl_reference_015.zip
Read Fixed-Length Data Consisting of Four Types of Record Formats in Hierarchical Structurerl_reference_016.zip
Repeat the Operation While the Condition Is Satisfiedrl_reference_017.zip
Compare Previous Value and Current Valuerl_reference_018.zip
Check File Names Existing in Directory and Branch Processing by Extensionrl_reference_019.zip
Monitor Processes and Send an Exception Notification When an Error Occursrl_reference_020-021.zip
Change the Return Value When an Exception of Child Script Is Detectedrl_reference_020-021.zip
Check Records in Input Data against Master Data in a Database Table and Output the Matched Recordsrl_reference_022.zip
Check Records in Input Data against Master Data in a CSV File and Output the Matched Recordsrl_reference_023.zip
Extract Transaction Data That Does Not Exist in the Master Datarl_reference_024.zip
Change the Return Value According to the Operation Resultsrl_reference_025-026.zip
Check the Return Value of Child Scriptrl_reference_025-026.zip
Convert String-Type Date Data into Date/Time-Type Datarl_reference_027.zip
Convert Format of String-Type Date Datarl_reference_028.zip
Convert and Output the Date/Time-Type Formatrl_reference_029.zip
Change the Default Date/Time Formatrl_reference_030.zip
Replace Part of a Character String Using the Conversion Tablerl_reference_031.zip
Replace Characters Using Regular Expressionsrl_reference_032.zip
Delete Normal-width Spaces, Em-size Spaces, and Tab Characters Included in a Character Stringrl_reference_033.zip
Delete Specific Characters Located at the Beginning/End of the Input Character Stringrl_reference_034.zip
Merge and Group Multiple Filesrl_reference_035.zip
Read a File Delimited by a Specific Delimiterrl_reference_036.zip
Determine Whether Input Data Is a Numeric Valuerl_reference_037.zip
Get the Last Date of a Monthrl_reference_038.zip
Check Multiple Items for Null Valuesrl_reference_039.zip
Use a Combination of Frequently-Used Logics as a Functionrl_reference_040.zip
Output Database Search Results as HTML Data and View the Results in a Web Browserrl_reference_041-043.zip
Output Database Search Results as HTML Data That Lists the Results in Color and View the Results in a Web Browserrl_reference_041-043.zip
Search a Database by Entering a Value in a Web Browser and View the Results in the Web Browserrl_reference_041-043.zip
Publish Processing as a SOAP Web Service That Searches a Database and Returns a Single Resultrl_reference_044-045.zip
Execute a SOAP Web Service for Database Searches to Get a Single Search Resultrl_reference_044-045.zip
Execute a Script on a Command Linerl_reference_046.zip
Check Debug Information by Setting a Breakpointrl_reference_047.zip
Merge Multiple Sets of Datarl_reference_048.zip
Publish Processing as a SOAP Web Service That Updates a Database and Returns an Update Resultrl_reference_049.zip
Execute Multiple Operations in Parallelrl_reference_050.zip
Use XSLT to Convert an XML Filerl_reference_051.zip
Extract Data by Specifying Multiple Conditionsrl_reference_052.zip
Change Output Values Based on Multiple Conditionsrl_reference_053.zip
Calculate the Age of a Person as of the Specified Daterl_reference_054.zip
Publish Processing as a REST Web Service That Searches a Database and Returns Multiple Resultsrl_reference_055.zip
Check the Character Countrl_reference_056.zip
Use Unique Character Strings for File Namesrl_reference_057.zip
Output the Name of an Executed Script to the Logrl_reference_058.zip
Use XPath to Obtain Values from XML Filesrl_reference_059.zip
Convert the Numeric Value Formatrl_reference_060.zip
Dynamically Generate SQL Based on Input Datarl_reference_061.zip
Extract Specific Files from among Multiple Files and Write them to a Database with a Loaderrl_reference_062.zip
Read Log Files and Send an Error Email for an Error Level Logrl_reference_063.zip
Change the Encoding of Output Filesrl_reference_064.zip
Create Single-Form Excel Files from CSV Datarl_reference_065.zip
Write a Binary File as Text Data to a Databaserl_reference_066.zip
Read CSV Files on an FTP Serverrl_reference_067.zip
Receive a Message from JMS Queue and Write It to a Filerl_reference_068.zip
Execute a SOAP Web Service for Database Updates to Branch Processing According to Update Resultsrl_reference_069.zip
Execute a Web Service for Database Searches in REST to Get Search Results in XMLrl_reference_070.zip