ksql

hzty

select so.SID as sid,so.SDOCNAME as sdocname,so.SDOCPATH as sdocpath,so.SFILEID as sfileid,SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 3) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 4) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 3) - 1) as unit,SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 4) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 5) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 4) - 1) as pyear,SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 5) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 6) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 5) - 1) as ppro,SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 6) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 7) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 6) - 1) as step,SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 7) + 1,length(to_char(so.SDOCDISPLAYPATH)) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 7) - 1) as method,to_char(so.SDOCDISPLAYPATH) as sdocdisplaypath from sa_docnode so where so.Sdocliveversionid=1 order by step;

ksql不能执行这个语句啊

System.out.println("******" + pname + "*******档案附件查询********" + pproject + "*******");               
                         String kSqlWhere ="select so.SID as sid,so.SDOCNAME as sdocname,so.SDOCPATH as sdocpath,so.SFILEID as sfileid";
                         kSqlWhere += ",SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 3) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 4) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 3) - 1) as unit";
                         kSqlWhere += ",SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 4) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 5) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 4) - 1) as pyear";
                        kSqlWhere += ",SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 5) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 6) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 5) - 1) as ppro";
                        kSqlWhere += ",SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 6) + 1,INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 7) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 6) - 1) as step";
                        kSqlWhere += ",SUBSTR(to_char(so.SDOCDISPLAYPATH),INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 7) + 1,length(to_char(so.SDOCDISPLAYPATH)) - INSTR(to_char(so.SDOCDISPLAYPATH),'/',1, 7) - 1) as method";
                        kSqlWhere += ",to_char(so.SDOCDISPLAYPATH) as sdocdisplaypath";
                        kSqlWhere += " from sa_docnode so";
                        kSqlWhere += " where so.Sdocliveversionid=1";
                         //kSqlWhere += " and so.SDOCDISPLAYPATH = :pyear";
                         //kSqlWhere += " and so.SDOCDISPLAYPATH = :pname";
                         //kSqlWhere += " and so.SDOCDISPLAYPATH = :pproject";
                        kSqlWhere += " order by step;";
                        Map<String, Object> params = new HashMap<String, Object>();
                        //params.put("pyear", pyear);
                        //params.put("pname", pname);
                        //params.put("pproject", pproject);
                        System.out.println("*****" + pname + "*****档案附件查询结束****" + pproject + "*****");
                        return KSQL.select(kSqlWhere, params, "/audit/fm/data", null);




ksql不能执行这个语句啊

zhaixin

ksql函数中没有to_char，参照API手册，根据ksql现有的函数修改上面ksql中使用的函数

hzty

查你妹，你们知道是哪个函数给上不行吗，转换clob的
没有支持的就没有支持，把问题说到位

jishuang

1.你上面的写法是SQL的语法，那可以用SQL去执行把KSQL.select改为SQL.select，如下：
http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=37485&pid=164951736

2.KSQL中提供的函数如下：
  


3.在KSQL中也可以调用本地SQL函数
如下：