I am querying a db2 db via odbc and my query is including a where condition which is too long (15k names).
is there a way to rephrase the query to get the driver to accept this long list.
current query is:
select sknum, skcli, sktit, skdatc, skmont, skart, skaf, skqte, skgenr from srl where (skgenr = 'A' or skgenr = 'V')
and (skdatc between 20070101 and 20100331)
and (skcli='xxxxx' or skcli='yyyyyyyyy' or ..... 15000 names ......... or skcli='zzzzzzz' )