SqlDbx Forum

SqlDbx

You are not logged in.

#1 Re: IBM DB2 » UDB SUB SELECT QUERY NOT VALIDATED » 2010-02-20 13:46:46

Rag_veer

Yes it is T1. UDB 9.5. Similar query in Sybase gives error. If u use ODBC query tool it also gives error. But SQLDBx latest free edition is not giving errors and giving results.

#2 IBM DB2 » UDB SUB SELECT QUERY NOT VALIDATED » 2010-02-18 15:28:59

Rag_veer
Replies: 4

Ran a query with sub select (having wrong field name) the query ran gave results without error. The subselect is ingnored.

Ex: Select F1, F2, F3 from T! Where F1 in (SELECT F11 from T2).

Here there is a typo in F11 supposed to be F1 but the query ran by ignoring the sub select.

Board footer

Powered by FluxBB