Search found 75 matches

Search found 75 matches Page 4 of 8
by Support_Duane
Mon Jul 26, 2010 9:29 am
Forum: Community Forum
Topic: FTP Parallel transfers
Replies: 1
Views: 2706

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...
by Support_Duane
Tue Jul 20, 2010 3:20 pm
Forum: Community Forum
Topic: String to RowSet to use in a Loop
Replies: 5
Views: 5278

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...
by Support_Duane
Mon Jun 21, 2010 10:14 am
Forum: Community Forum
Topic: Retrieve contents of a Data Area (dtaara)
Replies: 1
Views: 2479

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...
by Support_Duane
Mon Jun 21, 2010 9:55 am
Forum: Example Projects
Topic: Retrieve data from a data area and use it in a project
Replies: 0
Views: 5530

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. /*****************************************************...
by Support_Duane
Thu May 20, 2010 10:58 am
Forum: Community Forum
Topic: Transfer File via HTTP POST?
Replies: 15
Views: 19253

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...
by Support_Duane
Mon Apr 26, 2010 10:13 am
Forum: Example Projects
Topic: How to transfer a SPOOLED FILE from one iSeries to another
Replies: 0
Views: 5308

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" ...
by Support_Duane
Wed Mar 24, 2010 10:17 am
Forum: Community Forum
Topic: Exclude Folders in a File List?
Replies: 3
Views: 5570

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...
by Support_Duane
Wed Mar 03, 2010 4:40 pm
Forum: Community Forum
Topic: Loading a pipe delimited file to a Database.
Replies: 1
Views: 2735

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...
by Support_Duane
Mon Sep 28, 2009 4:53 pm
Forum: Community Forum
Topic: Write Exec Task
Replies: 3
Views: 4151

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 ...
by Support_Duane
Fri Sep 25, 2009 3:23 pm
Forum: Community Forum
Topic: Inporting an Excel Spreadsheet
Replies: 1
Views: 3299

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.
Search found 75 matches Page 4 of 8