API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 3rd, 2016
58
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.08 KB | None | 0 0
raw download clone embed print report
  1. SELECT 'Adl',dskdes,'',dskmgp,count(*),'','','' ,MGRSRT FROM VEHSVMST1.GODLRSK, VEHSVMST1.VMMGRPP WHERE (dskdfl = 'Y' AND dskofl = ' ' AND dskrfl <>'Y') AND MGRDES=DSKDES AND dskdlr IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) GROUP BY MGRSRT,dskmgp,dskdes UNION ALL SELECT 'Brg',dskdes,'',dskmgp,count(*),'','','' ,MGRSRT FROM VEHSVMST1.GODLRSK, VEHSVMST1.VMMGRPP WHERE dskrfl = 'Y' AND MGRDES=DSKDES AND dskdlr IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) GROUP BY MGRSRT,dskmgp,dskdes UNION ALL SELECT 'Clc',dskdes,'',dskmgp,count(*),'','','' ,MGRSRT FROM VEHSVMST1.GODLRSK, VEHSVMST1.VMMGRPP WHERE dsklfl = 'Y' AND MGRDES=DSKDES AND dskdlr IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) GROUP BY MGRSRT,dskmgp,dskdes UNION ALL SELECT 'Dof',dskdes,'',dskmgp,count(*),'','','' ,MGRSRT FROM VEHSVMST1.GODLRSK, VEHSVMST1.VMMGRPP WHERE dskofl <> ' ' AND MGRDES=DSKDES AND dskdlr IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) GROUP BY MGRSRT,dskmgp,dskdes UNION ALL SELECT 'DdsA',dskdes,'',dskmgp,count(*),'','','' ,MGRSRT FROM VEHSVMST1.GODLRSK, VEHSVMST1.VMMGRPP WHERE dskrfl <> 'Y' AND (dskcla='DS' OR dskcla='SR') AND MGRDES=DSKDES AND dskdlr IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) AND CONCAT(DSKCPF, DSKCSF) NOT IN (SELECT CONCAT(DSLCPF , DSLCSF) FROM VEHSVMST1.GODLSLD WHERE DSLCPF=DSKCPF AND DSLCSF=DSKCSF) GROUP BY MGRSRT,dskmgp,dskdes UNION ALL SELECT 'DcsA',dskdes,'',dskmgp,count(*),'','','' ,MGRSRT FROM VEHSVMST1.GODLRSK, VEHSVMST1.VMMGRPP WHERE (dskrfl <> 'Y' AND dskcla <> 'DS' AND dskcla <> 'SR') AND MGRDES=DSKDES AND dskdlr IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) AND CONCAT(DSKCPF, DSKCSF) NOT IN (SELECT CONCAT(DSLCPF , DSLCSF) FROM VEHSVMST1.GODLSLD WHERE DSLCPF=DSKCPF AND DSLCSF=DSKCSF) GROUP BY MGRSRT,dskmgp,dskdes ORDER BY MGRSRT, dskmgp]
  2. [5/3/16 13:31:04:808 BST] 0000009e SystemOut O 01:31:04 Info - : DISResultSet.Static.createFromResultSet - Created successfully [80 rows] of [9 columns]
  3. [5/3/16 13:31:04:840 BST] 0000009e SystemOut O 01:31:04 Info - : goSQL -> End [579ms.]
  4. [5/3/16 13:31:04:840 BST] 0000009e SystemOut O 01:31:04 Info - DISDEV2.DealerStockDataBean: resultSet.getColumnCount() = 9
  5. [5/3/16 13:31:04:840 BST] 0000009e SystemOut O 01:31:04 Info - DISDEV2.DealerStockDataBean: resultSet.getColumnCount() = 9
  6. [5/3/16 13:31:04:840 BST] 0000009e SystemOut O 01:31:04 Info - DISDEV2.DealerStockDataBean: level = 1, toLevel = 2
  7. [5/3/16 13:31:04:840 BST] 0000009e SystemOut O 01:31:04 Info - DISDEV2.DealerStockDataBean: currentKey = 5
  8. [5/3/16 13:31:04:840 BST] 0000009e SystemOut O 01:31:04 Info - : goSQL -> Start [SELECT A.SHLMGR, SUM(A.SHLQTY), B.MGRDES FROM VEHSVMST1.VMSHLMP A LEFT JOIN VEHSVMST1.VMMGRPP B ON (B.MGRKEY = A.SHLMGR) WHERE A.SHLDEL IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) GROUP BY A.SHLMGR, B.MGRDES]
  9. [5/3/16 13:31:04:918 BST] 0000009e SystemOut O 01:31:04 Info - : DISResultSet.Static.createFromResultSet - Created successfully [17 rows] of [3 columns]
  10. [5/3/16 13:31:04:918 BST] 0000009e SystemOut O 01:31:04 Info - : goSQL -> End [78ms.]
  11. [5/3/16 13:31:04:918 BST] 0000009e SystemOut O 01:31:04 Info - : goSQL -> Start [SELECT A.STLMGR, SUM(A.STLQTY), B.MGRDES FROM VEHSVMST1.VMSTLMP A LEFT JOIN VEHSVMST1.VMMGRPP B ON (B.MGRKEY = A.STLMGR) WHERE A.STLDEL IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) GROUP BY A.STLMGR, B.MGRDES]
  12. [5/3/16 13:31:04:933 BST] 0000009e SystemOut O 01:31:04 Info - : DISResultSet.Static.createFromResultSet - Created successfully [16 rows] of [3 columns]
  13. [5/3/16 13:31:04:933 BST] 0000009e SystemOut O 01:31:04 Info - : goSQL -> End [15ms.]
  14. [5/3/16 13:31:04:933 BST] 0000009e SystemOut O 01:31:04 Info - : goSQL -> Start [SELECT A.OIOMGP, COUNT(A.OIOMGP), B.MGRDES FROM VEHSVMST1.GOORDT A LEFT JOIN VEHSVMST1.VMMGRPP B ON (B.MGRKEY = A.OIOMGP) WHERE CONCAT (A.OIOREF, A.OIOINU) NOT IN (SELECT CONCAT (OSDREF, OSDINU) FROM VEHSVMST1.GOORSLD WHERE OSDEAL IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR='9107')) AND A.OIDEAL IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) AND (A.OIOCLA = 'DS' OR A.OIOCLA = 'SR') GROUP BY A.OIOMGP, B.MGRDES]
  15. [5/3/16 13:31:05:777 BST] 0000009e SystemOut O 01:31:05 Info - : DISResultSet.Static.createFromResultSet - Created successfully [8 rows] of [3 columns]
  16. [5/3/16 13:31:05:793 BST] 0000009e SystemOut O 01:31:05 Info - : goSQL -> End [860ms.]
  17. [5/3/16 13:31:05:793 BST] 0000009e SystemOut O 01:31:05 Info - : goSQL -> Start [SELECT A.OIOMGP, COUNT(A.OIOMGP), B.MGRDES FROM VEHSVMST1.GOORDT A LEFT JOIN VEHSVMST1.VMMGRPP B ON (B.MGRKEY = A.OIOMGP) WHERE CONCAT (A.OIOREF, A.OIOINU) NOT IN (SELECT CONCAT (OSDREF, OSDINU) FROM VEHSVMST1.GOORSLD WHERE OSDEAL IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR='9107')) AND A.OIDEAL IN (SELECT GRPDLR FROM VEHSVMST1.GRPDLR WHERE GRPMGR = 9107) AND (A.OIOCLA <> 'DS' AND A.OIOCLA <> 'SR') GROUP BY A.OIOMGP, B.MGRDES]
  18. [5/3/16 13:31:17:527 BST] 0000009e SystemOut O 01:31:17 Info - : DISResultSet.Static.createFromResultSet - Created successfully [11 rows] of [3 columns]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!