Page 1 of 1

BATCH SPUFI

PostPosted: Sat May 21, 2011 10:56 am
by gopal_NKP
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

Re: BATCH SPUFI

PostPosted: Sat May 21, 2011 11:33 am
by enrico-sorichetti
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