//PS112DF  JOB (516B,1025),'create PSTORE Tables'                               
//*
//* 5655-F31 (C) Copyright IBM Corp. 2001
//* All Rights Reserved.
//* U.S. Government users - RESTRICTED RIGHTS - Use, Duplication, or
//* Disclosure restricted by GSA-ADP schedule contract with IBM Corp.
//* Status = H28W401
//* This program may be used, executed, copied, modified and distributed
//* without royalty for the purpose of developing, using, marketing,
//* or distributing.   
//*                                                                             
//* 1) FILL AN THE APPROPRIATE JOB CARD ABOVE                                   
//* 2) FILL IN THE APPROPRIATE DB2 SUBSYSTEM NAME %DB2 SSN%                     
//* 3) FILL IN THE DB2 HIGH LEVEL QUALIFIER %DB2 HLQ%                           
//*                                                                             
//DROPTAB EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)                             
//SYSTSPRT DD  SYSOUT=*                                                         
//SYSTSIN  DD  *                                                                
 DSN SYSTEM(%DB2 SSN%)                                                               
 RUN  PROGRAM(DSNTIAD) PLAN(DSNTIA71) -                                         
      LIB('%DB2 HLQ%.RUNLIB.LOAD')                                                 
//SYSPRINT DD  SYSOUT=*                                                         
//SYSUDUMP DD  SYSOUT=*                                                         
//SYSIN    DD  *                                                                
drop table lineitem;                                                            
drop table orderstatus;                                                         
drop table orders;                                                              
drop table account;                                                             
drop table profile;                                                             
drop table bannerdata;                                                          
drop table inventory;                                                           
drop table item;                                                                
drop table product;                                                             
drop table category;                                                            
drop table supplier;                                                            
drop table sequence;                                                            
drop table signon;                                                              
                                                                                
drop tablespace ESTOREDB.ESTORETS                                               
;commit;                                                                        
                                                                                
drop database ESTOREDB                                                          
;commit;                                                                        
                                                                                
/*                                                                              
//*