It is possible to specify that a project is threadsafe, which will allow you to have multiple copies of a project running at the same time. This would require that the project be written in such a way that it actually IS threadsafe and that no files being used in one iteration of the project would b...

GoAnywhere does not currently (as of July 2010) allow string operations on variables, so you cannot pass in a string and use pieces of it in your loop. What you can do, however, is to place the values into separate records in a file, (any of the file types that GoAnywhere can read - Database, CSV, F...

Yes, it is possible to retrieve the contents of a data area, and do with them whatever you choose. In order to accomplish this, you must create a program (either CL, RPG or other language of your choice) that will retrieve the data area and place the contents in a variable. This variable can be refe...

There are two sets of code here, one for a CL program that will retrieve a value from a data area and place that value into a variable, the second is the XML for a project that will call the program and retrieve the value stored in the variable. /*****************************************************...

Select the “file” option in the Response Body Destination field, provide a path and file name in the Response Body File field, and select the appropriate option in the When Response Body File Exists field - the default for which is "rename". If you leave the default, or select "rename", be sure to m...

Here is a project that will transfer a spooled file from one iSeries to another. <project name="transfer spooled file" mainModule="Main" version="1.0"> <description>Transfer a spooled file from one iSeries to another</description> <module name="Main" logLevel="debug"> <exec400 label="source system" ...

It is not exactly simple, but not too difficult. What you need to do is to convert the filelist into a database file that you can read with SQL, allowing you to select only the records that do not have the folder name you specify. The following xml code will provide a general idea of what you need t...

On a readCSV task, you can set the Skip Invalid Records value (on the advanced tab) to true, and if you have a record that doesn't have the correct number of fields, a record will be written to the error log that will specify which record was in error, how many fields it has and how many it was supp...

GoAnywhere does not currently create Excel 2007 spreadsheets, only Excel 2003. We are working on that ability, but it does not currently exist. As far as the Excel template goes, you create an Excel file that has the headings and columns the way you want them and then you reference that file in the ...

In either the Data element or the individual column elements in the read Excel task, select the system.empty.string variable for the Null Indicator field. Then, when writing from the dataset, specify 0 for the Null Substitute value.