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
 

 

Read data from Session table

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

New User


Joined: 14 Apr 2008
Posts: 74
Location: Mysore

PostPosted: Wed Feb 04, 2015 2:31 pm    Post subject: Read data from Session table
Reply with quote

Hi All,

In one of our development project, for testing purpose we need to see the data which gets stored in session tables after each step. But now, we have to open a cursor, fetch it, display it and close the cursor on session table. Instead of this, what i am checking is there any automated solution available to make it uniform open, fetch, display and close just by getting the session table name.

1. Develop a common routine to get the session table name as input
2. try to get the column name, data types of the input session table (not sure which System tables will keep track of this ??)
3. declare, open and fetch from the session table using the column information retrieved from step 2

Please provide your inputs which could help me.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1651
Location: NY,USA

PostPosted: Thu Feb 05, 2015 12:52 am    Post subject:
Reply with quote

That is a part of Automation testing...
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1226
Location: Israel

PostPosted: Thu Feb 05, 2015 8:49 pm    Post subject: Reply to: Read data from Session table
Reply with quote

Not sure I understand exactly what you want to do, but DSNTIAUL could be part of the solution.
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 74
Location: Mysore

PostPosted: Fri Feb 06, 2015 4:40 pm    Post subject:
Reply with quote

Thanks for your reply Marso.

What i wanted to acheive is, retireiving the data from session table when the stored procedure is getting executed.

I will be only knowing the Session table name, the automatic solution (in the form of copybook) should pick up the session table name as input and try to retrieve and display records from the input session table.

Any suggestions.??
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1651
Location: NY,USA

PostPosted: Sat Feb 07, 2015 12:50 am    Post subject:
Reply with quote

I don't know what is the concern here, it looks like a straight 2 programs communication.
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 Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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