select location_id, container_id, container_status, appt_nbr from container

where container_id like 'B%';

update APPT_STATUS set container_status='D'

where APPT_NBR ='796';

delete from CONTAINER where CONTAINER_id = `R0000118000000116273';

commit;

delete from CONTAINER_history where CONTAINER_id = `R0000118000000116273';

commit;

delete from CONTAINER_history

where container_id = `00000118000000093215';

commit;

select container_id, attribute, attribute_value from container_attribute

where container_id='B%';

spool /home/retekro/iw.txt

select * from WAVE_DAY_TO_NBR

where wave_nbr='902';

spool off

---