<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[celavi的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/celavi</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; celavi]]></copyright><item><title><![CDATA[MySQL 存储过程 递归 获取所有子节点]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/51135588</link><guid>https://blog.youkuaiyun.com/celavi/article/details/51135588</guid><author>celavi</author><pubDate>Tue, 12 Apr 2016 17:53:08 +0800</pubDate><description><![CDATA[数据表是这样的：
create table BAT_STEP_RELY (
step_id char(5),
rely_step_id char(5)
);



测试数据：

INSERT INTO `bat_step_rely` (`step_id`, `rely_step_id`) VALUES ('2', '1');
INSERT INTO `bat_step_rely]]></description><category></category></item><item><title><![CDATA[修复easyMule for Mac 2.0崩溃造成的任务丢失]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/6319322</link><guid>https://blog.youkuaiyun.com/celavi/article/details/6319322</guid><author>celavi</author><pubDate>Tue, 12 Apr 2011 23:18:00 +0800</pubDate><description><![CDATA[<br />两个文件，一个shell脚本，一个python脚本：<br /> <br />#!/bin/bash
# Filename	: repairEasymule.sh
# Author	: Jasmine Ding ( celavi#126.com )
# Date		: 2011-4-12
# Location	: Shanghai, China
# Purpose	: call parse.xml to repair damaged tasks caused by easyMule e]]></description><category></category></item><item><title><![CDATA[解析csv格式文件的一段C代码]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/6222968</link><guid>https://blog.youkuaiyun.com/celavi/article/details/6222968</guid><author>celavi</author><pubDate>Fri, 04 Mar 2011 12:41:00 +0800</pubDate><description><![CDATA[csv c 代码]]></description><category></category></item><item><title><![CDATA[CICS启动报错：ERZ080095W]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/2142712</link><guid>https://blog.youkuaiyun.com/celavi/article/details/2142712</guid><author>celavi</author><pubDate>Mon, 03 Mar 2008 13:18:00 +0800</pubDate><description><![CDATA[console.XXXXXX文件里的日志：ERZ080095W/0801 03/03/08 12:21:34.886164191 CICS01  524292/0001      : XA_OPEN for Application Server 101 with DB2 for AIX with xa_open string dbname,db2user,###### returned]]></description><category></category></item><item><title><![CDATA[reboot后CICS启动不了]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/2134318</link><guid>https://blog.youkuaiyun.com/celavi/article/details/2134318</guid><author>celavi</author><pubDate>Fri, 29 Feb 2008 18:07:00 +0800</pubDate><description><![CDATA[今天因为DB2的原因重启了服务器，然后发现CICS又启动不了了，google到一个解决方法：http://www-1.ibm.com/support/docview.wss?rs=175&context=SSAL2T&dc=DB520&dc=DB560&uid=swg21281822&loc=en_US&cs=UTF-8&lang=en&rss=ct175other执行/usr/lpp/c]]></description><category></category></item><item><title><![CDATA[SQL0964C  The transaction log for the database is full.  SQLSTATE=57011]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/2111896</link><guid>https://blog.youkuaiyun.com/celavi/article/details/2111896</guid><author>celavi</author><pubDate>Thu, 21 Feb 2008 18:46:00 +0800</pubDate><description><![CDATA[在删除大量数据的时候出现SQL0964C的错误，需要扩展日志空间，方法：db2 get db cfg|grep LOG输出结果：…… Log file size (4KB)                         (LOGFILSIZ) = 1000 Number of primary log files                (LOGPRIMARY) = 1 Number of ]]></description><category></category></item><item><title><![CDATA[DB2表空间管理]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1806238</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1806238</guid><author>celavi</author><pubDate>Sat, 29 Sep 2007 11:49:00 +0800</pubDate><description><![CDATA[表空间是数据库及存储在该数据库中的表之间的逻辑层。表空间在数据库中创建，表在表空间中创建。　　使用表空间的一个明显的好处是能够把数据合理的分布存储在不同的磁盘上或者存储在磁盘的不同位置上，有助于提高数据存取的效率。　　DB2 的表空间按管理方式分为两种：系统管理空间（System Management Space，SMS）和数据库管理空间（Database Management Space，DMS]]></description><category></category></item><item><title><![CDATA[AIX上vim的语法高亮]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1782334</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1782334</guid><author>celavi</author><pubDate>Wed, 12 Sep 2007 15:46:00 +0800</pubDate><description><![CDATA[    首先要安装vim（官方网站：http://www.vim.org/），下载地址：ftp://ftp.home.vim.org/pub/vim/unix/vim-6.4.tar.bz2；    上传到AIX服务器，执行解压命令：bzip2 -d vim-6.4.tar.bz2; tar -xvf vim-6.4.tar；    切换到root用户，进入vim64目]]></description><category></category></item><item><title><![CDATA[用ACCESS查看DB2的表]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1757408</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1757408</guid><author>celavi</author><pubDate>Fri, 24 Aug 2007 13:56:00 +0800</pubDate><description><![CDATA[到IBM主页下载DB2客户端（DB2 Client），如果链接失效，则访问该地址：http://www.ibm.com/developerworks/cn/db2/v9/index_download.html，下载需要登录IBM。文件比较大，近300M，用Flashget等下载工具下比较快。下载完成后开始安装，运行CLIENT/image目录下的setup.exe文件，打开DB2安装启动板，左边的]]></description><category></category></item><item><title><![CDATA[怎么看一个文本文件的编码]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1755231</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1755231</guid><author>celavi</author><pubDate>Thu, 23 Aug 2007 00:13:00 +0800</pubDate><description><![CDATA[打开记事本，菜单“文件”-“打开”，找到目标文件，选中，这时下面的编码中显示的就是这个文件的编码，ANSI, Unicode, Unicode big endian, UTF-8。Quixote对unicode的处理，目前不知道有没有完全搞定，之前PTL文件里title如果是中文会报错：UnicodeDecodeError: ascii codec cant decode byte 0xc3]]></description><category></category></item><item><title><![CDATA[豆瓣(douban.com)和Python、Quixote的文章合集]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1754045</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1754045</guid><author>celavi</author><pubDate>Wed, 22 Aug 2007 11:35:00 +0800</pubDate><description><![CDATA[向阿北哥请教？    2005-12-31 21:54:09 　　来自: zh00yi (南京)　　douban是用quixote和twisted做的，但好象都是python的web framework，为什么要用两个呢？能告诉我这两个分别用来做什么吗？？我很想知道这方面的事，当然如果这属于商业秘密的话，可以不说的。。    2005-12-31 22:58:48 阿北 (北京)　　quixote]]></description><category></category></item><item><title><![CDATA[TypeError: expected a character buffer object]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1753170</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1753170</guid><author>celavi</author><pubDate>Tue, 21 Aug 2007 17:10:00 +0800</pubDate><description><![CDATA[这个错误弄了一个下午才搞定！        for row in rows:            print row                        %s % row[2]            %s % row[1]            %s % row[3].replace("/r/n", "")            改为    ]]></description><category></category></item><item><title><![CDATA[Quixote学习笔记（5）]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1746429</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1746429</guid><author>celavi</author><pubDate>Thu, 16 Aug 2007 13:27:00 +0800</pubDate><description><![CDATA[The _q_resolve() methodNote that the ExtraDirectory class inherits from Resolving (in addition to Directory).  The Resolving mixin modifies the _q_traverse() so that, when a component has an attri]]></description><category></category></item><item><title><![CDATA[Quixote学习笔记（4）]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1744963</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1744963</guid><author>celavi</author><pubDate>Wed, 15 Aug 2007 14:18:00 +0800</pubDate><description><![CDATA[The _q_lookup() methodNow take a look at the ExtraDirectory class in extras.ptl.  This class exhibits some more advanced publishing features.  If you look back at the default _q_traverse() impleme]]></description><category></category></item><item><title><![CDATA[Quixote学习笔记（3）]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1742856</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1742856</guid><author>celavi</author><pubDate>Tue, 14 Aug 2007 16:24:00 +0800</pubDate><description><![CDATA[Understanding the root demoStart the root demo by running the command:simple_server.py --factory quixote.demo.create_publisherIn a browser, open http://localhost:8080 as before. Click around at ]]></description><category></category></item><item><title><![CDATA[Quixote学习笔记（2）]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1741051</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1741051</guid><author>celavi</author><pubDate>Mon, 13 Aug 2007 17:24:00 +0800</pubDate><description><![CDATA[Understanding the mini_demoStart the mini demo by running the command:simple_server.py --factory quixote.demo.mini_demo.create_publisherIn a browser, load http://localhost:8080.  In your browser]]></description><category></category></item><item><title><![CDATA[Quixote学习笔记（1）]]></title><link>https://blog.youkuaiyun.com/celavi/article/details/1736495</link><guid>https://blog.youkuaiyun.com/celavi/article/details/1736495</guid><author>celavi</author><pubDate>Fri, 10 Aug 2007 17:04:00 +0800</pubDate><description><![CDATA[Running the Quixote DemosQuixote comes with some demonstration applications in the demo directory. After quixote is installed (see INSTALL.txt for instructions), you can run the demos using the scri]]></description><category></category></item></channel></rss>