<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>吾爱缘分 - 导读 - 最新发表</title>
    <link>https://52yfw.com/forum.php?mod=guide&amp;view=newthread</link>
    <description>最新发表</description>
    <copyright>Copyright(C) 吾爱缘分</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Sun, 08 Nov 2026 16:16:39 +0000</lastBuildDate>
    <ttl>30</ttl>
    <image>
      <url>https://52yfw.com/static/image/common/logo_88_31.gif</url>
      <title>吾爱缘分</title>
      <link>https://52yfw.com/</link>
    </image>
    <item>
      <title>DB2查询药房中的重复批次的药品</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=35</link>
      <description><![CDATA[---查询药房中的重复批次的药


SELECT *FROM YW_YF_YPKC WHERE YYBM=\'001\' AND YPBM IN(SELECT YPBM FROM YW_YF_YPKC WHERE YYBM=\'001\' GROUP BY YFBM,YPBM,PC HAVING COUNT(*)&gt;1) ORDER BY YPBM;]]></description>
      <category>[工作记录]</category>
      <author>admin</author>
      <pubDate>Thu, 06 Feb 2025 07:29:33 +0000</pubDate>
    </item>
    <item>
      <title>DB2数据库服务重新启动</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=34</link>
      <description><![CDATA[1.先把所有的java进程结束掉，并且把数据库管理工具也关闭；
2.按  【win】+【r】   打开输入“db2cmd” 回车出来命令框，然后输“db2stop”，

3.等待停止后输“db2start”启动服务，提示处理成功即可；

4.输入“db2  connect to hy2234”后敲回车，可能会有点慢；


 ...]]></description>
      <category>[DB2数据库]</category>
      <author>admin</author>
      <pubDate>Thu, 06 Feb 2025 07:17:15 +0000</pubDate>
    </item>
    <item>
      <title>DB2数据库查询是否锁表</title>
      <link>https://52yfw.com/forum.php?mod=viewthread&amp;tid=33</link>
      <description><![CDATA[1.查询是否有锁表：                                                                                          
SELECT * FROM TABLE (SNAP_GET_LOCK (\'\', -1)) AS T WHERE lock_object_type = \'TABLE_LOCK\'

2.查询所有被锁的表

SELECT \'CALL SYSPROC.ADMIN_CMD(\&quot; ...]]></description>
      <category>[DB2数据库]</category>
      <author>admin</author>
      <pubDate>Thu, 06 Feb 2025 07:13:26 +0000</pubDate>
    </item>
  </channel>
</rss>