Re: MySql

Robert,

Thanks for the response.  I tried what you suggested however, this is
what is happening.  I have a .sql script whereby I drop tables, create
tables and then insert data into multiple schemas.

It would appear that after I run the entire script the DROP tables runs
successfully but I do not see that any of the tables have been created
and consequently no data has been inserted.  I have to run the CREATE
and INSERT separately.

Thanks in advance for any additional help or direction that you can give
me.

Regards.



Here is the contents of my script:

DROP TABLE DVCCNTL.DVCCNTL_MSR;
DROP TABLE DVCCNTL.DVCCNTL_SAR;
DROP TABLE DVCCNTL.DVCCNTL_SAR_CODE;
DROP TABLE DVCCNTL.DVCCNTL_VAR;
DROP TABLE INVITEM.INVITEM_ITL;
DROP TABLE INVITVND.INVITVND_VNI;
DROP TABLE INVITVND.INVITVND_VNI_PRICE;
DROP TABLE INVMFR.INVMFR_MFR;
DROP TABLE INVNOTES.INVNOTES;
DROP TABLE INVNOTES.INVNOTES_NOTE;
DROP TABLE INVPICK.INVPICK_TRK;
DROP TABLE INVPO.INVPO_POI_APV;
DROP TABLE INVPO.INVPO_POI;
DROP TABLE INVPO.INVPO_RQI;
DROP TABLE INVPO.INVPO_RQM_APV;
DROP TABLE INVPO.INVPO_RQM;
DROP TABLE INVTBLS.INVTBLS_DEL;
DROP TABLE VENDMSTR.VENDMSTR_VNM;

CREATE TABLE DVCCNTL.DVCCNTL_MSR
(
   PKEY INT PRIMARY KEY not null,
   DEFLTENTITYCODE VARCHAR(3) not null,
   DEPTNAME VARCHAR(40),
   EMAILADDR VARCHAR(40),
   LOCKOUTIND CHAR(1) not null,
   MASTRKEY VARCHAR(12) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   USERNAME VARCHAR(40) not null
);
CREATE TABLE DVCCNTL.DVCCNTL_SAR
(
   PKEY INT PRIMARY KEY not null,
   ENTITYCODE VARCHAR(3) not null,
   LOCKOUTIND CHAR(1) not null,
   LVLNUM VARCHAR(4) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   SUBLVLKEY VARCHAR(25) not null,
   SUBSYSTMNAME VARCHAR(3) not null
);
CREATE TABLE DVCCNTL.DVCCNTL_SAR_CODE
(
   FKEY INT not null,
   AUTHCODE VARCHAR(6) not null
);
CREATE TABLE DVCCNTL.DVCCNTL_VAR
(
   PKEY INT PRIMARY KEY not null,
   ENTITYCODE VARCHAR(3) not null,
   OPERTRID VARCHAR(8) not null,
   RECRDSTATUSCODE CHAR(1) not null,
   RECRDSTATUSDATE VARCHAR(8) not null,
   RECRDTYPE VARCHAR(3) not null,
   SUBSYSTMNAME VARCHAR(3) not null,
   VALADDCODE VARCHAR(6) not null,
   VALADDDESCR VARCHAR(64) not null,
   VALADDKEY VARCHAR(30) not null
);

