Problem:
You can use our default XDB support to create PC 'DB2' databases (DB2 is really an IBM registered name, SQL might be more exact). Or if you have purchased IBM's PC version of DB2 (named UDB), then you can use our HCO option to create/populate SQL databases. There is no
separate XDB/HCO option.
Resolution:
The SQL option gives you both for Mainframe Express. XDB works without IBM software. HCO requires IBM software. Both have GUI database create/populate features. You may want to either download some sample test data for SQL or download the DDL statements and use them for creating the PC database, then populate it in Mainframe Express. For IMS you have three choices:
- download some sample data from the host for test usage
- use the IMS Data File Editor in MFE to add data to the IMS database used by Mainframe Express
- add test data via a Cobol program that does database inserts
The IMS option has no GUI interface for populating a database, but the default PDB, DBD gen process will create a database and Zeroload it, which is sometimes enough for testing purposes. Regardless of the method used, the host PSB, DBD and MFS source files must be downloaded along with the Cobol programs and associated copybooks and JCL files. MFIMS supports DLI, MPP and BMP programs. IMS programs can use Exec Sql statements if you are referencing an IMS database and a SQL one in the same program.
#MFDS
#EnterpriseDeveloper
