I'm trying to use the load utility to load a text file to a DB2 table.
I set up all the starting and ending field positions to match up with the columns but a key field is not on the text file.

Is there a way to insert this value into the field by default?

Here's my load statement:
------------------------------------------
#!/bin/bash
db2 "CONNECT TO BPS"
db2 "DELETE FROM NYSA.BP30T_DOB_BPS"
db2 "LOAD FROM bps_dob_load OF ASC METHOD L (2001,1 5,7 9,11 13,15 16,18 18,20 23,25 28,30 34,35 49,51 55,57 80,82 98) INSERT INTO NYSA.BP30T_DOB_BPS (BUDGET_YR, AGENCY_CODE, FUND_TYPE, FUND_CODE, ACCT_CODE, CATEGORY, PROG_CODE, MODULE, DOB_YR, EVENT_NAME, DOB_OBJECT, SUMMARY_VALUE, GROUP_TYPE)"
----------------------------------------------------------------------------

The required field is the first field, BUDGET_YR.
I tried to do it the above way by hard-coding 2001 as the year.

Here's my table layout:
--------------------------------------------------------
struct
{
short budget_yr;
char agency_code[5+1];
char fund_type[3+1];
char fund_code[3+1];
char acct_code[2+1];
char category[1+1];
char prog_code[4+1];
char module[4+1];
char dob_yr[4+1];
char event_name[15+1];
char dob_object[5+1];
sqlint32 summary_value;
char group_type[16+1];
} bp30;
----------------------------------------------------------------

Is there a way to do this?

Thanks in Advance.
John