SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

AND partnum = 5100),
'standard', ?param);
The generated shape describes all subquery trees and contains an ANYTHING token to represent
the CALL statement, as shown:
control query shape nested_join(nested_join(sort_groupby(partition_access(
scan(path 'SAMDBCAT.SALES.ODETAIL', forward, blocks_per_access 1
, mdam off))),tuple),anything);
--- SQL operation complete.
If the result of the SHOWSHAPE command is undesirable, you can use the CONTROL QUERY
SHAPE statement to force the execution plan. First generate the result of the EXPLAIN function for
a prepared CALL statement, and then modify the operator tree for the execution plan by using
CONTROL QUERY SHAPE.
For more information about the SHOWSHAPE command and the CONTROL QUERY SHAPE
statement, see the SQL/MX Reference Manual. For information about forcing execution plans, see
the SQL/MX Query Guide.
104 Performance and Troubleshooting