Re: SQL sessions

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Stu Allen wrote:

>  Is there any way to get at the sql session 
>  transcript that a user gets when they 
>  STRSQL, other than signing on as that user?

Dave Mahadevan and Chuck Pence answered this years ago.  Credit belongs to
them:
             
You can get the list of sessions from:
DMPSYSOBJ ISQLENyouruserid* QRECOVERY 19 EE
             
For multiples you will have multiple "NAME-" in the spooled output
QPSRVDMP..
The "NAME-" is positionally in bytes:
01-06  ::  ISQLEN
07-16  ::  User profile starting the session..
17-26  ::  Workstation device name for session selection
27-30  ::  Session number for that workstation ID <0000 is first>

The actual statements are stored here:
DMPSYSOBJ ISQLSTyouruserid* QRECOVERY 19 EE

Buck Calabro
Aptis; Albany, NY
"We are what we repeatedly do.
 Excellence, then, is not an act, but a habit." --Aristotle


Billing Concepts Corp., a NASDAQ Listed Company, Symbol: BILL
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---