Hello,
I want to FTP a few files to different directories.

eg I want to FTP files that begin with 24A*.txt and 11A*.txt to folder one and files that begin with 10A*.txt and 7A*.txt to folder two

I have used the FTP download template to create the first file but can I alter the bit where it populates the file_list with another FTPDir command so I gradually build up a file list for each folder i want to copy to ?
ie I have a FTPDir command for each file I want to ftp across and store the result into the file_list - would this append it intop the list or just overwrite it ?

Or is there an easier way to do this ?

It will overwrite the list. Every statement that returns some result into a return variable always overwrites the existing value.
I know you are familiar with Oracle PL/SQL. Return variables in JAL work exactly as OUT parameters in Oracle procedures and functions.

: Hello,
: I want to FTP a few files to different directories.

: eg I want to FTP files that begin with 24A*.txt and 11A*.txt to folder one
: and files that begin with 10A*.txt and 7A*.txt to folder two

: I have used the FTP download template to create the first file but can I
: alter the bit where it populates the file_list with another FTPDir command
: so I gradually build up a file list for each folder i want to copy to ?
: ie I have a FTPDir command for each file I want to ftp across and store the
: result into the file_list - would this append it intop the list or just
: overwrite it ?

: Or is there an easier way to do this ?

Ok thanks

OK, so what I want to do is for each file that exists I want to FTP them but I don't want to duplicate the code each time for ftping but I can't work out how to create a procedure as the concept of precedures (like plsql procedures) don't seem to exist in JAL.
Is the only way around it to create a separate job that actually FTPs the files and set global variables that names the file and directory each time from the calling job ?

Yes, this concept is supported. You can create user defined statements with or without parameters using Tools/Script Library menu.
You can then call this statement from different jobs passing parameters if required just as you call procedures and functions in PL/SQL.

: OK, so what I want to do is for each file that exists I want to FTP them but
: I don't want to duplicate the code each time for ftping but I can't work
: out how to create a procedure as the concept of precedures (like plsql
: procedures) don't seem to exist in JAL.
: Is the only way around it to create a separate job that actually FTPs the
: files and set global variables that names the file and directory each time
: from the calling job ?

OK thanks