IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to run a query using INZUTILB


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
beto981

New User


Joined: 06 Oct 2006
Posts: 24

PostPosted: Wed Dec 23, 2009 1:45 am
Reply with quote

Copy made. Sorry for the stupid question, but how (where) do I change it now?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Dec 23, 2009 1:51 am
Reply with quote

read the source and You will find out by Yourself

here is a hint anyway ...
Code:
  *           PAGEWIDTH   133    Maximum width of a page in          *  03050000
  *                              characters (including the control   *  03060000
  *                              character in column one)            *  03070000
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Dec 23, 2009 1:53 am
Reply with quote

Hello,

And the modified version of the code needs to be in an available library.

You may not have permission to write the copy into the same dataset that contains the original. . .
Back to top
View user's profile Send private message
beto981

New User


Joined: 06 Oct 2006
Posts: 24

PostPosted: Wed Dec 23, 2009 1:57 am
Reply with quote

No, I mean where (PDF,DB2,Insync,etc) can I do the changes? I made, but opening in the PDF I just saw this:

Code:
  XXXXXXXXXX(DSNTEP2)                  Browse substituted
Command ===>                                                  Scroll ===> CSR 
******************************** Top of Data **********************************
......0CEESTART........CEEMAIN ........CEEFMAIN......  CEEBETBL........CEEROOTA
......0DSNTEP2A........DSNTEP28........IELCGIX ... ...QIELCGIB ....... IELCGOG
......0IBMSBGKC........IBMSCACA...\....IBMSCCAA...H....IBMSCCCA........IBMSCCQA
......0IBMSCHFE........IBMSCHFH........IBMSCHFP...-....IBMSCHFY........IBMSCHXD
......0IBMSCTHP... ....IBMSCTHX........IBMSCUID........IBMSCUIE........IBMSCUIF
....<.0IBMSSAIA........IBMSSAOA........IBMSSEDB...&....IBMSSEIA...-....IBMSSEIT
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Dec 23, 2009 3:20 am
Reply with quote

what I posted was a pointer on how to modify the source off dsntep2 in order to adapt it to Your needs.
You are not changing the invocation parameters You are modifying the source in order to create a new program

You have to behave as if it was a program written by you

copy the source from <db2hlq>.sdsnsamp to a library of Your choice,
modify the line I showed You
precompile/compile/link to a load available at run time
bind the dbrm to the proper DB2 subsystem ... and there You are up and running with a modified dsntep2
remember to use a different name
Back to top
View user's profile Send private message
beto981

New User


Joined: 06 Oct 2006
Posts: 24

PostPosted: Wed Dec 23, 2009 5:57 pm
Reply with quote

Tks Enrico, but I don't have direct permission to do all theese steps and I don't know if the responsable will allow this.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Dec 23, 2009 7:43 pm
Reply with quote

Hello,

Quote:
I don't know if the responsable will allow this
If you are not given permission, they will have to do this - or you will need to look for a different solution. . .
Back to top
View user's profile Send private message
beto981

New User


Joined: 06 Oct 2006
Posts: 24

PostPosted: Wed Dec 23, 2009 7:46 pm
Reply with quote

Certainly I will need to look for a different solution!!!
Tks you all!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2 Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts RC query -Time column CA Products 3
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
Search our Forums:

Back to Top