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
Expand|Select|Wrap|Line Numbers
- 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');
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
Expand|Select|Wrap|Line Numbers
- 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);
Expand|Select|Wrap|Line Numbers
- SQL3037N An SQL error "-408" occurred during Import processing.
Expand|Select|Wrap|Line Numbers
- LOAD CLIENT FROM "Z:\clbk_data.del" OF DEL MESSAGES "Z:\clbk_data_load.out" INSERT INTO callbacks COPY NO INDEXING MODE AUTOSELECT
Expand|Select|Wrap|Line Numbers
- SQL3529N The "LOAD" operation encountered the unsupported data type "Structured Data Type" in column "1".
Expand|Select|Wrap|Line Numbers
- 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.
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