PRSQL9103007: Running a Query with an IN Clause GP-Faults SQL

ID Number: Q70827

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103007

SYMPTOMS

Running a query with an IN clause GP-faults SQL SERVER.

CAUSE

This problem occurs if there are more than 250 parameters in the

IN clause.

RESOLUTION

Place the parameter values into a table, and run the query against

this table. For example:

Select @pb from table where @pb in (select col1 from newtab)