import errors using operators form sql

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

sivgin

Sage

Posts: 163

Date of registration: Feb 4th 2009

Location: berlin

Monday, March 23rd 2009, 3:06pm

import errors using operators form sql

Hi all,

I have a problem with the '<' or '<=' Operator (less, less or equal) within the <query>-Tag of a etl project definition.

Example:

...
<query> Select ...... AND trunc(j2oracle(d.lprofilevalue),'DDD') < to_date('${on_day_DD_MM_YYYY}','DD.MM.YYYY') </query>

Error Message when I try to add the project to etl server: 2009-03-23 14:25:39,812 ERROR [main] (RemoteClient.java:320) - Error on line 131: The content of elements must consist of well-formed character data or markup.

How can I simply use '<' or '<=' Operators in my project file?

Thanks for helping

sivgin