# Utility

## SQL Executor

This utility is useful when you cannot access the target database directly through RDBMS GUI tools. This tool does not provide many functions. Only queries can be executed. 

You can execute multiple queries and can commit the C/U/D operations.

<figure><img src="https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image133.png" alt=""><figcaption></figcaption></figure>

Queries are delimited by semi colon (;).

Desc(ribe) query is available. The query below displays the layout and column information of the table.

| desc(ribe) table\_name; |
| ----------------------- |

&#x20;

The results are displayed in separate tabs.

If any C/U/D query is included and commit is checked, then the queries are committed.

The first database listed is ISM repository database.

## File parser

File parser is used to parse a file and download a file from (s)FTP server and parse the file data with data structure.

<figure><img src="https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image134.png" alt=""><figcaption></figcaption></figure>

1\.      Connect to the (s)FTP server.

2\.      Double click the target file.

3\.      Download the file. Downloaded file is displayed in the text area.&#x20;

4\.      Choose data structure.

5\.      Click parse button.

The parsed contents are displayed at the bottom.

&#x20;

<figure><img src="https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image135.png" alt=""><figcaption></figcaption></figure>

No error message means this file is successfully parsed.

&#x20;

## JavaScript <a href="#toc130312314" id="toc130312314"></a>

The JavaScript menu allows users to write and execute custom JavaScript functions that can be used in pipeline designs or tasks. The detailed information how JavaScript menu works is [here](https://support.xnarum.com/download/manual.php).

<figure><img src="https://support.xnarum.com/download/manuals/ISM-Manual-2023.fld/image136.png" alt="" width="563"><figcaption></figcaption></figure>

Write functions and click execute button, then the last function(until JDK 1.8) is executed.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://scott-kang-kr.gitbook.io/manual/ism-admin-ui/utility.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.