Error in getRS: [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001query: SELECT DISTINCT C.parobjid AS objid, C.parsubid AS subid, C.pos FROM con C, con P WHERE C.objid=15 AND C.subid=0?id=15 AND C.rtypeid=2 AND C.parobjid<>0 AND P.objid=C.parobjid AND P.subid=C.parsubid AND P.rtypeid IN (5,6,7) AND P.parobjid in (3) ORDER BY C.pos
|
|
GloriaQuery, ParsingError: subid part of id must be a number format example: 12.3
Error in getRS: [IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token ")" was found following "bjid=rel.objid and (". Expected tokens may include: "". SQLSTATE=42601
query: select distinct rel.*, obj.modified, obj.otypeid, CASE WHEN r.objid IS NULL THEN 0 ELSE 1 END AS read, CASE WHEN w.objid IS NULL THEN 0 ELSE 1 END AS write from rel left join con w on w.objid=rel.objid and w.subid=rel.subid and w.parobjid in (3,-1) and w.rtypeid=6 join con r on r.objid=rel.objid and r.subid=rel.subid and r.parobjid in (3,-1) and r.rtypeid=5 , obj where not rel.locked=1 and ((rel.inspire is null or rel.inspire<'2007-11-04 14:47:55.274867') and (rel.expire is null or rel.expire>'2007-11-04 14:47:55.274898')) and obj.objid=rel.objid and ()
|
|
 |
|
