Caused by: com.ibm.db2.jcc.b.nm: An unexpected token "1" was found following "_MES AS VARCHAR(10))". Expected tokens may include: "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.50.152
A query:
StringBuilder sbQuery = new StringBuilder();
sbQuery.append("SELECT CAST(SUBSTRING(CAST(recMeta.VL_ANO_MES AS VARCHAR(10))1,4)AS INTEGER)");
sbQuery.append(" FROM TB_NOTA_RECURSO_META recMeta");
sbQuery.append(" UNION");
sbQuery.append(" SELECT CAST(SUBSTRING(CAST(recQuesito.VL_ANO_MES_REFERENCIA AS VARCHAR(10))1,4)AS INTEGER)");
sbQuery.append(" FROM TB_NOTA_RECURSO_QUESITO recQuesito");
sbQuery.append(" UNION");
sbQuery.append(" SELECT av360.VL_ANO_REFERENCIA FROM TB_AVALIACAO_360 av360");
Query query = em.createNativeQuery(sbQuery.toString());
List<Integer> resultList = query.getResultList();