Utility
Last updated
Last updated
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.
Queries are delimited by semi colon (;).
Desc(ribe) query is available. The query below displays the layout and column information of the table.
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 is used to parse a file and download a file from (s)FTP server and parse the file data with data structure.
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.
4. Choose data structure.
5. Click parse button.
The parsed contents are displayed at the bottom.
No error message means this file is successfully parsed.
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.
Write functions and click execute button, then the last function(until JDK 1.8) is executed.
desc(ribe) table_name;
