View previous topic :: View next topic
|
Author |
Message |
dev9
New User
Joined: 01 Feb 2013 Posts: 6 Location: India
|
|
|
|
Hello All,
Good Day..
Please throw some light on how to invoke SPUFI from REXX program. i have googled& found that we can invoke SPUFI from REXX..
I am thinking to use below procedure
1) Throw Panel & get SQL WHERE predicates information
2) Prepare query & place it in SPUFI input dataset
3) Invoke spufi to excute query ( Here i dont need to display SPUFI panels)
4) Parse SPUFI output dataset to my needs
5) Display results to user
I am able to achieve all steps except invoking SPUFI from REXX
Please help me in this, Thanks in advance |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
There is no need to use "SPUFI".
Search the forum for topics where REXX invokes DB2/SQL. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
I wonder ...
SPUFI ( the real one ) does all that, why reinvent the wheel ?
unfortunately there is too much approximation in the terminology used
all the utilities ( SORT included ) are JCL
all the ways of accessing DB2 outside of a program are SPUFI
how nice if people could learn to use the terminology appropriate to each situation
and... NO, I do not believe that it is related to E2Lness,
just sloppy neurons |
|
Back to top |
|
|
dev9
New User
Joined: 01 Feb 2013 Posts: 6 Location: India
|
|
|
|
Thanks dick,
I have tried using DSNREXX to query DB2 and i dont have corresponding loadlibs in my login procedure so i m getting Routine not found error (at RXSUBCOM('ADD','DSNREXX','DSNREXX'), so i thought as an alternative i can invoke SPUFI to run queries as i can directly run Queries in SPUFI option.
Please advice
Hi Enrico,
Sorry for confusing you with my terminology
My intention was not to reinvent SPUFI, i will do some processing not just display after query excuted (i.e. output dataset after SPUFI ran).
I have mentioned 'Display results to user ' just to make my requirement simple
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
as You were told in Your other topic
]talk to Your support to have the proper libraries in Your logon procedure
DSN910.SDSNLOAD |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
SPUFI is designed to run under the DSN program, but only
online in TSO/ISPF
You could use DSNTEP2 or DSNTEP4 to do "BATCH SPUFI" |
|
Back to top |
|
|
dev9
New User
Joined: 01 Feb 2013 Posts: 6 Location: India
|
|
|
|
yes Enrico, i have tried that option but no luck, my manager rejected my request to have those loadlibs in our team login procedure with some reasons and asked me to look for alternatives..
Thanks |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
And has your shop any tools for adding a load library to a TSO STEPLIB concatenation after log on? |
|
Back to top |
|
|
mjadwani2785
New User
Joined: 28 Apr 2009 Posts: 89 Location: Noida , Dublin
|
|
|
|
Hi ,
On ready prompt
use TSOLIB ACTIVATE DS ('DB2LIB.SDSNLOAD') .
This will add SDSNLOAD to your search order .
Then try DSNREXX .
It should work .
Regards,
Manoj K Jadwani |
|
Back to top |
|
|
|