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 29-Dec-2020 05:25 Halmágyi Árpád
png
 compress_task.png 54.6 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 copy_task.png 135.1 kB 5 29-Dec-2020 05:25 Halmágyi Árpád
png
 decompress_task.png 53.4 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 delete_task.png 118.0 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 email_task.png 72.3 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 exclude_task.png 44.2 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 execute_task.png 96.6 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 fileparser_task.png 64.9 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 find_task.png 129.1 kB 5 29-Dec-2020 05:25 Halmágyi Árpád
png
 findcache_task.png 51.0 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
 http_task.png 89.5 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
 java_task.png 51.2 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 jump_task.png 77.4 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 jump_task_groupby.png 28.6 kB 1 07-Jan-2022 14:47 Ada Csaba
png
 kill_task.png 44.5 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 link_task.png 49.4 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 makedirectory_task.png 109.9 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 move_task.png 129.3 kB 4 29-Dec-2020 05:25 Halmágyi Árpád
png
 pgp_task.png 61.2 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
 popimap_task.png 115.0 kB 2 29-Dec-2020 05:25 Halmágyi Árpád
png
 preview_task.png 43.9 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 rename_task.png 59.7 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 sort_task.png 44.7 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
jpg
 sql_task.jpg 141.0 kB 1 03-Jun-2021 17:24 Ada Csaba
png
 sql_task.png 85.3 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 tunnel_task.png 54.2 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 unzip_task.png 59.1 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 userlist_task.png 68.3 kB 1 29-Dec-2020 05:25 Halmágyi Árpád
png
 userslist_task.png 31.9 kB 1 29-Dec-2020 05:25 Ben Spink
png
 uservariable_task.png 68.3 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 wait_task.png 51.8 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 writefile_task.png 90.3 kB 3 29-Dec-2020 05:25 Halmágyi Árpád
png
 zip_task.png 58.4 kB 4 29-Dec-2020 05:25 Halmágyi Árpád

This page (revision-77) was last changed on 17-Nov-2023 16:13 by Ada Csaba

This page was created on 29-Dec-2020 05:25 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
77 17-Nov-2023 16:13 17.312 kB Ada Csaba to previous
76 13-Jul-2023 00:05 17.123 kB Sandor to previous | to last
75 19-May-2023 11:11 17.031 kB Sanci to previous | to last
74 09-Apr-2023 23:59 16.935 kB Sandor to previous | to last
73 09-Apr-2023 23:55 16.931 kB Sandor to previous | to last
72 22-Feb-2023 06:34 16.932 kB krivacsz to previous | to last
71 22-Feb-2023 06:33 16.925 kB krivacsz to previous | to last
70 02-May-2022 09:25 16.776 kB Sandor to previous | to last
69 28-Apr-2022 09:57 16.742 kB Halmágyi Árpád to previous | to last
68 17-Jan-2022 10:00 16.63 kB Ada Csaba to previous | to last
67 17-Jan-2022 09:59 16.61 kB Ada Csaba to previous | to last
66 05-Nov-2021 03:44 16.37 kB Ben Spink to previous | to last
65 08-Oct-2021 12:22 15.959 kB Ben Spink to previous | to last
64 17-Jul-2021 02:22 15.729 kB Ben Spink to previous | to last
63 03-Jun-2021 17:32 15.552 kB Ada Csaba to previous | to last
62 03-Jun-2021 17:25 15.369 kB Ada Csaba to previous | to last
61 03-Jun-2021 17:23 15.306 kB Ada Csaba to previous | to last
« This page (revision-77) was last changed on 17-Nov-2023 16:13 by Ada Csaba
G’day (anonymous guest)
CrushFTP10 | What's New

Referenced by
CrushTaskExample16
Enterprise License Enhancements
Jobs
LeftMenu

JSPWiki