01-05-09, 02:55 #1Registered User
- Join Date
- Nov 2008
- Delhi, India
Unanswered: If no record found then .. What's default output of ....
I am using output of SQL Server subquery in DB2 query IN clause.
I have a hurdle, if subquery found no record, then what it will return?
Beacuse the output of this query will be input of IN clause in DB2 query, what if nothing is returned by the SQLServer query?
SQL Server SubQuery
select CLNT_ID from CLNT_ACS where INTN_ID=12
SELECT CLNT_ID, CLNT_NM from CLNT WHERE CLNT_ID IN (1234) ORDER BY CLNT_NM
01-05-09, 05:04 #2Registered User
- Join Date
- Jan 2007
- Jena, Germany
How do you tie both queries together? Do you use DB2's federated capabilities or do you build the DB2 query in some sort of application? In the first case (federation), you don't have to worry about this - just nest the query over the nickname into the IN predicate. In the second case, you have to detect this situation in your application and guarantee that DB2 will not see an empty IN-list in the query. Either you do not execute the query at all or you provide a dummy element.Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development