If you use the DB2 Interface with Easytrieve you may need to provide the DB2 table layouts in your Easytrieve program....
There is a way that Easytrieve's DB2 interface can be set up by the systems programmer so that the layout can be retrieved dynamically.If you have BMC Unload Plus there is an extremely easy way to get the DB2 table layouts for your Easytrieve program. In the SYSIN dataset (control cards) use the following option: CNTLCARDS EASYTRIEVE.
You can use SYSREC DUMMY, if you only want the Easytrieve layout. After running the Unload job your DB2 table layout will be in Easytrieve format and will be in the SYSCNTL dataset.