An example procedure definition that supports TPF PARTITION BY clause examples.
All TPF PARTITION BY clause examples in this section assume that you first execute this procedure definition:
CREATE PROCEDURE my_tpf( arg1 TABLE( c1 INT, c2 INT ) ) RESULTS ( r1 INT, r2 INT, r3 INT ) EXTERNAL ‘my_tpf_proc@mylibrary’; CREATE TABLE T( x INT, y INT, z INT );