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:
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.
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.
Lead Solutions Consultant