Skip to content

Search found 7 matches

Re: Pipe Delimited File Putting Quotes at Beggining & End of

Was there ever a solution posted for this problem? I am encountering the same issue using the WRITECSV task to create a pipe-delimited text file. Some of the output records are completely enclosed in quotes. As an example, my output file will look like this: Field1|Field 2|Field 3|Field 4 "Fiel...

Re: Simple INSERT not working.

I was able to perform this task using the For-Each loop that Rick described in another topic. As for the original way I was trying to do this, I was thinking that by using the DATA feature on the READCSV task, this would only put those data elements into the rowset. I am thinking now that all fields...

Simple INSERT not working.

I'm trying to do a READCSV to a rowset and then insert the rowset into an i-Series file. I've simplified this down to one field in both the rowset and i-Series file. The first error in the joblog is "Last known record near boundaries...", which after reading other forum entries tells me th...

iSeries program call not running?

XML code is attached. When I execute my project, it gets to the EXEC400 step and appears to be stuck. The "processing" icon stays on the screen until I shut it down and cancel the execution. The CL program being called should run in barely a second. On the iSeries, I found the job but it d...

Skip first row?

I am using the ReadCSV task to process records from a downloaded file. I use the Data feature in the ReadCSV task to specify and setup each column/index. The first record on the file is a header record with 4 columns - I need to bypass this record. The remaining records are detail records with 256 c...

Re: Establish columns on pipe-delimited file.

Thanks, Rick. That's exactly what I was looking for.

Establish columns on pipe-delimited file.

I'm relatively new to GoAnywhere, so this may be a simple task. I am downloading and decrypting a pipe-delimited text file (with CRLF as the row delimiter) and would like to place the contents into a DB2 file. I'm using the readFlatFile task to put the records into a rowset, but I cannot figure out ...