Descarregar una taula

Descarregar de la memória totes les taules d’un esquema:

DROP PROCEDURE unload_tables;

CREATE PROCEDURE unload_tables( IN pi_schema VARCHAR(60), IN pi_table VARCHAR(60) ) LANGUAGE SQLSCRIPT AS
CURSOR c_cursor1 FOR
SELECT TABLE_NAME
FROM M_CS_TABLES
WHERE RECORD_COUNT != 0
  AND SCHEMA_NAME = :pi_schema
  AND (TABLE_NAME = :pi_table or :pi_table = '');
BEGIN
  FOR cur_row as c_cursor1() DO
    EXEC 'UNLOAD "' || :pi_schema || '"."' || cur_row.TABLE_NAME || '"';
  END FOR;
END;

-- unload all tables of schema SAPBW1

call unload_tables('SAPBW1','');