Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to invoke Spufi from REXX to query DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dev9

New User


Joined: 01 Feb 2013
Posts: 6
Location: India

PostPosted: Wed Feb 27, 2013 12:35 pm    Post subject: How to invoke Spufi from REXX to query DB2
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


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

PostPosted: Wed Feb 27, 2013 1:28 pm    Post subject:
Reply with quote

Hello,

There is no need to use "SPUFI".

Search the forum for topics where REXX invokes DB2/SQL.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Wed Feb 27, 2013 1:42 pm    Post subject: Reply to: How to invoke Spufi from REXX to query DB2
Reply with quote

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 icon_cool.gif
Back to top
View user's profile Send private message
dev9

New User


Joined: 01 Feb 2013
Posts: 6
Location: India

PostPosted: Wed Feb 27, 2013 2:02 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Wed Feb 27, 2013 2:11 pm    Post subject: Reply to: How to invoke Spufi from REXX to query DB2
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Feb 27, 2013 2:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dev9

New User


Joined: 01 Feb 2013
Posts: 6
Location: India

PostPosted: Wed Feb 27, 2013 2:26 pm    Post subject: Reply to: How to invoke Spufi from REXX to query DB2
Reply with quote

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..icon_sad.gif

Thanks
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Sat Mar 02, 2013 2:09 am    Post subject:
Reply with quote

And has your shop any tools for adding a load library to a TSO STEPLIB concatenation after log on?
Back to top
View user's profile Send private message
mjadwani2785

New User


Joined: 28 Apr 2009
Posts: 89
Location: Noida , Dublin

PostPosted: Thu Apr 04, 2013 2:03 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us