Establish columns on pipe-delimited file.
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
3 posts
Page 1 of 1
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 how or where to tell GoAnywhere that the file is pipe-delimited so that I can assign column characteristics and move the necessary columns into the DB2 file.
My project tasks are:
Create Workspace
SFTP Task
-------Get Files
-------------Fileset
PGP Decrypt Task
Read Flat File Task
SQL Task (for connecting to AS400)
--------Query Element (for importing data into DB2 file)
Any help or other suggestions would be appreciated.
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 how or where to tell GoAnywhere that the file is pipe-delimited so that I can assign column characteristics and move the necessary columns into the DB2 file.
My project tasks are:
Create Workspace
SFTP Task
-------Get Files
-------------Fileset
PGP Decrypt Task
Read Flat File Task
SQL Task (for connecting to AS400)
--------Query Element (for importing data into DB2 file)
Any help or other suggestions would be appreciated.
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Try using the ReadCSV instead of the ReadFlatFile task.
This will give you the option to change the Field Delimiter as well as the record delimiter (if necessary).
Then, you can do the insert by field into your DB2 Table using the Rowset Variable created from the ReadCSV Task.
This will give you the option to change the Field Delimiter as well as the record delimiter (if necessary).
Then, you can do the insert by field into your DB2 Table using the Rowset Variable created from the ReadCSV Task.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
3 posts
Page 1 of 1