Hi All,

I can successfully read one table from SM 9.20 via Web Services and write it to another database with CIT 4.11. But when I try to use pifNewQuery FromFmtName to read another table, CIT fails with strange error message:
---
(-57) Directive 'where' does not exist.
(0) java.lang.UnsupportedOperationException
(16384) Runtime error - Application defined or object defined error.
---

I also tried pifNewQueryFromXml in the mapping script but it fails quite similary. Using string "PartNumber = [RetrieveCPWDeviceListResponse.instance.PartNumber]" as strLayer does not work either.

Some screenshots about the problem attached.

Basically I'm trying to read Device-table and based on Device.PartNumber, I'm trying to read from Models table Models.PartNo and Models.CPWIFID.

Btw are there any good books for Connect-IT 4 available? HP documentation is a good start but I would like to see some real world examples.

With best regards,

-make