Steven,

The Free version is just a plain FTP Server/Client. All accessible tasks in the projects are only related to that usage. Encrypting/Decrypting and Zip/Unzip, etc ... all of the functionality outside of basic FTP isn't available without purchase.

Rob, How are you wanting to integrate with MKS? GAMFT can connect and transfer files between servers easily. It can insert records into a DB2 table as well as the IFS. Are you wanting GAMFT to do the transfers of updated files/tables? Are you wanting to just push data? What are you looking at doing?

GAMFT has an API interface so it can be called (trigger file movements) from external sources (programs, CLP, RPG, C#, .NET, etc). You define the file movement through a GAMFT Project (Copy, Encrypt, Decrypt, SFTP/FTP, etc) then trigger the movement from a Schedule, Monitor or external source, etc. ...

The In/Out variables do not work that way through the JDBC connection.

You will need to write the "out" values into a temp table or CSV, then read them (select * from tempTable) or ReadCSV task from within your Project to return those values to your Project.

GoAnywhere MFT does this for you automatically by designating any folder (that you have permissions to) as an encrypted folder. Then, any file put into or pulled from the folder through GAMFT is automatically encrypted when placed or decrypted when pulled.

Falak,

Please review the "READCSV" task. It reads the csv file into a Rowset. Then, you use that Rowset to insert data into your Database. You do not have to do the "load data" command.

Doing a search on the GoAnywhere Forum for "CreateCSV" you'll find some articles that will help you with this... https://forum.goanywhere.com/can-i-change-the-headings-in-a-csv-file-635 https://forum.goanywhere.com/writing-to-csv-or-flat-file-without-rowset-852 Please review those and you should see...

For your output file under the Zip Task ... just put this as the parameter:

${Concat( 'zipfile ', currentDate( 'MM-dd-yyyy' ), '.zip' ) }

Please send me your full Project XML as well as the latest JobLog in DEBUG mode.

This way I can review it...

The parameter for the FileInfo command has to be a STRING. Thus,

${ FileInfo(String( item ) ):exists }

Should get you what you're looking for!