-- Insert user information for xxxxxx
INSERT INTO DVCCNTL.DVCCNTL_MSR
(PKEY,DEFLTENTITYCODE,MASTRKEY,OPERTRID,LOCKOUTIND,RECRDSTATUSCODE,RECRD
STATUSDATE,RECRDTYPE,USERNAME) VALUES
(1,'PHP','','smithed','N','A','','MSR','xxxxxx');
INSERT INTO DVCCNTL.DVCCNTL_SAR
(PKEY,ENTITYCODE,LVLNUM,RECRDSTATUSCODE,SUBSYSTMNAME,LOCKOUTIND,RECRDTYP
E,OPERTRID,SUBLVLKEY,RECRDSTATUSDATE) VALUES
(1,'PHA','0000','A','INV','N','SAR','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_SAR
(PKEY,ENTITYCODE,LVLNUM,RECRDSTATUSCODE,SUBSYSTMNAME,LOCKOUTIND,RECRDTYP
E,OPERTRID,SUBLVLKEY,RECRDSTATUSDATE) VALUES
(2,'PHP','9999','A','INV','N','SAR','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(1,'CAPLMT','9999999','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(2,'COMTYP','ALL','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(3,'DEPT','ALL','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(4,'NSKLMT','9999999','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(5,'PURCH','8681','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(6,'STKLMT','9999999','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(7,'REPORT','ALL','A','INV','VAR','PHA','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(8,'ACCT','12500020','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(9,'CAPLMT','9999999','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(10,'COMTYP','ALL','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(11,'DEPT','ALL','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(12,'NSKLMT','9999999','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(13,'PURCH','8681','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(14,'STKLMT','9999999','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_VAR
(PKEY,VALADDCODE,VALADDDESCR,RECRDSTATUSCODE,SUBSYSTMNAME,RECRDTYPE,ENTI
TYCODE,OPERTRID,VALADDKEY,RECRDSTATUSDATE) VALUES
(15,'REPORT','ALL','A','INV','VAR','PHP','xxxxxx','','');
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('51VCON',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('52MCON',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('49CHSP',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('57HNDJ',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('58HNDT',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('61TPRS',1);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('01VREQ',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('03ASTK',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('04ANSK',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('29VINV',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('40MCOM',2);
INSERT INTO DVCCNTL.DVCCNTL_SAR_CODE (AUTHCODE,FKEY) VALUES
('62HNDP',2);

INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(4,null,null,null,null,'8681',null,'20060510','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060510',9.97,'CDPPJR
C',null,null,'1010',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060510','POI','20060601','10009635',9.97,null,null,'N','
N',null,null,'283',null,'123','REG','JACK TEST',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(6,null,null,null,null,'6000',null,'20060511','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060511',0.1,'CDPPJMP
',null,null,'4050',null,'8681',null,null,null,null,null,'20060531','EA00
001',1.0,null,'A','20060511','POI','20060531','10009639',0.1,null,null,'
N','N',null,null,'283',null,'T-1','REG','T-1',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(7,null,null,null,null,'8681',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060524',20.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','10009656',20.0,null,null,'N','
N',null,null,'283',null,'TEST RETUR','REG','TEST RETURN',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(8,null,null,null,null,'8681',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060526',12.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','10009657',12.0,null,null,'N','
N',null,null,'283',null,'TEST DESCR','REG','PUT DESCRIPTION ON LINE
1.',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(9,null,null,null,null,'8681',null,'20060526','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHA',null,'N',null,'20060526',25.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060526','POI','20060601','10009658',25.0,null,null,'N','
N',null,null,'283',null,'TEST KRB','REG','TESTING',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(10,null,null,null,null,'6768',null,'20060510','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060510',9.97,'CDPPJR
C',null,null,'1010',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060510','POI','20060601','15687754',9.97,null,null,'N','
N',null,null,'283',null,'123','REG','JACK TEST',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(11,null,null,null,null,'6132',null,'20060511','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060511',0.1,'CDPPJMP
',null,null,'4050',null,'8681',null,null,null,null,null,'20060531','EA00
001',1.0,null,'A','20060511','POI','20060531','15687755',0.1,null,null,'
N','N',null,null,'283',null,'T-1','REG','JACK TEST',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(12,null,null,null,null,'8864',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060524',20.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','15687756',20.0,null,null,'N','
N',null,null,'283',null,'TEST RETUR','REG','TEST RETURN',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(13,null,null,null,null,'6398',null,'20060524','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060526',12.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060524','POI','20060601','15687757',12.0,null,null,'N','
N',null,null,'283',null,'TEST DESCR','REG','SOME DESCRIPTION
HERE',null,null);
INSERT INTO INVPO.INVPO_POI (PKEY,
GLACCTNUM,BACKORDRQTY,CAPEXPNSREQSTNUM,CHANGETKTNUM,CHRGTODEPTCODE,COMMN
LIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTOINDIV,EDIBATCHNUM,EDIDOWNLOADDA
TE,EDIDOWNLOADTIME,EDISTATUS,ENTITYCODE,EOMIND,INVCEFLAGIND,ITEMNUM,LAST
CHGDATE,UNITPRICE,OPERTRID,MFGCATLGNUM,MODELSERIALNUM,NECCODE,NEEDDATE,P
URCHDEPTCODE,ORIGNLVENDORCATNUM,PATIENTENCNTRNUM,PATIENTNAME,PHYSNNAME,P
ONUM,PROMSDDATE,PURUNITOFMEAS,QTYORDRD,QTYRECVD,RECRDSTATUSCODE,RECRDSTA
TUSDATE,RECRDTYPE,REQNDATE,REQNNUM,REQNTOTL,RQILINK,SRCELOCATN,STATIND,R
EQNTYPECODE,VENDORCATLGCHGDATE,VENDORCATLGCHGIND,VENDORNUM,VERIFYDATE,VE
NDORCATLGNUM,POTYPECODE,ITEMDESCR1,ITEMDESCR2,ITEMDESCR3) VALUES
(14,null,null,null,null,'7591',null,'20060526','8681','GENERAL STORES -
BASEMEN',null,null,null,null,'PHP',null,'N',null,'20060526',25.0,'CDPPKR
B',null,null,'4050',null,'8681',null,null,null,null,null,null,'EA00001',
1.0,null,'A','20060526','POI','20060601','15687758',25.0,null,null,'N','
N',null,null,'283',null,'TEST KRB','REG','TESTING',null,null);

INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(4,'xxxxxx','20050908','24:24:24');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(6,'xxxxxx','20060907','02:22:22');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(7,'xxxxxx','20060915','13:30:29');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(8,'xxxxxx','20060916','10:30:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(9,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(10,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(11,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(12,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(13,'xxxxxx','20060920','07:15:18');
INSERT INTO INVPO.INVPO_POI_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(14,'xxxxxx','20060920','07:15:18');

INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28546,null,null,'EA00001',null,'8681',null,'20060509','8681',null,null,
null,'PHA','304510020','I','20060524','1',17.89,'CDPPKRB','4050',null,'8
681',null,2.0,null,'A','20060509','RQI','10009621','8681',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28554,null,null,'EA00001',null,'8681','CART6000','20060509','8681',null
,null,null,'PHA','304510075','I','20060509','1',0.45,'UNGTH','0510',null
,'8681',null,1.0,null,'A','20060509','RQI','387','8681',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28569,null,null,'EA00001',null,'6000','JMP','20060511','8681',null,null
,null,'PHA','304510183','B','20060511','1',0.05,'CDPPJMP','4057',null,'8
681',null,1.0,null,'A','20060511','RQI','10009637','6000',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28571,null,null,'EA00001',null,'8681','JMP','20060511','8681',null,null
,null,'PHP','304588970','B',null,'1',5.2,'CDPPJMP','4080',null,'8681',nu
ll,1.0,null,'A','20060511','RQI','10009638','6000',null);
INSERT INTO INVPO.INVPO_RQI
(PKEY,GLACCTNUM,BACKORDRQTY,UNITOFMEAS,LOCATNBINCODE,CHRGTODEPTCODE,COMM
NLIST,CREATEDATE,DELIVRTODEPTCODE,FILLDDATE,FILLDQTY,FILLDTIME,ENTITYCOD
E,ITEMNUM,ISSUEIND,LASTCHGDATE,LINEITEMCOUNT,UNITPRICE,OPERTRID,NECCODE,
ORIGQTYORDRD,ORDRDBYDEPTCODE,POILINK,ORDQTY,QTYRECVD,RECRDSTATUSCODE,REC
RDSTATUSDATE,RECRDTYPE,REQNNUM,ISSUEFROMDEPTCODE,TYPESWITCH) VALUES
(28593,null,null,'EA00001',null,'8681','JMP','20060517','8681',null,null
,null,'PHP','304588972','B','20060517','1',1.02,'CDPPJRC','0510',null,'8
681',null,1.0,null,'A','20060517','RQI','10009653','7000',null);

INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(499,null,null,null,'6000',null,null,'19940118','6000','PACU LEVEL 2
TOWER','PHA',null,'I','CDPPJJS',null,'6000',null,null,null,'A','20051003
','RQM','19940118','10009621',null,null,null,'8681','19940119','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(849,null,null,null,'SPLT',null,null,'19940121','SPLT','RAD LEVEL
3','PHA',null,'I','CDPPRWP',null,'6000',null,null,null,'A','20051003','R
QM','19940121','387',null,null,null,'8681','19940124','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(7056,null,null,null,'7002',null,'PACU','20051114','7002','PACU LEVEL 2
TOWER
B','PHA',null,'I','UNGTH',null,'7002',null,null,null,'A','20051114','RQM
','20051114','10009637',97.24,null,null,'6000','20051114','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(17940,null,null,null,'7006',null,null,'20051114','7006','SURGERY LEVEL
2 TOWER
A','PHP','Y','I','WEB.APPR',null,'7006','90548547491559','S135','Y52','A
','20051114','RQM','20051114','10009638',600.0,null,null,'6000','2005111
5','I');
INSERT INTO INVPO.INVPO_RQM
(PKEY,GLACCTNUM,CAPEXPNSREQST,CHANGETKTNUM,CHRGTODEPTCODE,CHGDELIVRYIND,
COMMNLIST,CREATEDATE,DELIVRTODEPTCODE,DELIVRTODEPTLOC,ENTITYCODE,INVCEFL
AGIND,ISSUEIND,OPERTRID,MODELSERIALNUM,ORDRDBYDEPTCODE,PATIENTENCNTRNUM,
PATIENTNAME,PHYSNNAME,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REQNDATE
,REQNNUM,REQNTOTLAMT,REQSTDDELIVRYDATE,REVSDDELIVRYDATE,ISSUEFROMDEPTCOD
E,SCHEDDELIVRYDATE,TYPESWITCH) VALUES
(17953,null,null,null,'6620',null,'ZPSCU','20051110','6620','LEVEL 2
LINK BEHIND
DSCU','PHP',null,'I','CDPPKRB',null,'6620',null,null,null,'A','20051110'
,'RQM','20051110','10009653',null,null,null,'7000','20051111','I');

INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(499,'savoym','20050905','01:01:01');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(849,'savoym','20060906','01:11:11');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(7056, 'savoym','20060915','13:30:29');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(17940, 'savoym','20060916','10:30:18');
INSERT INTO INVPO.INVPO_RQM_APV (FKEY,NXTACT,APRVDT,APRVTM) VALUES
(17953, 'savoym','20060920','07:15:18');

INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3454,78.7,'Y','N','N',0.0,'20000828','20060125','20060125','8681',14.0,
500.0,'PHA',null,'RECV10','8681','304510020','20030828','4545',null,'N',
null,0.0,541.0,null,'A','20000828','ITL',260.0,'VNDR',7.0,'Y',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3455,0.24,'N','N','N',0.0,'20020812','20060124',null,'8681',0.0,0.0,'PH
A',null,null,'8681','304510075',null,'4050',null,'Y',null,null,null,null
,'A','20020812','ITL',0.0,'VNDR',0.0,'N',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3456,-0.28,'Y','N','N',0.0,'20060310','20060603','20060310','8681',2.0,
0.0,'PHA',null,null,'6000','304510183',null,'4050',null,null,null,null,2
4.0,null,'A','20060310','ITL',0.0,'VNDR',1.0,'Y',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3457,-0.16,'Y','N','N',0.0,'20060404','20060604','20060404','8681',2.0,
0.0,'PHP',null,null,'6000','304588970',null,'4050',null,null,null,null,1
0.0,null,'A','20060404','ITL',0.0,'VNDR',1.0,'Y',1.0);
INSERT INTO INVITEM.INVITEM_ITL
(PKEY,ACTUALUSAGE,AUTOREPLNSHIND,CALCDOQIND,CRITICALITEMIND,CRITICALQTY,
CREATEDATE,AVGUSECALCDATE,LASTUSAGEDATE,PURCHSNGDEPTCODE,DESIRDINVDAYS,D
YNAMCORDRQTY,ENTITYCODE,ISSUEIND,LOCATNBINCODE,LOCATNDEPTCODE,ITEMNUM,LA
STCHGDATE,NECCODE,PARLEVEL,PATIENTCHGIND,PROBLMIND,OWEDQTY,ONHANDQTY,ONO
RDRQTY,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,REORDRPTVOLUME,REPLNSHF
ROMDEPT,SAFETYSTKDAYS,STKIND,STKLVL) VALUES
(3458,null,'N','N','N',0.0,'20060509',null,null,'8681',0.0,0.0,'PHP',nul
l,null,'7000','304588972',null,'4050',null,null,null,null,null,null,'A',
'20060509','ITL',0.0,'VNDR',0.0,'N',1.0);

INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(125,'Y',null,'20060601','PHA','304510020',null,3.0,'HSC987654','3050',5
.0,'01','AVNIHAR3045050020102','01','EA00001','A','19891218','VNI','2','
NONE','DRIP PAN - SEMI-STERILE','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(126,'N',null,'20060101','PHA','304510075',null,5.0,'998776655','7840',2
.0,'01','AVNIHAR3045050020103','01','EA00001','A','19891218','VNI','3','
IBM-1212','STERILE PROCEDURE BASIN','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(127,'N',null,'20061201','PHA','304510183',null,1.0,'J&J111222','8441',3
.0,'01','AVNIHAR3045050020104','01','EA00001','A','19891218','VNI','4','
IBM-1213','BASIN, PROCEDURE, STERILE','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(128,'N',null,'20040115','PHP','304588970','20040317',3.0,'HSC987654','2
069',1.0,'01','AVNIHSW3045050029902','01','EA00001','A','20040317','VNI'
,'2','NONE','DRIP PAN - SEMI-STERILE','1480',null);
INSERT INTO INVITVND.INVITVND_VNI
(PKEY,AUTOSUBIND,VENDORCONTRCTNUM,CREATEDATE,ENTITYCODE,ITEMNUM,LASTCHGD
ATE,LEADTIME,MFRCATLGNUM,MFRNUM,ORDRMULTINUM,PREFRNCECODE,PRIMARYKEY,VEN
DORRANKING,PURUNITOFMEAS,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,SEQNU
M,VENDORCATLGNUM,VENDORDESCR,VENDORNUM,MFRCONTRCTNUM) VALUES
(129,'Y',null,'20060504','PHP','304588972',null,3.0,'XXX666','7840',1.0,
'01','AVNIHAR3050001280801','01','CS00100','A','19900119','VNI','1','121
212126666666','24D TRIEX TABS 2773222 HYDROPHOBIC','39',null);

INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (15.0,'20040219',125);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (47.5,'19901013',126);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (0.0,'19881001',127);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (100.0,'19881001',128);
INSERT INTO INVITVND.INVITVND_VNI_PRICE (PURPRICE,PURPRICEDATE,FKEY)
VALUES (135.0,'19970904',129);

INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES (0,'1234567890123','20060601','JOHNSON & JOHNSON
INC.','3050','HIN',null,null,null,'A','20020705','MFR','CDPPKRB');
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES (1,'1234567890XXX',null,'J &
J','7840','DUN','1234567890123','JOHNSON &
JOHNSON','1','A','20020705','MFR',null);
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES
(2,'1234567890','20030107','JOHNSON','8441','DUN','1234567890123','JOHNS
ON & JOHNSON','1','A','20040704','MFR','CDPPJRC');
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES
(3,'ABCDEFGHIJKLM','20030203','SURGIKOS','2069','GLN',null,null,null,'A'
,'20060501','MFR','CDPPJMP');
INSERT INTO INVMFR.INVMFR_MFR
(PKEY,EXTRNLMFRNUM,LASTCHGDATE,MFRNAME,MFRNUM,MFRTYPECODE,PARENTEXTRNLNU
M,PARENTNAME,PARENTNUM,RECRDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE,OPERTRI
D) VALUES (4,'1876512340000',null,'SURGICAL SUPPLY
COMPANY','2840','GLN',null,null,'4','A','20060205','MFR',null);

INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (1,'PHA','20060705','123450','12345678
','CDPPKWM ','A','20050908','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (2,'PHA','20060706','143451','12345678
','CDPPKWR ','A','20050912','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (3,'PHA','20060707','143452','12345678
','CDPPKWS ','A','20050913','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (4,'PHA','20060707','143452','09458641
','CDPPKWM ','A','20050907','REQ');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (5,'PHP','20060601','084648','12345678
','CDPPKWM ','A','20060601','POI');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (6,'PHP','20060601','084648','12345678
','CDPPKWR ','A','20060601','POI');
INSERT INTO INVNOTES.INVNOTES
(PKEY,ENTITYCODE,ENTRYDATE,ENTRYTIME,ITEMNUM,OPERTRID,RECRDSTATUSCODE,RE
CRDSTATUSDATE,RECRDTYPE) VALUES (7,'PHP','20060601','084648','12345678
','CDPPKWS ','A','20060601','POI');

INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-2.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-3.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-4.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-5.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-6.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-7.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (1,'This is note
#1-8.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (2,'This is note
#2-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (3,'This is note
#3-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (3,'This is note
#3-2.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (4,'This is note
#4-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-2.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-3.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-4.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-5.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (5,'This is note
#1-6.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (6,'This is note
#2-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (7,'This is note
#3-1.');
INSERT INTO INVNOTES.INVNOTES_NOTE (FKEY,NOTE) VALUES (7,'This is note
#3-2.');

INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(45,'PHA','4050','20040101','PHA','BAXTER HOSPITAL
SUPPLY','MARTINK','A','19950717','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(46,'PHA','5151','20040101','PHA','BAXTER
SCIENTIFIC','SMITHED','A','19950717','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(47,'PHA','7845','20040101','PHA','BAXTER HOSPITAL
(EDS)','SAVOYM','D','19980217','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(48,'PHP','7815','20040101','PHP','BAXTER HOSPITAL
(VMUELLER)','SAVOYM','A','19950706','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(49,'PHP','7841','20040101','PHP','BAXTER BENTLEY
(EDWARDS)','SMITHED','A','19950313','TPR');
INSERT INTO INVTBLS.INVTBLS_DEL
(PKEY,ENTITYCODE,DEPTNUM,LASTCHGDATE,LOCATNDESCR,LOCATNNAME,OPERTRID,REC
RDSTATUSCODE,RECRDSTATUSDATE,RECRDTYPE) VALUES
(50,'PHP','6875','20040101','PHP','BAXTER
WHATEVER','SMITHED','A','19950313','TPR');

INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (6312,'6174','CONCORD LABORATORIES, INC.','A','SPC','19881026');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (21375,'17049','WELTY WELDING','A','SPC','19920210');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (21394,'17060','COMPUTER CONSULTING','A','SPC','19930728');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (21401,'17065','TEST VENDOR #4','A','SPC','20000523');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41019,'17105','KASEY','A','SPC','20040310');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41035,'98367','LADAY GROUP, THE','A','VNM','20050802');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41039,'88656','HOTLINK MARKETING, HOTLINK
INC','A','VNM','20020910');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41044,'60790','SOFTWARE HOUSE INTERNATIONAL
I','A','VNM','19980310');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41069,'49865','U.S. FOODSERVICE INC','A','VNM','19960717');
INSERT INTO VENDMSTR.VENDMSTR_VNM
(PKEY,VENDORNUM,VENDORNAME,RECRDSTATUSCODE,RECRDTYPE,RECRDSTATUSDATE)
VALUES (41078,'17109','KEN TEST VENDOR','A','VNM','20060509');


-----Original Message-----
From: Robert Manning [mailto:robert.m.manning@xxxxxxxxx] 
Sent: Monday, December 04, 2006 4:12 PM
To: Savoy, Melinda
Cc: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Squirrel-sql-users] MySql

On 12/4/06, Savoy, Melinda <MelindaSavoy@xxxxxxxxxxxxxxx> wrote:
>
>
>
> I am using MySql 5.0 and I connected to this database via Squirrel 
> SQL.  I have multiple schemas/databases under my localhost.  However, 
> when I try and run a .sql script that drops tables from multiple 
> schemas & then populates them in the various schemas  I run into an 
> error saying that it does not recognize the first schema name to drop 
> the table.  I can run this thru MySQL but not through Squirrel and it
would be great if I could.

As long as in each statement you qualify the table name with the schema
it shouldn't be a problem.  I'm using 5.0.22 and I can create and drop
tables in schemas other than the one I connected to (<dbname> in url
jdbc:mysql://localhost:3306/<dbname>).  Note: there is ongoing
consideration being given to the fact that only one catalog's tables
(catalog is really the term for schema in MySQL) can be accessed in the
object tree based on the catalog selected in the catalog selector at the
top of the session window.

Rob




The information contained in this message and any attachments is intended only 
for the use of the individual or entity to which it is addressed, and may 
contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from 
disclosure under applicable law.  If you are not the intended recipient, you 
are prohibited from copying, distributing, or using the information.  Please 
contact the sender immediately by return e-mail and delete the original message 
from your system.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV