How to Load Table having Null Indicator on some columns

Hardik Vachhani · Posted: Tue Sep 08, 2009 4:54 pm

hi, i have too many insert queries in my application, we are supposed to remove the insert queries and replace them with load utilities,

my question is, can we load null indicator values from a flat file, i think we can not??

also while using multi-row concept for cursors having null indicator values, how can we go for it.

Bharath Bhat · Posted: Tue Sep 08, 2009 5:29 pm

Hardik Vachhani · Posted: Tue Sep 08, 2009 5:33 pm

i tried using multi row concept for cursors having null indicators in them but the code was abending during run time, i checked all everything else was fine, tried to run the code without those values and it ran fine.

while loading i have a doubt cause; i will have to maintain a seperate column in the flat file for the null indicators, so when i load them into table it will be considered as a table column. so can i directly load the flat file having null indicator column into table?

sushanth bobby · Posted: Tue Sep 08, 2009 5:34 pm

Hi H.D.V,

Hardik Vachhani · Posted: Tue Sep 08, 2009 5:39 pm

I tried to check through manual, but they have used this option while UNLOADing of table to flat file, but they didnt mention anything while performing LOAD operations.

GuyC · Posted: Tue Sep 08, 2009 5:39 pm

Ketan Varhade · Posted: Tue Sep 08, 2009 5:45 pm

Please search the forum,
Have a look at the Link

Ketan Varhade · Posted: Tue Sep 08, 2009 5:49 pm

Have a look at the Example

Bharath Bhat · Posted: Tue Sep 08, 2009 7:29 pm