Skip to Content
0
May 16, 2012 at 08:08 PM

selective UNLOAD from memory

191 Views

I can UNLOAD data from RAM to persistance storage using the command

unload schema.tablename1

and I can reload it using the command

load schema.tablename1 ALL ; or load schema.tablename1 column1, column 2 ..)

Is there any way I do selective LOAD of data based on a condition ...

i.e

LOAD schema.table1 column 1, column2 where column2='2010'