Archives of the TeradataForum

Message Posted: Wed, 14 Jul 2004 @ 15:09:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You can have as many tables as needed in an mload, just make sure the WT, ET, and UV tables are paired.

For example:

     BEGIN IMPORT MLOAD
            TABLES          &DB_SR_LINE,
                            &DB_ITIN_CPN,
                            &DB_PYMT,
                            &DB_TKT

            WORKTABLES      &DB_SR_LINE_WT,
                            &DB_ITIN_CPN_WT,
                            &DB_PYMT_WT,
                            &DB_TKT_WT

            ERRORTABLES     &DB_SR_LINE_ET
                            &DB_SR_LINE_UV,
                            &DB_ITIN_CPN_ET
                            &DB_ITIN_CPN_UV,
                            &DB_PYMT_ET
                            &DB_PYMT_UV,
                            &DB_TKT_ET
                            &DB_TKT_UV

            AMPCHECK ALL
            SESSIONS 16

The comma placement is critical to getting mload to work properly.

	<Prev	Next>		<<First	<Prev	Next>	Last>>