Example Procedure Definition

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 );