Challenge Overview
There are times when a new country and company needs to be set up for the BonD (Buy on Demand) application within IBM. Configuration work for this setup for BonD consists of the creation of several SQL insert or insert/select statements. An Excel file is used as input from which to read that will provide the data values needed to form the SQL statements.
A successful submission of this event will be a file of well-formed DB2 insert statements to configure the new countries and companies provided in the attached Excel file. The design should successfully read from the Excel file and generate an output file of SQL statements. The SQL statements will not be run into the database. That will be performed by our team separately, so there is no requirement to connect to or execute the SQL statements against the database.
Final Submission Guidelines
N/A