In the UNIX environment, you can use the keyword PIPE to send the query results to another program, as the following example shows:
OUTPUT TO PIPE more SELECT customer_num, call_dtime, call_code FROM cust_calls
Related statements: SELECT and UNLOAD