Riccardo Prandini

ok but the property has to be a lot specific to not mess around with other apps/ packages

When we use the class we have to work with websphere and other application server managed by specific office an the customization via system propery is not an option everywhere. We have a config file and we act at runtime . Thanks

Yes this one is the solution.

Yes this is the second problem i think that with a customizable substring query the things cold be resolved.

I think this is how sql should be done correctly. if you call each table t1...tn also the occurence of each table should report the same tn and not the original one SELECT t13.CDSERVIZ,t13.DSSERVIZ, t8.CDTIPO,t8.DSTIPO FROM ~aliasDb.TBSTANSE t13, ~aliasDb.TBSTTIDP t8, ~aliasDb.TBSTSETP t12 WHERE ( (t8.CDTIPO = t12.TIPPRE) AND (t13.CDSERVIZ = t12.CODSER) AND (t8.CDABI = '05034') AND (t13.CDABI = '05034') AND (t12.CODABI = '05034') AND (t12.DATINI <= CURRENT DATE) AND (t12.FLGABI > CURRENT DATE) AND...

Yes It Is a DB2 under HOST difference. Il gio 27 feb 2020, 20:47 James Ahlborn jahlborn@users.sourceforge.net ha scritto: is this really a requirement? the db2 documentation shows examples with no spaces: https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_bif_substr.html [feature-requests:#25] Create substring an company* Status: open Group: Unassigned Created: Tue Feb 25, 2020 03:44 PM UTC by Riccardo Prandini Last Updated: Thu Feb 27, 2020 07:38 PM UTC Owner: nobody Best...

My solution is FunctionCall SUBSTR = new FunctionCall(new CustomSql("SUBSTR")).addColumnParams(TBSTSETP_FLGABI).addNumericValueParam(1).addNumericValueParam(1); Query=Query.addCondition(new BinaryCondition(Op.EQUAL_TO, SUBSTR ,"S")); I have the problem that inside a FunctionCall there is private SqlObjectList<SqlObject> _params = SqlObjectList.create(); DB2 function requeres ,<space> to separate items. From (SUBSTR(TBSTSETP.FLGABI,1,1) = 'S')) TO (SUBSTR(TBSTSETP.FLGABI, 1, 1) = 'S')) This could...

Create substring an company