Load the data into temp table same structure but no mandatories.
Whats 's the field definitions.
I an H or T record the data file contains nothing (null)
"Jack Dawson" <srik_at_cnet.com> wrote in message
news:983vat$sml$1_at_innbox.cnet.com...
> I have a file in which the data is like this
>
> H1 4600019786R03020195010195013195
> R0300000110720790101950000002090010295
> R0300000000000580202950068400271010295
> T1 000000 00000000000 000025 00000184637
>
> I need to load this data in 2 different tables they are .....
header_table,
> detail_table
>
> My sql loader uses the WHEN clause so that the tables are loaded
>
> WHEN it starts with H
> it goes into header_table,
> WHEN it starts with R
> it goes into detail_table,
> WHEN it starts with T
> it goes into remaining columns in header_table
>
> However when loading the T1 record into header _table i get an error
>
> ORA-01400: cannot insert NULL into ("HEADERS_TABLE")
>
> I am trying all possible ways to get it solved but of no avail
>
> Please help, it helps me to proceed further
>
> Thanks
> Jack
>
>
>
>
>
>
>
Received on Tue Mar 06 2001 - 20:33:11 CST
