Loading the DB2 data

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.

MULTIRD specifies a value for IRDTYPE when IRDFUNCT is L. When you use the VIDLOAD utility with the LOADOUTM DD, each record has a 2-byte prefix. The prefix for records for the primary table is always 00. The prefix for the secondary tables is whatever you set in IRDTYPE. Here is an extract of the load file for APPLCTL:
----+----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
You must add a statement to your DB2 load utility control cards to select the appropriate records. For example, to load the primary table use the control card:
WHEN (1:2) = ‘00'

Because of DB2 referential integrity, you must load the primary table first.


Concept Concept

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtdecloaddb2data.html