How to convert non-db2 files into db2 format for ex . data in excel, ms-acces, oracle etc.

  • Interview Candidate
  • 9
  • 5130

Showing Answers 1 - 9 of 9 Answers

Anoop Nair

  • Feb 26th, 2014
 

You can convert non mainframe files like excel to mainframe raw files using FTP. Inside FTP tool, choose the option LAN to Mainframe and then process the request.

  Was this answer useful?  Yes

Rishu

  • Aug 7th, 2014
 

Guys, he is not asking how to FTP files to mainframe. He wants to know, how to convert excel file(tabular format) to DB2 table format.

  Was this answer useful?  Yes

Aravindhan

  • Oct 9th, 2015
 

Export the excel data as insert command with, separated data into an flat file format. FTP this file in mainframe and then execute the file by submit command.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions