View Attach (34) Info

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
png
 »as2_task.png 91.3 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 »compress_task.png 54.6 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »copy_task.png 135.1 kB 5 05-Dec-2023 05:32 Halmágyi Árpád
png
 »decompress_task.png 53.4 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »delete_task.png 118.0 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »email_task.png 72.3 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »exclude_task.png 44.2 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »execute_task.png 96.6 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »fileparser_task.png 64.9 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »find_task.png 129.1 kB 5 05-Dec-2023 05:32 Halmágyi Árpád
png
 »findcache_task.png 51.0 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 »http_task.png 89.5 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 »java_task.png 51.2 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »jump_task.png 77.4 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »jump_task_groupby.png 28.6 kB 1 05-Dec-2023 05:32 Ada Csaba
png
 »kill_task.png 44.5 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »link_task.png 49.4 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »makedirectory_task.png 109.9 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »move_task.png 129.3 kB 4 05-Dec-2023 05:32 Halmágyi Árpád
png
 »pgp_task.png 61.2 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 »popimap_task.png 115.0 kB 2 05-Dec-2023 05:32 Halmágyi Árpád
png
 »preview_task.png 43.9 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »rename_task.png 59.7 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »sort_task.png 44.7 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
jpg
 »sql_task.jpg 141.0 kB 1 05-Dec-2023 05:32 Ada Csaba
png
 »sql_task.png 85.3 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »tunnel_task.png 54.2 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »unzip_task.png 59.1 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »userlist_task.png 68.3 kB 1 05-Dec-2023 05:32 Halmágyi Árpád
png
 »userslist_task.png 31.9 kB 1 05-Dec-2023 05:32 Ben Spink
png
 »uservariable_task.png 68.3 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »wait_task.png 51.8 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »writefile_task.png 90.3 kB 3 05-Dec-2023 05:32 Halmágyi Árpád
png
 »zip_task.png 58.4 kB 4 05-Dec-2023 05:32 Halmágyi Árpád

This page (revision-81) was last changed on 20-Nov-2024 04:21 by Ben Spink

This page was created on 05-Dec-2023 05:32 by Ben Spink

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

-
Difference between version and

At line 89 changed one line
!input:
!input/parameters:
At line 185 changed one line
This task can be used to run SQL statements or even full scripts against an SQL database server.
This task can be used to run SQL statements or even full scripts against an SQL database server. The DB driver class name and the URL syntax is usually specific to a certain DB family, need to find out from the documentation of the JDBC driver.
At line 189 changed 7 lines
!input/parameters:
*DB Driver: the JDBC driver class name.\\
*DB Driver: the list of arguments passed to Command, the list items separated by Separator character ";" (semicolon) by default. In case running scripts, here comes\\
the script file name followed by any arguments to be passed to
*Working directory: the parent path of the binary or script file, we do a change directory into this folder before invoking Command. In case running scripts, here comes\\
the full parent path of the script file
*Environment variables: leave it empty, rarely needed
!parameters:
*DB Driver: the JDBC driver class name.\\
*DB Driver File: the JDBC driver jar file path on server.\\
*DB URL: the SQL server URL we connect to.\\
*DB User, DB Password: the login credentials of the DB query account.\\
*Query: input field for the SQL statement or script.\\
\\
!input:
Generic list items passing from the previous task. Input fields also accept server variables, where it makes sense.
At line 197 changed one line
the task will feed it's output to the next task item, if any, can be referenced by the {execute_log} server variable
The SQL task will feed it's output to the next task item, if any. The DB table column names can be used as server variables, enclosed within curly brackets, to reference table cell values of a row. The next task will usually loop through the rows list.
Version Date Modified Size Author Changes ... Change note
81 20-Nov-2024 04:21 17.887 kB Ben Spink to previous
« This page (revision-81) was last changed on 20-Nov-2024 04:21 by Ben Spink
G’day (anonymous guest)
CrushFTP11 | What's New

Referenced by
Enterprise License Enhancements
Jobs
LeftMenu

JSPWiki