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 ...




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