1206 error when connected to 'remote' INFORMIXSERVER

I am working on host server1 and my INFORMIXSERVER is local1. In my SQLHOSTS file there is entry for remote INFORMIXSERVER remote1 located on host server2. I write select statement in dbaccess select * from datab@remote1:posdne where postbr='88999' and danas = '' and what I get is 1206 error. I log on server2 and run onstat -g sql ##and here is what I get: select x0.danas ,x0.postbr ,x0.prtime ,x0.odtime ,x0.aktpos ,x0.aktsal ,x0.kradan ,x0.numipr ,x0.numiod ,x0.glabla ,x0.prijave ,x0.dnevni ,x0.dnerad ,x0.tkpren ,x0.dodsw1 ,x0.dodsw2 ,x0.dodsw3 ,x0.dodsw4 ,x0.dodsw5 ,x0.dodsw6 ,x0.statis ,x0.zbrojr ,x0.zbrojz from datab:"informix".posdne x0 where ((x0.danas = DATE ('NULL' ) ) AND (x0.postbr = '88999' ) ) Empty string from my statement is converted to DATE('NULL') and that is the reason for error. But if I connect to INFOMRIXSERVER remote1 (dbaccess -> Connection -> Connect -> remote1) and run the query there is no error and onstat -g sql ##returns select * from datab@remote1:posdne where postbr='88999' and danas = '' Is there any way to avoid that behavior? Env. variable or some other trick? Nebojsa ------------------------------------ Remove spam block (DELETE) to reply