JDBC Lookup 7.1 not Work in informix

[Former Member]

The jdbclookup this riding with the query "" between the fields, when he arrives in the database informix syntax error

Ex:

SELECT "vlr_tot_icms", "vlr_tot_pis", "vlr_tot_cofins" FROM "lf_lanvda_item" WHERE cod_lanc_contab=167 AND cod_produto_sap='000000000000038002'

standard function jdbclookup that it creates, i execute this in Squirell

direct also not working.

would be the correct

SELECT vlr_tot_icms, vlr_tot_pis, vlr_tot_cofins FROM lf_lanvda_item WHERE cod_lanc_contab=167 AND cod_produto_sap='000000000000038002'

without the "" would work in this case

I have no idea where to change the function does not send the "" quotation marks between the fields?

tks

[Former Member · Accepted solution]

Hi Try without Quotations marks and check, it should work.

[Former Member · Accepted solution]

Hi, but standard function create Quoutations marks, not i create in mapping.

tks

[Former Member]

Hi Wesley,

You could try to configure the JDBC Adapter and set the 'Column Name Delimiter' properly, seems you've got quotation marks there.

cheers,

Edu

[Former Member]

HI edu, not work, the same problem , not chance Query Jdbclookup,  I remove "" e add field in 'Column Name Delimiter'.

[Former Member]

Hi Wesley,

I meant to set that field to 'nothing', as an space.

cheers

[Former Member]

Hi Wesley,

Incase of any database query no need to give quotation in field name and table name, but incase of value which we used in the condition, you have to give quotation.

SELECT name,age FROM STUDENT WHERE name='ABC' AND age=21;

Please apply this and I think it will resolve your issue.

Best Regards,

Sagarika Mishra