The output file your.APPLCTL.LOADDB2 from the VIDLOAD utility is loaded into DB2®. Because APPLCTL is converted to multiple tables, the records in this file are for multiple tables in DB2.
----+----1----+----2----+----3----+----4----+----5----+----6
00AD2021010THOMSONJOSBORNEI1998-04-25......................
10AD2021010THOMSONJAPYACCTS PAYABLE BLENKINSOPFIONA 2
00FL3055020PALLINMJHALLAJ 2000-10-03........................
20FL3055020PALLINMJAPYCHEQUES ACCCHQ ACCCPAT1
00FL3055020THOMSONJHALLAJ 2000-10-03........................
20FL3055020THOMSONJAPYRECEIPTS ACCRCPT ACCCPAT1
00JB8383040MCGRAWA MCGURND 2005-11-15........................
40JB8383040MCGRAWA APYPAPD0205MONTHLY REPORTS YYYNNYMACCOUNT
00PG5267030STEWARTHRITCHIEA2004-06-28........................
30PG5267030STEWARTHAPYA407DLG LEDGER DAILY RECONCILE 00005
WHEN (1:2) = ‘00'
Because of DB2 referential integrity, you must load the primary table first.