DB2 with Easytrieve tips

If you use the DB2 interface with Easytrieve, learn how to set up a DB2 interface so the layout can be retrieved dynamically.

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.

This was last published in June 2001

Dig Deeper on DB2 UDB (universal databases)



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: