How can I bulk-load a typed table?

[DTV12345]

Hello!

I have been assigned to bulk-load data into several typed tables of our ODS. I am not clear as to whether it can be done.

Here's my homework ===>>>

The easy way is to perform INSERT statements manually, like this

insert into 
callbacks
(
account_info, nbr_clbk, load_date
) 
values (
account_obj() ..account_number('123456') ..account_status('ACTV') ..dma_id('803') ..dma_name('Los Angeles') ..state('CA') ..zipcode('90245') 
, 1, '2007-02-20');

This works fine. The challenge is that I have to load about 500K rows daily for about 23 tables. The other challenge is that the source data I have to load is contained in "flat", normal tables.

I have tried several things. My first approach was to dump data from one of the flat tables and import/load back:

a) Import utility

IMPORT FROM "Z:\clbk_data.del" 
OF DEL MODIFIED BY COLDEL, DATESISO METHOD P (2, 3, 4) 
MESSAGES "Z:\clbk_data_load.out" 
replace into callbacks  (account_info, nbr_clbk, load_date);

It fails:

SQL3037N  An SQL error "-408" occurred during Import processing.

b) Load utility

LOAD CLIENT FROM "Z:\clbk_data.del" OF DEL MESSAGES "Z:\clbk_data_load.out" INSERT INTO callbacks COPY NO INDEXING MODE AUTOSELECT

It fails:

SQL3529N  The "LOAD" operation encountered the unsupported data type "Structured Data Type" in column "1".

c) I also tried (what I call) "derived" INSERT.

insert into 
callbacks (account_info, nbr_clbk, load_date) 
select 
account_number, account_status, dma_id, dma_name, state, zipcode, nbr_clbk, load_date from flat_table.

It fails....

Can somebody please help? If I have to write a program, I will but I'd like to know if this can be avoided...

My apologies for the long message. TIA for helping,

Al.

PS: My configuration is:
IBM DB v9.1
Linux RH