Re: Query/400 Defaults

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Paul:

PaulMmn wrote:

> Until the day you start SQL sessions from more than 1 workstation (or more
> than 1 RUMBA or Client Access session) at the same time.  From that point
> on, you have separate 'prior sessions,' one for each workstation.
>
> How, oh how do we un-do this 'convenience,' and go back to a single
> 'previous session' for a user?

I assume you want to go back to the one session containing all ISQL statements
for all display stations approach.  The trick here is to delete the sessions in
each of the display sessions for your userid.  The following method will work 
but
you will have to delete ALL sessions.  Chuck Pence sent me this info and he told
me IBM does not have any plans to allow for a "delete all sessions" option on 
the
F13 screen.

You can get the list of sessions from:
 DMPSYSOBJ ISQLENyouruserid* QRECOVERY 19 EE

My user profile name is CRP.  Output sample for me with one session:

 DMPSYSOBJ PARAMETERS
 OBJ- ISQLENCRP*                      CONTEXT- QRECOVERY
 TYPE- 19   SUBTYPE-EE
 OBJECT TYPE-           SPACE                                         *MSCSP
 NAME-     ISQLENCRP       QPADEV00790000  TYPE-  19   SUBTYPE-  EE
 LIBRARY-     QRECOVERY                       TYPE-  04   SUBTYPE-  01
 CREATION-    04/28/96  12:53:09              SIZE-     0000003400
 OWNER-       CRP                             TYPE-  08   SUBTYPE-  01

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>

Sign on to the workstation ID for the one you wish to delete, then STRSQL,
then 2=Delete after F3=Exit.  HTH.

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---