Reading an AS400 .MBR file to a flat file using Java
<p>This is what I have been trying to achieve.</p>

<p>We are in process to let go a vendor tool called GO-Anywhere that reads data from an DB2 database after firing a select query creates a file writes data to it zips it and sftps it to a machine where our ETL tool can read it.</p>

<p>I have been able to achieve what GA does in almost the same time infact beating the above tools by 5 minutes on a 6.5GB file by using JSCH and jaring un-jaring on the fly. This brings down the time to read and write the file from earlier 32 minutes to now 27 minutes.</p>

<p>But to meet the new SLA requirements we need to further bring down the time to almost half of what I have that is something around 13 odd minutes</p>

<p>To achieve the above I have been able to read the .MBR file directly and push the same on to the Linux machine in 13 minutes or less but the format of this file is not clear text.
I would like to know how can one convert the .MBR file into plain text format using Java or using AS400 command without firing the SQL. </p>

<p>Any help appreciated.</p>