IBM Mainframe Forum

hi,

I am using DSNTEP2 to run an SQL select query .

The output dataset SYSPRINT has both query and output . I want only the output of sql query to the output dataset.
and
if the output of sql query is more than one PAGE, the column names of output table are coming again. I do not want this.

if possible please suggest me.


thanks

evaluate the use of some other <utility> or ...

DSNTEP2 and DSNTEP4 sources are available in <db2_installation_prefix>.SDSNSAMP

You/Your organization are free to modify it/them according to Your needs