-101 THE STATEMENT IS TOO LONG OR TOO COMPLEX

Explanation
 Db2 cannot process the statement
because it exceeds the system limits for length or complexity. This SQLCODE is issued for a variety
of situations, such as:

Too many parameter markers are specified. 

Enablement of parallelism has made the statement too complex.

 FL 503  A query specifies an IN list predicate that has more than 32767 elements. This type of predicate is an accelerator-only function and is supported only for a query that is accelerated to IBM® Db2 Analytics Accelerator for z/OS® version 7, but this IN list feature or query acceleration is not enabled for this query. This query cannot run in Db2 for z/OS if both of these features and their requirements for acceleration are not enabled or satisfied.

System action
 Db2 cannot
process the statement. 

Programmer response
 Divide the statement into shorter or less
complex  SQL statements. 
 If parallelism is enabled for the statement, disable parallelism. You can do that by using the DEGREE(1) bind option for static SQL, or by setting the CURRENT DEGREE special register to '1' for dynamic SQL.

FL 503  If the query specifies an IN list predicate that has more than 32767 (32K) elements in the IN list and you want to accelerate that query, ensure that all of the following requirements and conditions are satisfied at the time the query is prepared or bound, and run, or when the view is created:

This type of IN predicate must specify only SQL constants in the elements list. If this IN predicate specifies other types of elements, the query cannot be accelerated or run in Db2 for z/OS. 

The query contains only functions or features that are supported by IBM Db2 Analytics Accelerator for z/OS version 7, which uses IBM Db2 Warehouse to process SQL statements. 

All tables referenced in the query are added and loaded to an IBM Db2 Analytics Accelerator for z/OS version 7 accelerator, and the target accelerator was started successfully at least once for this Db2 for z/OS subsystem before the query is prepared or bound or the query's view is created.

Query acceleration is enabled for the query by a query acceleration option other than NONE. For more information, see Enabling acceleration of SQL queries.

The list of values includes option 12 for  ACCELERATION OPTIONS field (QUERY_ACCEL_OPTIONS subsystem parameter)  .

The query runs at Db2 for z/OS application compatibility level V13R1M503 or higher.

For more information see, "Accelerator-only support for more than 32K elements in an IN list" in IN predicate.

SQLSTATE
 54001