Following is the DEXSQL.log from selecting the Create button and then the OK button. Any assistance would be appriecated.
/* Date: 11/19/2015 Time: 8:52:04
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_3('sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_3('sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:04*/
BEGIN TRANSACTION if exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = ? and table_path_name = 'ZTEST.dbo.MRP1030') begin commit transaction raiserror ('DEXSHR',15,2) end else begin BEGIN UPDATE ZTEST.dbo.MRP1030 SET CB_I = ?, ACTIONTAKEN_I = ? WHERE CB_I = ? AND ACTIONTAKEN_I = ? AND USERID = ? AND VENDORID = ? SELECT @@rowcount END commit transaction end
/* Date: 11/19/2015 Time: 8:52:04*/
Prepared stmt(151747472):
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030N_3(25,'sa',0,'16350','sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:04*/
Prepared stmt(151747472):
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030N_3(25,'sa',0,'17100','sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:04
stmt(151748376):*/
SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1030 WHERE USERID = 'sa' AND CB_I = 1
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_1(NULL,NULL,NULL,NULL)}
/* Date: 11/19/2015 Time: 8:52:04
stmt(151766616):*/
SELECT TOP 25 USERID,ITEMNMBR,LOCNCODE,MRPISSUEDATE_I,SHORTAMOUNT_I_1,SHORTAMOUNT_I_2,VENDORID,ORD,DECPLQTY,STR30,Buy_Total,UOFM,RELEASEDATE_I,RNNMBR,ITEMDESC,DEX_ROW_ID FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK, READUNCOMMITTED) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa')) ORDER BY USERID ASC ,RELEASEDATE_I ASC ,ITEMNMBR ASC ,LOCNCODE ASC ,DEX_ROW_ID ASC
/* Date: 11/19/2015 Time: 8:52:04
stmt(151748376):*/
SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa'))
/* Date: 11/19/2015 Time: 8:52:04
stmt(151766616):*/
SELECT TOP 25 USERID,ITEMNMBR,LOCNCODE,MRPISSUEDATE_I,SHORTAMOUNT_I_1,SHORTAMOUNT_I_2,VENDORID,ORD,DECPLQTY,STR30,Buy_Total,UOFM,RELEASEDATE_I,RNNMBR,ITEMDESC,DEX_ROW_ID FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK, READUNCOMMITTED) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa')) AND USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE = 'PACK' ORDER BY USERID ASC ,RELEASEDATE_I ASC ,ITEMNMBR ASC ,LOCNCODE ASC ,DEX_ROW_ID ASC
/* Date: 11/19/2015 Time: 8:52:04
stmt(151748376):*/
SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa'))
/* Date: 11/19/2015 Time: 8:52:04
stmt(151748376):*/
SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE >= 'PACK') OR (USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR > '005 80/20') OR (USERID = 'sa' AND RELEASEDATE_I > '2015.11.05') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa'))
/* Date: 11/19/2015 Time: 8:52:04
stmt(151766616):*/
SELECT TOP 25 USERID,ITEMNMBR,LOCNCODE,MRPISSUEDATE_I,SHORTAMOUNT_I_1,SHORTAMOUNT_I_2,VENDORID,ORD,DECPLQTY,STR30,Buy_Total,UOFM,RELEASEDATE_I,RNNMBR,ITEMDESC,DEX_ROW_ID FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK, READUNCOMMITTED) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa')) AND (USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE = 'PACK' AND DEX_ROW_ID > 1969 OR USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE > 'PACK' OR USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR > '005 80/20' OR USERID = 'sa' AND RELEASEDATE_I > '2015.11.05' OR USERID > 'sa') ORDER BY USERID ASC ,RELEASEDATE_I ASC ,ITEMNMBR ASC ,LOCNCODE ASC ,DEX_ROW_ID ASC
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}
/* Date: 11/19/2015 Time: 8:52:04
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151742952):*/
{ CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 2, 346, 10, 0 ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151748376):*/
{CALL ZTEST.dbo.zDP_PRL10030L_1('sa',-99999999999999.99999,'sa',99999999999999.99999)}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151737528):*/
{ CALL DYNAMICS.dbo.zDP_SY10550SS_1 ( 'sa', 2 ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151724760):*/
{ CALL DYNAMICS.dbo.zDP_SY10800SS_1 ( 'DEFAULTUSER', 0, 85, 2 ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030N_1(25,'sa','17100',NULL,NULL,NULL,NULL)}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151762096):*/
{CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151766616):*/
{CALL ZTEST.dbo.zDP_MRP1010F_2('sa','17100','','sa','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151750184):*/
{ CALL ZTEST.dbo.zDP_IVR10015SS_1 ( '005 80/20' ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151750184):*/
{ CALL ZTEST.dbo.zDP_IVR10015SS_1 ( '005 80/20' ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151740240):*/
{ CALL ZTEST.dbo.zDP_IV00102SS_2 ( 'WIREROOM', '005 80/20' ) }
/* Date: 11/19/2015 Time: 8:52:06
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800L_1('sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',-32768,'sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',32767)}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151726568):*/
BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY00800SI 100, 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 0, '', @num OUT SELECT @num END
/* Date: 11/19/2015 Time: 8:52:06
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800F_2('Utility','','','Utility','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800F_2('PM RECONCILE','PM RECONCILE','zTest <TEST>','PM RECONCILE','PM RECONCILE','zTest <TEST>')}
/* Date: 11/19/2015 Time: 8:52:06
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800F_2('TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>')}
/* Date: 11/19/2015 Time: 8:52:06*/
BEGIN TRANSACTION if exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = ? and table_path_name = 'DYNAMICS.dbo.SY00800') begin commit transaction raiserror ('DEXSHR',15,2) end else begin BEGIN UPDATE DYNAMICS.dbo.SY00800 SET TRXSOURC = ? WHERE TRXSOURC = ? AND WINTYPE = ? AND USERID = ? AND CMPNYNAM = ? AND BCHSOURC = ? AND BACHNUMB = ? SELECT @@rowcount END commit transaction end
/* Date: 11/19/2015 Time: 8:52:06*/
Prepared stmt(151722048):
/* Date: 11/19/2015 Time: 8:52:07
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:07*/
BEGIN UPDATE ZTEST.dbo.POP40100 SET PONUMBER = ?, MODIFDT = ? WHERE PONUMBER = ? AND MODIFDT = ? AND INDEX1 = ? SELECT @@rowcount END
/* Date: 11/19/2015 Time: 8:52:07*/
Prepared stmt(151724760):
/* Date: 11/19/2015 Time: 8:52:07
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151729280):*/
BEGIN DECLARE @num int EXEC ZTEST.dbo.zDP_POP10100SI 'PO000112', 0, 0, 0, '', '', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '', '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', '', 0.00000, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0.00000, 0, 0.00000, '1900.01.01', '1900.01.01', 0, '', 0, '1900.01.01', '1900.01.01', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0.00000, '', 0, '', '', 0.0000000, '1900.01.01', '00:00:00', 0, 0.0000000, 0, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0.00000, 0.00000, 0, '1900.01.01', '', '1900.01.01', '', 0, 0, 0, 0, 0, 0x00000000, 0, '', 0, 0, 0, 0, 0, '', '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0, 0.00000, 0.00000, '', '1900.01.01', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0.00000, 0, 0, 0, 0, 0, 0.00000, 0.00000, @num OUT SELECT @num END
/*
/* Date: 11/19/2015 Time: 8:52:07
SQLSTATE:(01000) Native Err:(5701) stmt(0):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'master'.*/
/*
/* Date: 11/19/2015 Time: 8:52:07
SQLSTATE:(01000) Native Err:(5703) stmt(0):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english.*/
/*
/* Date: 11/19/2015 Time: 8:52:07
SQLSTATE:(00000) Native Err:(5703) stmt(0):*/
*/
/*
/* Date: 11/19/2015 Time: 8:52:07
SQLSTATE:(00000) Native Err:(5703) status(0):*/
SWSTATUS DUMP*/
/* Date: 11/19/2015 Time: 8:52:07
stmt(151727472):*/
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET NUMERIC_ROUNDABORT OFF
END
/* Date: 11/19/2015 Time: 8:52:07
stmt(151726568):*/
insert into tempdb.dbo.DEX_LOCK values (90,347,'ZTEST.dbo.POP10100')
/* Date: 11/19/2015 Time: 8:52:07
stmt(151726568):*/
{ CALL ZTEST.dbo.zDP_POP30100SS_1 ( 'PO000112' ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151727472):*/
{CALL ZTEST.dbo.zDP_POP10500F_2('PO000112',-2147483648,-32768,-32768,'',-2147483648,'PO000112',2147483647,32767,32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ',2147483647)}
/* Date: 11/19/2015 Time: 8:52:07
stmt(151711144):*/
BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY00801SI 1001, 'PO000112', '', 2, 'sa', 1102, '', 0, @num OUT SELECT @num END
/* Date: 11/19/2015 Time: 8:52:07
stmt(151711144):*/
insert into tempdb.dbo.DEX_LOCK values (90,3871061,'DYNAMICS.dbo.SY00801')
/* Date: 11/19/2015 Time: 8:52:07
stmt(151729280):*/
{CALL DYNAMICS.dbo.zDP_SY00801F_1(1001,2,'PO000112','','',1001,2,'PO000112','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:07*/
BEGIN UPDATE DYNAMICS.dbo.SY00801 SET USECT = ? WHERE RULEID = ? AND RSRCID = ? AND RSRCSBID = ? AND CMPANYID = ? AND USERID = ? SELECT @@rowcount END
/* Date: 11/19/2015 Time: 8:52:07*/
Prepared stmt(151712048):
/* Date: 11/19/2015 Time: 8:52:07*/
Prepared stmt(151713856):
/* Date: 11/19/2015 Time: 8:52:07
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151711144):*/
{ CALL DYNAMICS.dbo.zDP_SY01500SS_1 ( 2 ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151711144):*/
{ CALL DYNAMICS.dbo.zDP_SY01500SS_1 ( 2 ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151716568):*/
{ CALL ZTEST.dbo.zDP_WF100002SS_3 ( 1, 'Purchase Order Approval' ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151714760):*/
BEGIN DECLARE @stored_proc_name char(31) DECLARE @retstat int DECLARE @param3 numeric(19,5) DECLARE @param4 int set nocount on SELECT @stored_proc_name = 'DYNAMICS.dbo.smGetNextNoteIndex' EXEC @retstat = @stored_proc_name 2, 90, @param3 OUT, @param4 OUT SELECT @retstat, @param3, @param4 set nocount on END
/* Date: 11/19/2015 Time: 8:52:07
stmt(151713856):*/
BEGIN DECLARE @stored_proc_name char(31) DECLARE @retstat int DECLARE @param3 numeric(19,5) DECLARE @param4 int set nocount on SELECT @stored_proc_name = 'DYNAMICS.dbo.smGetNextNoteIndex' EXEC @retstat = @stored_proc_name 2, 90, @param3 OUT, @param4 OUT SELECT @retstat, @param3, @param4 set nocount on END
/* Date: 11/19/2015 Time: 8:52:07
stmt(151741144):*/
{ CALL ZTEST.dbo.zDP_PM00200SS_1 ( '17100' ) }
/* Date: 11/19/2015 Time: 8:52:07
stmt(151741144):*/
{ CALL ZTEST.dbo.zDP_PM00200SS_1 ( '17100' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151713856):*/
{ CALL ZTEST.dbo.zDP_PM00300SS_1 ( '17100', 'MAIN' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151714760):*/
{ CALL ZTEST.dbo.zDP_SY03300SS_1 ( '2% 15/NET 30 DAYS' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151717472):*/
{CALL ZTEST.dbo.zDP_CO40100F_1(NULL,NULL)}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151737528):*/
{ CALL DYNAMICS.dbo.zDP_MC40200SS_1 ( 'Z-US$' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151777816):*/
{ CALL DYNAMICS.dbo.zDP_MC60100SS_1 ( 2, 'Z-US$' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151748376):*/
{CALL ZTEST.dbo.zDP_PRL10030L_1('sa',-99999999999999.99999,'sa',99999999999999.99999)}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151748376):*/
SELECT TOP 25 USERID,LNSEQNBR,STRNG132,DEX_ROW_ID FROM ZTEST.dbo.PRL10030 WHERE USERID = 'sa' AND USERID = 'sa' AND LNSEQNBR = 1.00000 ORDER BY USERID ASC ,LNSEQNBR ASC
/* Date: 11/19/2015 Time: 8:52:08
stmt(151778720):*/
BEGIN DECLARE @num int EXEC ZTEST.dbo.zDP_PRL10030SI 'sa', 1.00000, 'The currency ID couldn''t be used. Be sure that the currency ID is set up correctly in the Currency Setup window, Multicurrency Access', @num OUT SELECT @num END
/* Date: 11/19/2015 Time: 8:52:08
stmt(151716568):*/
{ CALL ZTEST.dbo.zDP_WF100002SS_3 ( 1, 'Purchase Order Approval' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151781432):*/
{ CALL ZTEST.dbo.zDP_SY03900SS_1 ( 237.00000 ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151787760):*/
{ CALL ZTEST.dbo.zDP_POP10150SS_1 ( 'PO000112' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151785952):*/
{CALL ZTEST.dbo.zDP_CO00102F_1('0\PM\Purchase Order\','','0\PM\Purchase Order\','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:08*/
BEGIN UPDATE ZTEST.dbo.POP40100 SET PONUMBER = ? WHERE PONUMBER = ? AND INDEX1 = ? SELECT @@rowcount END
/* Date: 11/19/2015 Time: 8:52:08*/
Prepared stmt(151786856):
/* Date: 11/19/2015 Time: 8:52:08
stmt(151754864):*/
{ CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151778720):*/
BEGIN DELETE FROM ZTEST.dbo.POP10100 WHERE PONUMBER = 'PO000112' SELECT @@rowcount END
/* Date: 11/19/2015 Time: 8:52:08*/
Prepared stmt(151775104):
/* Date: 11/19/2015 Time: 8:52:08
stmt(151729280):*/
{ CALL DYNAMICS.dbo.zDP_SY00801SS_1 ( 1001, 2, 'PO000112', '', 'sa' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151778720):*/
insert into tempdb.dbo.DEX_LOCK values (90,3871061,'DYNAMICS.dbo.SY00801')
/* Date: 11/19/2015 Time: 8:52:08
stmt(151772392):*/
BEGIN DELETE FROM DYNAMICS.dbo.SY00801 WHERE RULEID = 1001 AND RSRCID = 'PO000112' AND RSRCSBID = '' AND CMPANYID = 2 AND USERID = 'sa' SELECT @@rowcount END
/* Date: 11/19/2015 Time: 8:52:08*/
Prepared stmt(151776912):
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{ CALL DYNAMICS.dbo.zDP_SY00800SS_1 ( 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 100 ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
BEGIN DELETE FROM DYNAMICS.dbo.SY00800 WHERE WINTYPE = 100 AND USERID = 'sa' AND CMPNYNAM = 'zTest <TEST>' AND BCHSOURC = 'TRX ACTIVITY' AND BACHNUMB = 'TRX ACTIVITY' and (not exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = 2423084 and table_path_name = 'DYNAMICS.dbo.SY00800')) SELECT @@rowcount END
/* Date: 11/19/2015 Time: 8:52:08
stmt(151766616):*/
{CALL ZTEST.dbo.zDP_MRP1010F_2('','17100','','','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151766616):*/
{CALL ZTEST.dbo.zDP_MRP1010UN_2(1,'','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','','17100','','','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE TABLE ##0080852 (ORDERNUMBER char(31) NOT NULL, ITEMNMBR char(31) NOT NULL, LOCNCODE char(11) NOT NULL, DUEDATE datetime NOT NULL CHECK (DATEPART(hour,DUEDATE) = 0 and DATEPART(minute,DUEDATE) = 0 and DATEPART(second,DUEDATE) = 0 and DATEPART(millisecond,DUEDATE) = 0), QUANTITY numeric(19,5) NOT NULL, MANUFACTUREORDER_I char(31) NOT NULL, ORD int NOT NULL, DEX_ROW_ID int identity NOT NULL)
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
ALTER TABLE ##0080852 ADD CONSTRAINT PK##0080852 PRIMARY KEY CLUSTERED (ORDERNUMBER)
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE PROC ##zDP_0080852S_1 (@ORDERNUMBER char(31)) AS /* 12.00.0311.000 */ set nocount on SELECT TOP 1 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER ORDER BY ORDERNUMBER ASC set nocount off
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE PROC ##zDP_0080852F_1 (@ORDERNUMBER_RS char(31), @ORDERNUMBER_RE char(31)) AS /* 12.00.0311.000 */ set nocount on IF @ORDERNUMBER_RS IS NULL BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 ORDER BY ORDERNUMBER ASC END ELSE IF @ORDERNUMBER_RS = @ORDERNUMBER_RE BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER_RS ORDER BY ORDERNUMBER ASC END ELSE BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER BETWEEN @ORDERNUMBER_RS AND @ORDERNUMBER_RE ORDER BY ORDERNUMBER ASC END set nocount off
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE PROC ##zDP_0080852L_1 (@ORDERNUMBER_RS char(31), @ORDERNUMBER_RE char(31)) AS /* 12.00.0311.000 */ set nocount on IF @ORDERNUMBER_RS IS NULL BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 ORDER BY ORDERNUMBER DESC END ELSE IF @ORDERNUMBER_RS = @ORDERNUMBER_RE BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER_RS ORDER BY ORDERNUMBER DESC END ELSE BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER BETWEEN @ORDERNUMBER_RS AND @ORDERNUMBER_RE ORDER BY ORDERNUMBER DESC END set nocount off
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE PROC ##zDP_0080852N_1 (@BS int, @ORDERNUMBER char(31), @ORDERNUMBER_RS char(31), @ORDERNUMBER_RE char(31)) AS /* 12.00.0311.000 */ set nocount on IF @ORDERNUMBER_RS IS NULL BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ( ORDERNUMBER > @ORDERNUMBER ) ORDER BY ORDERNUMBER ASC END ELSE IF @ORDERNUMBER_RS = @ORDERNUMBER_RE BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER_RS AND ( ORDERNUMBER > @ORDERNUMBER ) ORDER BY ORDERNUMBER ASC END ELSE BEGIN SELECT TOP 25 ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER BETWEEN @ORDERNUMBER_RS AND @ORDERNUMBER_RE AND ( ORDERNUMBER > @ORDERNUMBER ) ORDER BY ORDERNUMBER ASC END set nocount off
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE PROC ##zDP_0080852SI (@ORDERNUMBER char(31), @ITEMNMBR char(31), @LOCNCODE char(11), @DUEDATE datetime, @QUANTITY numeric(19,5), @MANUFACTUREORDER_I char(31), @ORD int, @DEX_ROW_ID int OUT) AS /* 12.00.0311.000 */ set nocount on BEGIN INSERT INTO .##0080852 (ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD) VALUES ( @ORDERNUMBER, @ITEMNMBR, @LOCNCODE, @DUEDATE, @QUANTITY, @MANUFACTUREORDER_I, @ORD) SELECT @DEX_ROW_ID = @@IDENTITY END set nocount off
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776912):*/
CREATE PROC ##zDP_0080852SD (@ORDERNUMBER char(31), @RowsAffected int OUT, @RID int = 0, @TN char(99) = 'TN') AS /* 12.00.0311.000 */ set nocount on BEGIN IF @RID > 0 DELETE FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER AND ( NOT EXISTS ( SELECT 1 FROM tempdb.dbo.DEX_LOCK WHERE row_id = @RID AND table_path_name = @TN ) ) ELSE DELETE FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER SELECT @RowsAffected = @@rowcount END set nocount off
/*
/* Date: 11/19/2015 Time: 8:52:08
SQLSTATE:(S0022) Native Err:(207) stmt(151772392):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'desSPRkmhBBCreh'.*/
/*
/* Date: 11/19/2015 Time: 8:52:08
SQLSTATE:(00000) Native Err:(207) stmt(151772392):*/
*/
/*
/* Date: 11/19/2015 Time: 8:52:08
SQLSTATE:(00000) Native Err:(207) status(41):*/
SWSTATUS DUMP*/
/* Date: 11/19/2015 Time: 8:52:08
stmt(151766616):*/
{CALL ZTEST.dbo.zDP_MRP1010F_3('sa','17100','','','1900.01.01','sa','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞ','9999.12.31')}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151750184):*/
{ CALL ZTEST.dbo.zDP_IVR10015SS_1 ( '005 80/20' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151749280):*/
{ CALL ZTEST.dbo.zDP_IV00103SS_3 ( '005 80/20', '17100' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151742048):*/
{ CALL ZTEST.dbo.zDP_IV00101SS_1 ( '005 80/20' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151749280):*/
{ CALL ZTEST.dbo.zDP_IV00103SS_2 ( '17100', '005 80/20' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151762096):*/
{ CALL ZTEST.dbo.zDP_MRP1030SS_1 ( 'sa', '17100' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{ CALL DYNAMICS.dbo.zDP_SY00800SS_1 ( 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 0 ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151776008):*/
{CALL ZTEST.dbo.zDP_POP10110F_1('PO000112',-2147483648,-32768,'PO000112',2147483647,32767)}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800L_1('sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',-32768,'sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',32767)}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151778720):*/
BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY00800SI 100, 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 0, '', @num OUT SELECT @num END
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800F_2('Utility','','','Utility','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800F_2('PM RECONCILE','PM RECONCILE','zTest <TEST>','PM RECONCILE','PM RECONCILE','zTest <TEST>')}
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{CALL DYNAMICS.dbo.zDP_SY00800F_2('TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>')}
/* Date: 11/19/2015 Time: 8:52:08*/
Prepared stmt(151722048):
/* Date: 11/19/2015 Time: 8:52:08
stmt(151719336):*/
{ CALL ZTEST.dbo.zDP_POP10100SS_1 ( 'PO000112' ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151731992):*/
{ CALL DYNAMICS.dbo.zDP_SY00800SS_1 ( 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 100 ) }
/* Date: 11/19/2015 Time: 8:52:08
stmt(151784144):*/
BEGIN DELETE FROM DYNAMICS.dbo.SY00800 WHERE WINTYPE = 100 AND USERID = 'sa' AND CMPNYNAM = 'zTest <TEST>' AND BCHSOURC = 'TRX ACTIVITY' AND BACHNUMB = 'TRX ACTIVITY' and (not exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = 2423085 and table_path_name = 'DYNAMICS.dbo.SY00800')) SELECT @@rowcount END