Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Search condition IN
You know the SQL already, it's the SQL I wrote on 23 Jan 08 2:37. -
-
Search condition IN
I use DB2 z/OS 8.2. In this case the problem is not the code because even if I use the Command Editor of DB2 the returned timestamp value is wrong. The original code using hibernate was: Query q = this.session.createQuery(" FROM table_1 WHERE " + classMetaData.getIdentifierPropertyName() + "... -
Search condition IN
The only problem that I now have is that if I select columns of type TIMESTAMP a wrong value is returned, if I use the sysibm.sysdummy1 table in the subselect. If I use another table in the subselect everything is ok. My solution for now is that I do the following (assuming field1 is of type... -
Search condition IN
Yes, this was also my solution which seems to be the only one and works. Thank you very much for all your answers! -
Search condition IN
Yes I know but this does not help very much. It would be great if someone knows a SQL statement equivalent to the mentioned one. Thanks. -
Search condition IN
Hi all, does anyone know why a statement which looks like as follows does not work in DB2 z/OS: SELECT ... WHERE (...,...) IN ((...,...),(...,...)) It works for ORACLE as far as I know.
