BATCH SPUFI



IBM's flagship relational database management system

BATCH SPUFI

Postby gopal_NKP » Sat May 21, 2011 10:56 am

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
gopal_NKP
 
Posts: 22
Joined: Fri Feb 25, 2011 11:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: BATCH SPUFI

Postby enrico-sorichetti » Sat May 21, 2011 11:33 am

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post