View previous topic :: View next topic
|
Author |
Message |
rexx77
New User
Joined: 14 Apr 2008 Posts: 78 Location: Mysore
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
That is a part of Automation testing... |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
Not sure I understand exactly what you want to do, but DSNTIAUL could be part of the solution. |
|
Back to top |
|
|
rexx77
New User
Joined: 14 Apr 2008 Posts: 78 Location: Mysore
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
I don't know what is the concern here, it looks like a straight 2 programs communication. |
|
Back to top |
|
|
|