9 Replies Latest reply: Aug 28, 2012 8:04 AM by Lars Breddemann RSS

selective UNLOAD from memory

Rajarshi Muhuri
Currently Being Moderated

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'

Actions